Available now

Finding your way around someone else's SQL.

On your first day nobody asks you to write a query from scratch. They point you at a long SQL model written by people who have left, and ask why a number is wrong.

These lessons teach you to read unfamiliar code with a plan: find the grain, follow the joins, test each step, and change it without breaking anything.

Why data engineers need it

  • Most data work is changing existing models, not writing new ones.
  • Finding the grain of every step is how wrong numbers get found.
  • Safe changes need checks you can run before and after.

What you will learn

  • Reading a long query in the right order
  • CTEs: named steps you can run on their own
  • Testing the grain of every step
  • Spotting the join that duplicates rows
  • Proving a fix with a reconciliation check

The lessons

  1. 1Someone else's SQLProFind your way around a model you did not write: read it in the right order, test each step on its own, find the join that duplicates rows, and prove your fix.

Nothing to install. Nothing to break.

Every lesson runs in your browser, on your laptop or your phone.

Try it now