Skip to content
Deadline to Die

06. Joins & Subqueries

Overview

This module explores how to query data spread across multiple related tables.

Topics Covered

  • Join Types: INNER JOIN, LEFT/RIGHT OUTER JOIN, FULL OUTER JOIN, and CROSS JOIN.
  • Subqueries: Correlated vs. Non-correlated subqueries and using them in SELECT, FROM, and WHERE.
  • Common Table Expressions (CTEs): Writing cleaner, more readable queries with WITH.
  • The APPLY Operator: Using CROSS APPLY and OUTER APPLY with table-valued functions.