Our Curriculum
The Sqool curriculum is designed for operators in tech. There's no fluff—we've trimmed it down for you to just the 80/20 that you actually need. Each week, you'll review lecture videos async and attend a live session on Thursday, where we'll work through real data problems as a group. If you're ever stuck, you can sign up for 1-1 office hours and work with your Sqool-mates!
Week 0: Getting started
Get onboarded to Slack, Notion, Google Calendar, and our database. We’ll also send out a pre-read to set the stage and introduce the case we’ll work on in the coming 6 weeks.
Week 1: Building blocks of a SQL query
Get comfortable with the basic (but crucial) building blocks of SQL—the language, syntax, and core functions. You’ll learn SELECT, FROM, WHERE, GROUP BY, ORDER BY, CASE WHEN, DATE_TRUNC, LIMIT, DISTINCT, and simple aggregations (COUNT, SIMPLE, AVERAGE).
Week 2 and 3: Demystifying Joins
Joins are the trickiest concept in SQL and often where people get discouraged and demotivated. In Weeks 2 and 3, we’ll demystify how joins work and how to use them correctly every time. You’ll learn all joins (LEFT, RIGHT, INNER, and CROSS) and how tables relate to each other (e.g. foreign keys).
Week 4: Subqueries and why they’re a game changer
Subqueries are analysts’ best-kept secret—and they use them all the time. The best part is: they’re super easy to learn! You’ll learn how to combine multiple queries into one, allowing you to effectively create your own tables and truly master your data.
Week 5: Supercharging SQL
At this point, you can query like a wiz and create metrics with aggregations, joins, and sub-queries. What if we said you’re steps away from supercharging your SQL skills? You’ll learn how to use window functions like PARTITION BY, ROW_NUMBER, N_TILE, RANK, LEAD, and LAG—unlocking the really cool stuff SQL can do.
Week 6: Beyond Sqool
For our final week, we’ll focus on how you can apply your learnings after graduating from Sqool. You’ll learn best practices for applying SQL to your work and how to create the most impact with your data skills.