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)

Building Views in Azure PostgreSQL

Content coming soon...

Suggested Topics

• Creating SQL views: syntax and when to use views vs tables
• Building a staging view: cleaning and renaming columns from raw tables
• Building a fact view: selecting grain, choosing measures, adding timestamps
• Building a dimension view: collecting descriptive attributes, handling slowly changing data
• Connecting your views to the raw tables populated by your ingestion pipeline
• Testing your views: expected row counts, null checks, join validation
• Documenting your views with comments and a data dictionary
• Querying your fact and dimension views together to answer analytical questions

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.