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)

Data Validation Queries

Content coming soon...

Suggested Topics

• Why validation at the SQL layer matters after ingestion
• Detecting duplicate records: GROUP BY with HAVING COUNT > 1
• Finding NULL values and measuring completeness per column
• Row count validation: comparing source counts to destination counts
• Referential integrity checks: orphaned foreign keys
• Range and format validation: dates out of range, negative amounts, unexpected categories
• Building a reusable validation query library
• Automating validation as post-ingestion checks in your pipeline
• Logging validation results to a data quality table

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.