Week 9 - SQL for Analytics

Introduction to SQL for Analytics

2. Joins, CTEs, and Aggregations

3. Data Validation Queries

4. Data Modeling Concepts

5. Building Views in Azure PostgreSQL

6. Gotchas & Pitfalls

7. Practice

8. Assignment

Lesson Plan

Lesson Plan

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/*

Built with ❤️ by the HackYourFuture community · Thank you, contributors

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