SQLite Tutorial

• SQLite Tutorial
• SQL vs SQLite
• SQLite History
• SQLite Features
• SQLite Advantages
• SQLite Installation
• SQLite Commands
• SQLite Syntax
• SQLite Data Types
• SQLite Operators
• SQLite Expressions

Databases

• SQLite Create DB
• SQLite Attach DB
• SQLite Detach DB

Table

• SQLite Create Table
• SQLite Drop Table

CRUD Operation

• SQLite Insert Query
• SQLite Select Query
• SQLite Update Query
• SQLite Delete Query

Clauses/Conditions

• SQLite WHERE
• SQLite AND
• SQLite OR
• SQLite LIKE
• SQLite Glob
• SQLite Limit
• SQLite Order By
• SQLite Group By
• SQLite Having
• SQLite Distinct
• SQLite Union
• SQLite Union All

SQLite Joins

• SQLite Joins
• SQLite Inner Join
• SQLite Outer Join
• SQLite Cross Join

SQLite Date & Time

• SQLite Date and Time
• SQLite date()
• SQLite datetime()
• SQLite juliandday()
• SQLite now()
• SQLite strftime()
• SQLite time()

Aggregate Functions

• Aggregate Functions
• SQLite MIN
• SQLite MAX
• SQLite AVG
• SQLite COUNT
• SQLite SUM

SQLite Triggers

• SQLite Triggers
• After Insert
• After Update
• After Delete
• SQLite Drop Trigger

SQLite Keys

• Primary Key
• Foreign Key

SQLite Import/Export

• SQLite Import
• SQLite Export

Connectivity

• Java SQLite
• PHP SQLite
• Python SQLite

Interview Questions

• SQLite Interview