Subqueries & Common Table Expressions

7 lessons in Databases & SQL

• Filtering Window Function ResultsCode Quiz
• Correlated Subquery vs CTE BehaviorQuiz
• NOT IN Subquery With NULLsCode Quiz
• CTE Materialization and Optimization FencesQuiz
• CTEs vs Window Functions for RankingQuiz
• Subqueries, CTEs & Window FunctionsFlashcard
• Subqueries, CTEs & Window FunctionsSlides / Video