Skip to content

Level 1 · Entry Foundations

Goal: get comfortable reading and writing SQL, understand how relational databases store and query data, and ship a small working database.

Modules

  1. Setup & First Queries
  2. SELECT Basics & Data Types
  3. Filtering with WHERE
  4. Sorting & Limiting Results
  5. Aggregate Functions & GROUP BY
  6. Joins Basics
  7. Working with NULL
  8. Creating Tables
  9. Inserting, Updating, Deleting Data
  10. Project — Library/Bookstore Database

By the end of this level you'll be able to design simple tables, insert and modify data, filter and sort it, summarize it with aggregates, combine data across tables with joins, and query it all using nothing more than the sqlite3 command-line tool.