Training path

SQLite

The database in a file, inside every phone and browser: SQL, CSV import, indexes, backups and WAL mode with the sqlite3 shell.

Start the SQLite pathSee the modules
Your lab machineLive

SQLite 3 and the sqlite3 shell, next to every lesson.

learner@linux-server:~$ sqlite3 shop.db ".tables"

learner@linux-server:~$ sqlite3 shop.db ".import --csv sales.csv sales"

learner@linux-server:~$ sqlite3 shop.db .dump > shop.sql

What you'll learn

SQLite needs no server: a database is one file. Every lesson builds on a shop database in your home folder: flexible and STRICT types, queries and CSV import and export, transactions and foreign keys, indexes and query plans, then safe backups and WAL mode, each checked on your machine.

Core skills

  • ✓The sqlite3 shell and dot-commands
  • ✓Type affinity and STRICT tables
  • ✓SELECT, GROUP BY and JOINs
  • ✓Importing and exporting CSV
  • ✓Transactions and foreign keys

Advanced topics

  • ✓Indexes and EXPLAIN QUERY PLAN
  • ✓Safe backups with .backup
  • ✓Dumping a database as SQL
  • ✓WAL mode for concurrent readers

Course modules

  1. 01

    A database in a file

    Create a database file and a table, and look around with dot-commands.

    30 min
  2. 02

    Rows and types

    Insert and read rows, see type affinity at work, and use STRICT tables.

    30 min
  3. 03

    Querying and importing CSV

    Import a CSV file, ask questions with GROUP BY and JOIN, and export results.

    45 min
  4. 04

    Changes, transactions and foreign keys

    UPDATE and DELETE in transactions, and foreign keys that SQLite only checks when asked.

    45 min
  5. 05

    Indexes and query plans

    Read query plans and make a query on 200,000 rows fast with an index.

    30 min
  6. 06

    Backups and WAL

    Back up a live database, dump it as SQL, and switch to WAL mode.

    30 min

Prerequisites

Linux command-line basics. No SQL experience needed.

What's included

  • •6 hands-on chapters
  • •A lab machine with SQLite for every lesson
  • •Tasks checked on your machine with "Check my work"
  • •Nothing to install: everything runs in your browser

Who it's for

  • •Mobile, desktop and embedded developers
  • •Data analysts who live in CSV files
  • •Anyone learning SQL without running a server

By the end, you'll be able to

  • •Create and query SQLite databases from the shell
  • •Move data in and out as CSV
  • •Use transactions and enforce foreign keys
  • •Speed up queries with indexes
  • •Back up live databases safely and use WAL mode

Course format

  • •Self-paced online learning
  • •Lifetime access to course materials
  • •Regular content updates
  • •Community forum access

Support

  • •Email support from instructors
  • •Q&A sessions (monthly)
  • •Peer community support
  • •Course completion certificate

Course investment

Contact for pricing

Flexible payment options available

Ready for SQLite?

Open a lab machine and create your first database file in seconds.

Start the SQLite pathAll training paths