Join and Combine Data with T-SQL

Combining data from multiple tables is essential in relational databases. In this course, you’ll learn to write and optimize INNER, OUTER, CROSS JOINs, and UNIONs in SQL Server to build fluency with keys, joins, and set operations.

What you'll learn

Combining data from multiple tables is essential in relational databases.

In this course, Join and Combine Data with T-SQL, you’ll learn how to write and optimize INNER, OUTER, and CROSS JOINs as well as UNION and UNION ALL operations to build powerful multi-table queries.

First, you’ll explore the fundamentals of joins and how to apply them effectively based on table relationships.

Next, you’ll combine data across multiple tables using INNER, LEFT, and FULL joins—while learning to handle unmatched rows, aliases, and filters.

Finally, you’ll advance into complex techniques like self-joins, CROSS joins, and merging result sets with UNION and UNION ALL, including performance considerations .

By the end of this course, you’ll be confident in querying and combining relational data using SQL Server.