4. SQL for Data Engineers (Joins, Window Functions)
4.1 DE SQL Mindset
Why. DE SQL builds tables others depend on. Silent row duplication is a production incident.
What. Same SQL language, stricter habits: grain of one row, join checks, partition filters.
How. Always ask: “After this join, how many rows should exist per order_id?”