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)

OLAP vs OLTP and Modern Warehouses

Content coming soon...

Suggested Topics

• OLTP systems: optimized for transactions, row-oriented storage, normalized schemas
• OLAP systems: optimized for analytics, columnar storage, denormalized or star schemas
• Why you should not run analytical queries on production OLTP databases
• Columnar vs row-oriented storage and how it affects query performance
• Modern cloud data warehouses: Snowflake, BigQuery, Amazon Redshift, Microsoft Fabric
• Key warehouse features: separation of compute and storage, auto-scaling, pay-per-query
• Azure PostgreSQL as a stepping stone: how it compares to full warehouse solutions
• The data warehouse in the broader data platform: ELT, orchestration, BI
• When a data warehouse is overkill: small teams, low data volume, simple use cases

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.