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.
Table Of Content
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
Reading data with select
WHERE
Limiting and Ordering
Group BY
Query & Subquery
Set Operations -UNION,Intersect
Conditional results
Advanced queries
Chapter 7: Joins
Introduction to SQLite JOIN Clause
INNER JOIN
JOIN … USING
NATURAL JOIN
LEFT OUTER JOIN
CROSS JOIN
Chapter 8: INSERT, UPDATE, DELETE
INSERT
Update
Delete
Conflict clause
Chapter 9: Index, Trigger & View
View
Index
Trigger
Chapter 10: SQLite Functions
Finding the LENGTH of a string
UPPER Function and LOWER Function
TRIM Function
TYPEOF Function
SQLite LAST_INSERT_ROWID
SQLite library
User-defined functions