Stage 3 of 8 · 7 lessons · ~7 weeks
SQL for analysis
Querying data where it lives: filtering and aggregating, joining tables without inflating totals, handling NULLs, CTEs for readable steps and window functions for rankings, running totals and period comparisons. Analysis-focused; the SQL and databases roadmap goes deeper into design and performance.
6 more stages, 41 more topics, free with an account.
You have seen the open stages of the Data analytics 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.