Learn SQLite in 24 Hours

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