Advanced SQL
0 of 20 tricks collected.
SQL Window Functions: ROW_NUMBER, RANK, Running Totals, LAG and LEAD
- Locked trick - Velodrome entrance: the lap board. Ride this lesson to collect it.
- Locked trick - Podium at the sprint finish. Ride this lesson to collect it.
- Locked trick - Rest stop with a shared stopwatch. Ride this lesson to collect it.
- Locked trick - Rear-view mirror at the bend. Ride this lesson to collect it.
- Locked trick - Awards tent: one winner per team. Ride this lesson to collect it.
SQL CTEs and Recursive Queries: Walk Hierarchies with WITH RECURSIVE
- Locked trick - Workshop bench: labelling the parts. Ride this lesson to collect it.
- Locked trick - Spoke wall: the queue of parts. Ride this lesson to collect it.
- Locked trick - Gear cassette: ratio counting. Ride this lesson to collect it.
- Locked trick - Boxes inside boxes at the stockroom. Ride this lesson to collect it.
- Locked trick - Roundabout with no exit sign. Ride this lesson to collect it.
SQL Subqueries, UNION, INTERSECT, EXCEPT and CASE for Reporting
- Locked trick - Clinic waiting room: the missing patient. Ride this lesson to collect it.
- Locked trick - Records room: two filing cabinets. Ride this lesson to collect it.
- Locked trick - Triage desk: sorting by wait. Ride this lesson to collect it.
- Locked trick - Reception tally sheet. Ride this lesson to collect it.
- Locked trick - Discharge desk: comparing two lists. Ride this lesson to collect it.
SQL Transactions, Isolation Levels and Safe Writes: Upserts, Soft Deletes
- Locked trick - Ticket booth: two stamps, one receipt. Ride this lesson to collect it.
- Locked trick - Queue at the box office window. Ride this lesson to collect it.
- Locked trick - Last mug on the shelf. Ride this lesson to collect it.
- Locked trick - Turnstile counter at the gate. Ride this lesson to collect it.
- Locked trick - Guest list with crossed-out names. Ride this lesson to collect it.