SQL · Explainable analytical reports
Conditional aggregates, predecessor comparisons, duplicate selection and category shares.
Prerequisite: SQL foundations, grouping and ordering. · 100 minutes of guided study
4 published lessons, from first principles to a small project.
Start first lesson →What you’ll be able to do
- Calculate category shares with an explicit denominator
How to study this course
Follow the numbered modules. Read the example, explain why it works, attempt the exercise, then compare your result with the supplied checks.
Setup: A modern browser. JavaScript, TypeScript, Python and SQLite exercises run here; project workshops state their additional setup.
Times estimate guided reading and practice. Projects and revision can take longer.
Course syllabus · 4 lessons
1 · Reporting patterns and edge cases
- Conditional aggregation in one grouped report25 min · Browser exercise →
Conditional aggregation in one grouped report
- Compare each event with its predecessor25 min · Browser exercise →
Compare each event with its predecessor
- Select one representative from each duplicate group25 min · Browser exercise →
Select one representative from each duplicate group
- Calculate category shares with an explicit denominator25 min · Browser exercise →
Calculate category shares with an explicit denominator