hectoday
DocsCoursesChangelog GitHub
DocsCoursesChangelog GitHub

Access Required

Enter your access code to view courses.

Invalid code

← All courses

Database design with SQLite

Learn SQLite from the ground up and design schemas that hold up in real projects. You will start by creating your first database in the shell, then quickly move your schema into migration files so every change is versioned and repeatable. From there you will work with data, design relationships, query across tables, and finish with indexes, transactions, and full-text search. By the end, you will know how to build, change, and maintain a well-designed database for real applications.

Beginner ~8 hours

Getting started

  1. What is SQLite?
  2. The SQLite shell

Creating tables

  1. Tables and types
  2. Constraints
  3. Primary keys

Migrations

  1. Why migrations matter
  2. Building a migration system

Working with data

  1. Inserting data
  2. Transaction basics
  3. Querying data
  4. Filtering in depth
  5. Sorting, grouping, and aggregates
  6. Updating and deleting

Designing your schema

  1. Why schema design matters
  2. One-to-many
  3. Many-to-many
  4. One-to-one
  5. What normalization means
  6. When to denormalize

Querying across tables

  1. JOINs
  2. Aggregation
  3. Subqueries and CTEs

Performance and configuration

  1. Indexes
  2. Query optimization
  3. Transactions
  4. SQLite PRAGMAs
  5. Full-text search

Going to production

  1. Using node:sqlite in your app
  2. Backups with Litestream

Putting it all together

  1. Schema design checklist
  2. Capstone: designing a course platform

© 2026 hectoday. All rights reserved.