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 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 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.