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.