SQLite is a very lightweight database, with no installation required, zero configuration, and no server required. SQLite is widely used as a database of choice in mobile apps, camera, home electronic devices and other embedded systems.

This book is designed for beginners with little or no prior database experience.

Here is what you will learn:

Chapter 1: Introduction

Chapter 2: Create Database

1. CREATE Database


2. CREATE Database in a Specific Location


3. Create database and populate it with tables from a file


4. Backup & Database


5. Drop Database

Chapter 3: Create, Alter, Drop Table

1. Create table


2. Drop table


3. Alter table


4. Add columns- Using ALTER TABLE Command


5. Insert value into a table

Chapter 4: Primary & Foreign Key

1. SQLite constraint


2. Primary Key


3. Not null constraint


4. DEFAULT Constraint


5. UNIQUE constraint


6. What is a SQLite Foreign KEY?

Chapter 5: Data Types

1. Storage Classes


2. Affinity Type


3. Examples of storing data types in SQLite

Chapter 6: Select, Where, Limit, Count, Group By, Union

1. Reading data with select


2. WHERE


3. Limiting and Ordering


4. Group BY


5. Query & Subquery


6. Set Operations -UNION,Intersect


7. Conditional results


8. Advanced queries

Chapter 7: Joins

1. Introduction to SQLite JOIN Clause


2. INNER JOIN


3. JOIN … USING


4. NATURAL JOIN


5. LEFT OUTER JOIN


6. CROSS JOIN

Chapter 8: INSERT, UPDATE, DELETE

1. INSERT


2. Update


3. Delete


4. Conflict clause

Chapter 9: Index, Trigger & View

1. View


2. Index


3. Trigger

Chapter 10: SQLite Functions

1. Finding the LENGTH of a string


2. UPPER Function and LOWER Function


3. TRIM Function


4. TYPEOF Function


5. SQLite LAST_INSERT_ROWID


6. SQLite library


7. User-defined functions