SQL Café
Learn SQL the easy way, by ordering at a café. Every lesson explains each word and symbol in plain English, lets you watch your query work step by step, and ends with a quiz and a pocket card so it sticks.
“Please show me the item and the price from the menu, but only where the price is less than 4.”
Read it, watch it, try it
Eight lessons, from first query to your own tables
- Lesson 1
SQL is just ordering at a café
SELECTFROMWHEREWhat do you want to see? Where is it? Which ones?
- Lesson 2
Line them up, and bring me three
ORDER BYASCDESCLIMITPut answers in order and choose how many rows you get.
- Lesson 3
The receipt words
COUNTSUMAVGMINMAXHow many, the total, the average: many rows in, one row out.
- Lesson 4
Make piles, then squash each pile
GROUP BYHAVINGOne answer for the drinks and another for the food.
- Lesson 5
Look it up in another table
JOINONLEFT JOINIS NULLPut the menu and the orders side by side.
- Lesson 6
Change the menu board
INSERTUPDATEDELETEAdd, change and remove rows, safely.
- Lesson 7
Build your own table
CREATE TABLEPRIMARY KEYNOT NULLEvery column: name, kind, rules.
- Lesson 8 · Final project
Your first day running the café's data
Ten jobsReview quizCertificateUse everything you have learned on ten real café jobs, then unlock your certificate.
Made by MASSH AI
SQL Café is a free course from MASSH AI Services in London, which offers data services, digital builds and startup support for individuals and businesses. We made it because SQL is one of the most useful skills in any job that touches data, and it deserves to be explained simply.
Want SQL or data training for your team, or help with your own data? We would love to hear from you.