Stage 4 of 9 · 8 lessons · ~4 weeks
Aggregation, subqueries and window functions
Summarise data with GROUP BY and HAVING, build answers in steps with subqueries and CTEs, and calculate rankings, running totals and comparisons with window functions.
7 more stages, 51 more topics, free with an account.
You have seen the open stages of the SQL and databases roadmap. Every topic it covers is listed above, and an account opens the rest: what each topic means, a question to check yourself, the courses, the practice and Tauseef's advice for every stage. Early access is open: sign up and your account is active shortly after.
Everything here is free to learn from. A few things, like adding a roadmap, keeping a cheat sheet or asking Tauseef a question, use credits. You get 15 when you join, your first roadmap is free, and if you are learning seriously and run out, you can ask for more. Credits only make sure the platform goes to people who are actually learning.