SQL reporting engineer
Learn selection and joins, define trustworthy reports, then use windows and cursor pagination.
Your goal
Deliver a report with clear row grain, tests for NULL and ties, and an inspected execution plan.
Use each checkpoint as evidence: solve an exercise without the solution open, explain its edge cases, and revisit a failed concept the next day. Course completion records practice; it is not an accredited qualification.
SQL from tables to your first report
Inspect the data, select columns, filter carefully, understand NULL, sort ties, aggregate and join. Each new idea builds on the same small dataset.
8 lessons · 109 minutes of guided material, plus project and revision time.
Open syllabus →SQL for everyday data
Query a real SQLite database, then build a spending report.
8 lessons · 76 minutes of guided material, plus project and revision time.
Open syllabus →SQL: trustworthy customer reports
Handle missing relationships, NULL values and customer reports without counting mistakes.
2 lessons · 60 minutes of guided material, plus project and revision time.
Open syllabus →SQL · Explainable analytical reports
Conditional aggregates, predecessor comparisons, duplicate selection and category shares.
4 lessons · 100 minutes of guided material, plus project and revision time.
Open syllabus →SQL beyond basic queries
Rank tied records, calculate running totals and paginate with composite cursors.
3 lessons · 80 minutes of guided material, plus project and revision time.
Open syllabus →Final review
- Demonstrate a working example and a deliberately failing case.
- Explain one design trade-off and the expected time and memory costs.
- State which checks ran automatically and which required manual review.
- Keep a short project README with setup steps, limitations and your next improvement.
Open your personal study plan to review weak concepts and schedule the next session.