1. 1. SQLite
   1. 1.1. About SQLite
   2. 1.2. Documentation
   3. 1.3. Using SQLite in programming languages
   4. 1.4. Main features of SQLite
   5. 1.5. Download and Install SQLite command-line tool
   6. 1.6. Version of SQLite
   7. 1.7. GUI for SQLite
   8. 1.8. SQLite dialect
   9. 1.9. Data types
   10. 1.10. Conventions
2. 2. SQLite interactive shell
   1. 2.1. Help with SQLite CLI using a pipe
   2. 2.2. Help with SQLite CLI using redirect
   3. 2.3. SQLite version
   4. 2.4. SQLite CLI - external commands .shell
   5. 2.5. SQLite CLI - .schema and .tables
   6. 2.6. SQLite CLI - .mode
   7. 2.7. SQLite in-memory or file-based
3. 3. DDL - Data Definition Language
   1. 3.1. CREATE TABLE
   2. 3.2. ALTER TABLE
   3. 3.3. DROP TABLE
4. 4. DML - Data Manipulation Language - Basic Operations
   1. 4.1. CREATE INSERT SELECT
   2. 4.2. SELECT only some of the columns
   3. 4.3. SELECT only some of the rows - WHERE clause
   4. 4.4. AUTOINCREMENT
   5. 4.5. Invisible AUTOINCREMENT (ROWID)
   6. 4.6. Missing value
   7. 4.7. Missing numerical value
   8. 4.8. Field with DEFAULT value
   9. 4.9. Default time
   10. 4.10. NOT NULL constraint
   11. 4.11. UPDATE
5. 5. SELECT without table
   1. 5.1. SELECT date and time
   2. 5.2. SELECT functions
   3. 5.3. SELECT mathematical functions
6. 6. Data type enforcement
   1. 6.1. Flexible typing
   2. 6.2. STRICT Tables
   3. 6.3. VARCHAR
7. 7. Import data from CSV
   1. 7.1. Import planets.csv
   2. 7.2. Load schema and import planets.csv
   3. 7.3. Import iris.csv
   4. 7.4. Load schema and Import iris.csv
8. 8. Other operations
   1. 8.1. LIMIT
   2. 8.2. Aggregate: COUNT
   3. 8.3. Aggregate: AVG - GROUP BY
   4. 8.4. DISTINCT
   5. 8.5. Aggregate: COUNT, AVG, MAX, MIN
   6. 8.6. Increment value
9. 9. Constraints
   1. 9.1. CHECK, UNIQUE, NOT NULL
   2. 9.2. Multi-column uniqueness constraint
10. 10. Database normalization
    1. 10.1. Multivalue fields
    2. 10.2. Flat table
    3. 10.3. Two tables
    4. 10.4. FOREIGN KEY
    5. 10.5. PRAGMA
    6. 10.6. Family
    7. 10.7. Flat grades
11. 11. Transactions
    1. 11.1. SQLite Transaction - in a bank
12. 12. ALTER TABLE
    1. 12.1. ALTER TABLE after adding data
    2. 12.2. ALTER TABLE not NULL
    3. 12.3. ALTER TABLE in transaction
13. 13. Optimization
    1. 13.1. INDEX
    2. 13.2. EXPLAIN
14. 14. Other
    1. 14.1. Increment or Insert
    2. 14.2. INSERT or UPDATE (replace)
    3. 14.3. Conditional CREATE
15. 15. migrations - changes between schema version
    1. 15.1. sqldiff
16. 16. SQLite in Python
17. 17. SQLite in Rust
18. 18. SQLite in Perl