Skip to main content
PProfileMatch
Read Play

Play mode - ride path

Advanced SQL

Window functions, CTEs, reporting queries, transactions and safe data changes

0 of 4 lessons passed0%

0 / 12 stars

0 / 20 tricks - Trick Book
  1. 1

    SQL Window Functions: ROW_NUMBER, RANK, Running Totals, LAG and LEAD

    5-stop ride6 min read

    ReadQuiz onlyStart
  2. 2

    SQL CTEs and Recursive Queries: Walk Hierarchies with WITH RECURSIVE

    5-stop ride8 min read

    ReadQuiz onlyRide
  3. 3

    SQL Subqueries, UNION, INTERSECT, EXCEPT and CASE for Reporting

    5-stop ride7 min read

    ReadQuiz onlyRide
  4. 4

    SQL Transactions, Isolation Levels and Safe Writes: Upserts, Soft Deletes

    5-stop ride9 min read

    ReadQuiz onlyRide

Each ride has 5 stops: read the trick, answer the question, ride on. Pass with 3 of 5 correct (1 star), 4 for 2 stars, all 5 for 3 stars. Progress is saved in this browser. Prefer to read first? Open the reading version of Advanced SQL.