Episode notes
Think you know SQL? Sam and Shifra break down what separates a query writer from a true data thinker, from basic selects all the way to distributed systems, query plans, and the four pillars of production-ready code. Plus: why your data provider's incentives are working against you, how a 1,400-line monolith hid millions in overstated revenue, and the one approach that will save you from silent, soul-crushing data failures.
🌊 Check out the deep dive here: https://youtu.be/ayNKmcIELEo
We talk about:
- Three levels of SQL (and a secret fourth)
- What they don't teach you in school: data fluency, granularity, and audit patterns
- Why SELECT DISTINCT and ORDER BY are secretly expensive
- WORM vs. WARO: taking cost at write ti ...Â
Keywords
datacareerssaturdatacodingSQLcommunicationsoftskillsgovernance