For working with data yourself
5 chapters · 10 lessons
A free, hands-on SQL course you can run in your browser. Connect to a real PostgreSQL-shaped database, look around, and pull out exactly the rows you need.
SQL is how you tell a database which rows you want. Whether you build apps or read numbers, it is the same language.
This course uses one small online shop database from the first lesson to the last. Reading the same tables again and again is what makes the shapes stick.
The database in the exercises is a simulation running in your browser, checked byte for byte against real PostgreSQL 17 output. Even the error messages match, so what you learn to read here reads the same at work.
Connect, see which tables exist, and read their columns and types.
Filter, sort, and limit, so you get exactly the rows you were after.
Learn the routine that lets you undo a change you did not mean to make.
We start from tables, rows, and columns. All you need first is the ability to type a command in a terminal.
Connect yourself and pull out exactly the rows you need.
Try the parts people get wrong the most, NULL and joins, and see what actually happens.
5 chapters · 10 lessons
Join thousands of developers who've mastered the terminal. Your first lesson awaits.
Get Started →