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
CREATE Database
CREATE Database in a Specific Location
Create database and populate it with tables from a file
Backup & Database
Drop Database
Chapter 3: Create, Alter, Drop Table
Create table
Drop table
Alter table
Add columns- Using ALTER TABLE Command
Insert value into a table
Chapter 4: Primary & Foreign Key
SQLite constraint
Primary Key
Not null constraint
DEFAULT Constraint
UNIQUE constraint
What is a SQLite Foreign KEY?
Chapter 5: Data Types
Storage Classes
Affinity Type
Examples of storing data types in SQLite
Chapter 6: Select, Where, Limit, Count, Group By, Union