This course takes you from “what is a relational database?” to running PostgreSQL with confidence in production. All along you build the database behind Orbit, the small notes app from the other courses on this blog: its users, notes and tags, the queries its API runs, the roles it connects with, and the backups that keep it safe.
Every lesson has SQL you can copy, results that come from the same data you created in earlier lessons, three short exercises to check what you learned and answers to the questions people ask most.
Before you start: you need a terminal. If commands like cd, ls and sudo are new to you, take the first lessons of the Linux Tutorial first. Lesson 2 shows how to install PostgreSQL on Linux, macOS and Windows, or run it with Docker.
The examples target PostgreSQL 18, the current major release (version 19 is in release-candidate testing as this course is written, and everything here keeps working on it). Lessons point out when a feature arrived in a recent version, and the last lesson collects what is new in 18 in one place. Keep the Postgres Cheatsheet open in another tab: it has over 400 commands grouped the same way as this course.