Introduction to SQL for Analytics

Joins, CTEs, and Aggregations

Data Validation Queries

OLAP vs OLTP and Modern Warehouses

Data Modeling Concepts

Building Views in Azure PostgreSQL

Practice

Assignment

Gotchas & Pitfalls

Week 9 Lesson Plan (Teachers)

Week 9 Lesson Plan (Teachers)

Content coming soon...

Suggested Topics to Cover

• Demo: live SQL session building a CTE step by step, showing intermediate results
• Demo: running a cartesian join by mistake and showing the row explosion
• Workshop: students write validation queries against a pre-loaded dataset with known issues
• Whiteboard session: draw a star schema for a familiar domain (e-commerce, school grades)
• Pair exercise: one student writes a fact view, the other writes a dimension view, then join them
• Discussion: OLAP vs OLTP with real-world examples from students' experience
• Code review: students present their views and explain grain, keys, and measures
• Time allocation guidance for each activity (approximate time boxes for a 3-4 hour session)
• Assessment rubric: query correctness, validation coverage, view documentation quality

The HackYourFuture curriculum is licensed under CC BY-NC-SA 4.0

*https://hackyourfuture.net/*

Found a mistake or have a suggestion? Let us know in the feedback form.