Before You Begin

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

• A thorough understanding of Transact-SQL, including inner joins, outer joins, apply, and subqueries.

• A good understanding of the indexes in SQL Server databases.

• SQL Server 2005 and the AdventureWorks sample database installed.