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