Key concepts: structured data, formats, storage and lifecycle.
- 1
Data Types and Formats
CSV, JSON, Parquet, Avro, ORC, Arrow in-memory.
40 min - 2
Advanced SQL
Window functions, CTEs, PIVOT, EXPLAIN ANALYZE.
55 min - 3
Python for Data
Pandas, Polars, NumPy, profiling, type hints.
50 min - 4
Data Lake vs Data Warehouse
Differences, lakehouse architecture, Delta Lake.
40 min