SQLiteracy · Basic course · free with account
Your first queries: SELECT, WHERE, ORDER BY, and reading a real schema.
Everything here runs against a real table: the world's airports, all seventy-something thousand of them. By the end you'll pull filtered, sorted slices out of any table you're handed, and read a schema panel without fear. Work in order; each module leans on the last. It's free with a Data Literacy account, and your progress syncs so it follows you to any device.
This course is free with a Data Literacy account, so your progress follows you anywhere.
Module 1 · ~12 min
Reading a table
Your first SELECT, and why nobody reads all the rows
Module 2 · ~15 min
Asking questions with WHERE
Filters turn a table into answers
Module 3 · ~12 min
Putting results in order
ORDER BY, and the difference between a list and a ranking
Module 4 · ~15 min
Reading the schema
A second table, and the truth about missing values
Finished the modules? Take the final exam: five fresh questions, no hints, and the SQLiteracy Basic badge when you pass them all.
Start the examWondering what you've actually learned? Review your skills across every course.
Where this data comes from
Every query in this course runs against real, public-domain data, rebuilt monthly and graded in your browser. These tables are a snapshot taken when the build ran, which was 18 September 2026.
airports72,563 rowsOne row is one airport. From OurAirports, public domain.
countries249 rowsOne row is one country. From OurAirports, public domain.
The database also carries segments, carriers, aircraft_types and service_classes, which this course does not need but the schema panel and the Scratchpad leave open to you.
Sources: OurAirports. Refreshed monthly.