SQLite Tutorial for Beginner

SQLite is a relational database management system. It is a light weight and fast performing database model preferred by low to medium traffic websites. In this tutorial, we will cover the important concept of SQlite like accessing SQlite database, data types, joins, modifying data, etc.

Here is what we cover in the Course

1. What is SQLite?

2. Download and Install SQLite

3. Sqlite Database Tutorial

4. SQLite Create, Alter, Drop Table

5. SQLite Primary & Foreign Key Tutorial

6. All About Data Types In sqlite

7. SQLite — Select, Where, Limit, Count, Group By, Union

8. SQLite Join — INNER, NATURAL, LEFT OUTER, CROSS

9. SQLite Query — INSERT, UPDATE, DELETE

10. Sqlite Index, Trigger & View

11. SQLite Functions — REPLACE, TRIM, ABS, ROUND, LENGTH, SUBSTR