Daily challengeStill lockedFinish your first module.

Module 1: First day

You are a freelance data analyst, and every day brings a new client. Today: Bean & Co. Rosa, the owner, has a database full of customers, coffee and orders. Only nobody knows how to get anything out of it. Until today.

  1. 1
    What is a table?
  2. Picking one column
  3. Several columns
  4. A little taster
  5. Renaming columns
  6. Arithmetic in SELECT
  7. The banker pays a visitFinal test

Module 2: Second day

Rewind still rents out films, and it has a loyal crowd of members. Owner Vic keeps everything in a database, but still searches it by hand. You're about to put an end to that.

  1. Filtering rows with WHERE
  2. Greater, smaller, not equal
  3. Combining conditions
  4. A list with IN
  5. From … to with BETWEEN
  6. Searching text with LIKE
  7. Missing values with IS NULL
  8. The film marathonFinal test

Module 3: Third day

In three weeks Summersound opens its gates. Festival boss Nora has the line-up, the stages and the ticket sales neatly in a database, but everything is jumbled. Posters, timetables and sponsor reports all need to be in order. Time to bring order to the chaos.

  1. Sorting with ORDER BY
  2. Sorting on several columns
  3. Removing duplicates with DISTINCT
  4. The festival bookletFinal test

Module 4: Fourth day

Freewheel rents out city bikes, e-bikes, cargo bikes and tandems to tourists in the Lake District. After the summer, owner Lucy has just one question: "So what did it actually bring in?" Thirty rentals, fourteen repairs and an accountant who is waiting. Time to do the maths.

  1. Counting with COUNT
  2. Adding up with SUM
  3. Averages with AVG
  4. The smallest and the largest
  5. Per group with GROUP BY
  6. Filtering groups with HAVING
  7. The annual reportFinal test

Module 5: Fifth day

Crows FC has six teams, a handful of coaches and a club secretary who keeps track of it all: Yasmine. Players, teams, matches and goals sit neatly in separate tables. The only snag: the answers she's after are always in two tables at once.

  1. Keys connect tables
  2. Linking tables with JOIN
  3. Writing less with aliases
  4. Forget no one with LEFT JOIN
  5. RIGHT and FULL JOIN
  6. More than two tables
  7. Joining a table to itself
  8. The club galaFinal test

Module 6: Sixth day

Librarian Sally manages thousands of loans, but over the years her database has become a bit messy: genres with and without capitals, names with stray spaces, books that are weeks overdue. Her questions can't be answered with one simple WHERE.

  1. Working with text
  2. Calculating with dates
  3. Choosing with CASE
  4. A question inside a question
  5. Does it exist? EXISTS and the NOT IN trap
  6. Readable with WITH
  7. The report for the cityFinal test

Module 7: Seventh day

Joe the baker opens his web shop next week. Yule logs, croissants, loyalty points: it is all in a database already. Only something changes every day. New products, new prices, cancelled orders. Until now you only read data. Today you change it.

  1. New in the shop window
  2. Adjusting prices
  3. Tidying up
  4. All or nothing
  5. The Christmas rushFinal test

Module 8: Eighth day

Five days of racing, sixteen riders, four teams. Race director Grace has every result in a database, but each evening the press wants to know the same thing: who leads, by how much, and who wears which jersey? Building classifications: a job for the heaviest SQL you have seen so far.

  1. A number for every row
  2. Same time
  3. Per team, per stage
  4. The standings
  5. Everything on one list
  6. The podium in HawesFinal test

Badges

  • First queryFinished your first lesson.not earned yet
  • FlawlessA lesson without a single mistake.not earned yet
  • Goal reachedReached your daily goal.not earned yet
  • On a rollPractised 3 days in a row.not earned yet
  • A full weekPractised 7 days in a row.not earned yet
  • Flawless moduleEvery lesson of a module without mistakes.not earned yet
  • JOIN masterFinished every lesson on combining tables.not earned yet
  • ChallengerWon your first daily challenge.not earned yet
  • UnstoppableWon the daily challenge 7 days in a row.not earned yet
  • Final test passedPassed the final test of a module.not earned yet
  • Every final testPassed every final test.not earned yet
  • On the clockFinished your first race against the clock: a speedrun or a puzzle ladder.not earned yet
  • Lightning fastA speedrun or a puzzle ladder within the target time.not earned yet
  • GolferFinished your first hole of query golf.not earned yet
  • BirdieHoled a hole under par.not earned yet