#sql
6 notes, from beginner to advanced.
- CTEs vs Subqueries vs Temp Tablessql · beginner · 2 min
- NULL in SQL: The Rules That Break Queriessql · beginner · 2 min
- Window Functions Every Data Engineer Usessql · beginner · 3 min
- SQL Logical Query Order: Why WHERE Can't See Your Aliassql · beginner · 4 min
- Indexes and Query Plans: Why a Query Is Slowsql · intermediate · 2 min
- Join Fan-Out: How a Correct Query Returns Wrong Revenuesql · intermediate · 3 min