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)

Joins, CTEs, and Aggregations

Content coming soon...

Suggested Topics

• JOIN types: INNER, LEFT, RIGHT, FULL OUTER, CROSS and when to use each
• Writing readable multi-table joins with aliases
• Common Table Expressions (CTEs): syntax, readability, and composability
• Recursive CTEs for hierarchical data
• Aggregation functions: COUNT, SUM, AVG, MIN, MAX, and conditional aggregation
• GROUP BY with HAVING for filtered aggregations
• Window functions for running totals, rankings, and moving averages
• Subqueries vs CTEs: readability and performance trade-offs
• UNION and UNION ALL for combining result sets
• Filtering with WHERE vs HAVING: understanding evaluation order

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.