Introduction and Getting Started
  • Introduction
  • An important Announcement
  • Download Sqlite
  • Starting with SQLite
Database and Tables
  • Create Database and tables in SQLite
  • Data Types in SQLite
  • Insert records into table
  • Select Records from table
  • Saving table, database and changing colors
  • Opening database and some common errors
  • Filter the Records of the table
  • AND, OR continued..
Grouping, sorting, modifying and delete
  • Grouping
  • Sorting the records
  • Between and In
  • Update the records
  • Structure of the table
  • Date Functions
Constraints, alter, delete and drop
  • Primary key constraints
  • NOT NULL constraint
  • Unique Constraint
  • Default constraint
  • Check constraint
  • Alter table structure
  • Delete and Drop
  • Backup and Restore
  • Various modes in SQLite
  • Final Wrap-up
Bonus Section
  • Bonus: Let us stay connected