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)

Introduction to SQL for Analytics

Content coming soon...

Suggested Topics

• Why SQL remains the lingua franca for data analytics
• The difference between operational SQL (CRUD) and analytical SQL (aggregations, windows, CTEs)
• How analytical queries fit into the data pipeline: ingestion, transformation, reporting
• Common analytical question patterns: trends over time, comparisons, rankings, distributions
• The role of SQL in modern data teams alongside Python and BI tools
• Overview of SQL dialects: PostgreSQL, T-SQL, BigQuery SQL, Snowflake SQL
• When to use SQL vs Python for data transformations
• Dialect awareness: how syntax varies across database engines (covered theoretically — the course uses PostgreSQL throughout)
• Connecting to your Azure PostgreSQL database for analytical work

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.