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)
Assignment
Content coming soon...
Suggested Project Scope
- Write validation queries for your ingested data: check for duplicates, nulls, and row count consistency
- Design a simple star schema with one fact table and at least one dimension table
- Implement the fact and dimension as SQL views in Azure PostgreSQL
- Document the grain, keys, and measures for each view
- Write at least three analytical queries that join your fact and dimension views
- Specify which dataset to use: ingested data from prior weeks OR a Week 9-provided dataset. Provide a fallback dataset for students who don't have clean ingested data.
- Deliverables: SQL scripts for views, validation query results, a short data dictionary, analytical query output
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.