← All courses
📊Advanced
SQL for Data Analysis (Pro)
Go beyond SELECT — answer real business questions with joins, aggregation, window functions and CTEs. Every query runs live against a sample database in your browser.
5 modules · 19 lessons · runnable · 19 lessons
Share
₦2,40080% OFF
₦12,000 save ₦9,600
Offer ends in …
What you'll learn
- Aggregation & joins
- Window functions
- CTEs & subqueries
- Analytics patterns
Curriculum
5 modules · 19 lessonsModule 1Aggregation that answers questions4 lessons
The sample databasePreviewGROUP BY and aggregates
WHERE vs HAVING
Conditional aggregation
Module 2Joining tables for analysis3 lessons
INNER JOIN
LEFT JOIN and finding gaps
Revenue per customer and city
Module 3Window functions5 lessons
Aggregates without collapsing rows
Ranking rows
Running totals
PARTITION BY: windows per group
LAG and LEAD: period over period
Module 4CTEs & subqueries3 lessons
Subqueries
CTEs (WITH) for readable analysis
Multi-step analysis with CTEs
Module 5Analytics patterns4 lessons
Top-N per group
Bucketing with CASE
Percent of total
Where to go next
Reviews
No reviews yet.
