Learn SQLite in 24 Hours

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

Here is what you will learn:

Table Of Content

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