SQL & Data Modeling
Essential SQL techniques, data modeling concepts, and best practices for analytics and data engineering.
SQL Case Studies
Real-world examples of advanced SQL techniques and optimization strategies.
Advanced SQL Techniques
Window functions, CTEs, recursive queries, and performance optimization strategies.
Data Modeling Fundamentals
Star schemas, snowflake schemas, dimensional modeling, and data warehouse design.
Query Optimization
Execution plans, indexing strategies, and performance tuning techniques.
Spark SQL & Internals
Understanding Spark SQL engine and optimization techniques for big data.