Master SQL for Data Engineering

Description:

Most data engineering courses teach you just enough SQL to get by — but production pipelines demand much more. In this session I'll help you go beyond basic queries and develop the SQL depth that actually matters in real data engineering roles. We'll work through real-world problems, not textbook exercises, using the same patterns I apply daily in production environments.

What we'll cover:

1. Window functions, CTEs, and advanced aggregations
2. Query optimization and execution plan analysis
3. Writing SQL for large-scale data transformations
4. Spark SQL vs standard SQL — key differences and when to use each
5. Common SQL patterns in medallion architecture (Bronze → Silver → Gold)
6. Hands-on problem solving with real datasets

Best for: Aspiring data engineers who know basic SQL but want to level up to production-grade query writing and feel confident in technical interviews and real pipelines.