Chapter 4. Combining Sets

Exam objectives in this chapter:

  • Work with Data

    • Query data by using SELECT statements.

    • Implement sub-queries.

  • Modify Data

    • Combine datasets.

T-SQL provides a number of different ways to combine data from multiple tables; this chapter describes the different options. The chapter covers joins, subqueries, table expressions, the APPLY operator, and set operators.

Lessons in this chapter:

Before You Begin

To complete the lessons in this chapter, you must have:

  • Experience working with Microsoft SQL Server Management Studio (SSMS).

  • Some experience writing T-SQL code.

  • Access to a SQL Server 2012 instance with the sample ...

Get Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.