- Course
- Data
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.
Table of contents
About the author
Xavier is very passionate about teaching, helping others understand Generative AI, ML, Search, and Big Data. He is also an entrepreneur, project manager, technical author, trainer, and holds a few certifications with Cloudera, Microsoft, and the Scrum Alliance, along with being a Microsoft MVP.