Featured resource
2025 Tech Upskilling Playbook
Tech Upskilling Playbook

Build future-ready tech teams and hit key business milestones with seven proven plays from industry leaders.

Check it out
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • 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.

Xavier Morera - Pluralsight course - Join and Combine Data with T-SQL
Xavier Morera
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 Morera - Pluralsight course - Join and Combine Data with T-SQL
Xavier Morera

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.

Get access now

Sign up to get immediate access to this course plus thousands more you can watch anytime, anywhere.

Get started with Pluralsight