All lessons
SQL for analysts: from your first SELECT to window functions
Learn SQL by typing it. Every lesson has live editors on a real-looking store database, checks your answers, and shows step by step what each query does to the tables: joins matching rows, groups forming, totals adding up.
Try it now
Press Run, then Show how it runs to watch the join match rows and the totals add up. Change anything and run it again.
What you will be able to do
- Answer business questions in SQL: filters, summaries, joins across many tables, subqueries and CTEs.
- Use the SQL that analyst interviews test: window functions, top N per group, running totals, growth, cohorts, funnels and gaps and islands.
- See what every query does: each step drawn on the tables, so joins and GROUP BY stop being magic.
- Leave with a portfolio project: the Northbay SQL casebook, 30 business questions answered with your own queries.
Every lesson has live editors with Run, Check, Hint and Show answer, plain-English error messages, and a 3-question quiz. Next steps: Data modelling and warehousing, then Pipeline to Dashboard for the tools that load real warehouses. To query your own CSV or Excel files, use the SQL playground.
0 of 52 lessons done
Without the tick, your progress lasts until you close this tab. Either way it stays in this browser: there is no sign-up and nothing is sent to us.