Joins & Combining Tables

28 lessons in Databases & SQL

• Inflated Revenue From Join Fan-OutCode Quiz
• Joins with Aggregation and GROUP BYQuiz
• Joins, Indexes & Query OptimizationSlides / Video
• Joins, Indexes & OptimizationFlashcard
• Joins, Indexing & Query SpeedSlides / Video
• Indexing Join ColumnsFlashcard
• Filtering Aggregated Order TotalsCode Quiz
• Joins with GROUP BY AggregationQuiz
• LEFT JOIN Count Miscounts Zero OrdersCode Quiz
• Indexing Join and Aggregation ColumnsQuiz
• SQL Joins, Aggregation & Indexing BasicsSlides / Video
• Joins, Aggregation & Indexing BasicsFlashcard
• Pre-aggregate before joining fan-out tablesFlashcard
• Filtering Aggregated Order CountsCode Quiz
• Filtering Before and After AggregationQuiz
• Joins & Aggregation Fan-Out TrapsSlides / Video
• Joins Plus GROUP BY and HAVINGSlides / Video
• LEFT JOIN with COUNT and GROUP BYQuiz
• Joins with GROUP BY and HAVINGFlashcard
• INNER vs LEFT JOIN BehaviorQuiz
• INNER JOIN vs LEFT JOINFlashcard
• INNER vs LEFT JOIN BasicsSlides / Video
• Filtering Customers Above Average Order ValueQuiz
• Combining Joins, Aggregation & SubqueriesFlashcard
• Joins, Aggregations & SubqueriesSlides / Video
• Joins, Aggregations, GROUP BY & HAVINGSlides / Video
• Joins with GROUP BY and HAVINGQuiz
• Joins with GROUP BY and HAVINGFlashcard