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)

Content

Practice

Content coming soon...

Suggested Activities

• Write multi-table JOIN queries against the course dataset and verify results
• Refactor a nested subquery into CTEs for readability
• Build validation queries that detect duplicates and nulls in your ingested data
• Create a fact view and a dimension view from raw tables in Azure PostgreSQL
• Query your views to answer business questions (e.g., daily totals, top categories)
• Compare query plans for a cartesian join vs a properly filtered join

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.