Before You Begin
To complete the lessons in this chapter, you must have:
- Knowledge of the Transact-SQL data definition language (DDL) elements.
- The SQL Server 2005 AdventureWorks and AdventureWorksDW sample databases installed. Sample databases are available with SQL Server 2005 Enterprise Edition but are not a part of the default installation. Alternatively, you can install sample databases from https://msdn2.microsoft.com/en-us/library/ms143739.aspx.
- Microsoft Visual Studio 2005 or Microsoft Visual C# 2005 Express Edition installed. You can download Visual C# 2005 Express Edition for free from https:// msdn.microsoft.com/vstudio/express/. (Optionally, you can have Microsoft Visual Studio Team System or Microsoft Visual Studio Team Edition for Database Professionals installed.) You can find more information about these products at https:// msdn2.microsoft.com/en-us/teamsystem/aa718803.aspx.
- Microsoft Office Visio or Visio 2007 Viewer, available as a free download from https:// www.microsoft.com/downloads/details.aspx?FamilyID=d88e4542-b174-4198-ae31-6884e9edd524&DisplayLang=en.
© Microsoft. All Rights Reserved.