A free course in eight short lessons

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.

SELECT item, price FROM menu WHERE price < 4;

“Please show me the item and the price from the menu, but only where the price is less than 4.”

How it works

Read it, watch it, try it

A café storyEvery idea starts as something you would say to a waiter, then becomes the same sentence in SQL.
A live playgroundType real SQL in your browser and watch the table act out each step. Nothing to install.
Missions and a quizShort missions, a five-question quiz and a pocket card help each lesson stick.
The lessons

Eight lessons, from first query to your own tables

  1. Lesson 1

    SQL is just ordering at a café

    SELECTFROMWHERE

    What do you want to see? Where is it? Which ones?

  2. Lesson 2

    Line them up, and bring me three

    ORDER BYASCDESCLIMIT

    Put answers in order and choose how many rows you get.

  3. Lesson 3

    The receipt words

    COUNTSUMAVGMINMAX

    How many, the total, the average: many rows in, one row out.

  4. Lesson 4

    Make piles, then squash each pile

    GROUP BYHAVING

    One answer for the drinks and another for the food.

  5. Lesson 5

    Look it up in another table

    JOINONLEFT JOINIS NULL

    Put the menu and the orders side by side.

  6. Lesson 6

    Change the menu board

    INSERTUPDATEDELETE

    Add, change and remove rows, safely.

  7. Lesson 7

    Build your own table

    CREATE TABLEPRIMARY KEYNOT NULL

    Every column: name, kind, rules.

  8. Lesson 8 · Final project

    Your first day running the café's data

    Ten jobsReview quizCertificate

    Use everything you have learned on ten real café jobs, then unlock your certificate.

About

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.