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
Nothing to install. Nothing to break.
Every lesson runs in your browser, on your laptop or your phone.