Pit Wall

SQLBeginnerabout 3.5 hours13 lessons

It's lap 24 of the Marrow Bay Grand Prix and the pit wall's screens are dark. You're the data engineer: every SQL query you write lights up a panel, from the driver roster to live timing, pace charts, the timing tower and finally the call to box a car.

Start the first lesson

Not started0/970 XP

Blueprint · Pit Wall

Pass lesson 1 to power it up

warming up the scene…

Driver rosterLive timingFastest lapsRace statsPace chartTiming towerStrategy callsPit log

Learning path

Each lesson adds one working part to your build.

Chapter 1

Light up the screens

Read the database: pick columns, filter and search rows, sort them, remove repeats.

0/6 done

Driver roster
6 min50 XPAdds Driver roster
Start
Live timing
8 min60 XPAdds Live timing
Pick the field
8 min60 XP
Search the grid
8 min60 XP
Fastest laps
7 min60 XPAdds Fastest laps
Each tyre once
6 min50 XP

Chapter 2

Crunch the numbers

Summarise thousands of seconds into a few numbers, handle missing values, then connect the tables.

0/5 done

Race stats
8 min70 XPAdds Race stats
Missing values
10 min80 XP
Pace chart
10 min80 XPAdds Pace chart
Timing tower
12 min90 XPAdds Timing tower
Cars with no stop
10 min90 XP

Chapter 3

Make the call

Turn data into decisions, then write to the database.

0/2 done

Strategy calls
12 min100 XPAdds Strategy calls
Box, box
12 min120 XPAdds Pit log

Loading project…