Skip to main content

Introduction to SQLite

8 Topics • 22 Lessons

The zero-setup database in a single file - tables, queries, and using it from code.

Course Contents

Start Here

1 lesson

Welcome & How to Use This Course

What SQLite Is

3 lessons

SQLite Is a Database in a Single File

When SQLite Fits (and When to Reach for Postgres)

Check Yourself

Getting Started with the CLI

3 lessons

Install sqlite3 and Open a Database

Dot-Commands and Running SQL Files

Check Yourself

Tables & Types

3 lessons

CREATE TABLE: Building the vehicles Table

Type Affinity and STRICT Tables

Check Yourself

CRUD: Insert, Select, Update, Delete

3 lessons

Adding and Reading Rows: INSERT and SELECT

Changing and Removing Rows: UPDATE and DELETE

Check Yourself: CRUD Basics

Querying: Filter, Sort, Aggregate & Join

3 lessons

Filtering and Sorting: WHERE, ORDER BY, LIMIT

Aggregates and Joins: GROUP BY and INNER JOIN

Check Yourself: Querying

Using SQLite from Code

3 lessons

Connecting and Querying from Python

Parameterized Queries and Transactions

Check Yourself

In Practice: When SQLite Fits and Managing the File

3 lessons

Strengths, Limits, and Write Concurrency

Backups, Migration, and Course Recap

Check Yourself