Before You Begin

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

  • A general understanding of the different database objects supported in Microsoft SQL Server 2005.
  • Knowledge about the T-SQL syntax required to write views, stored procedures, and user-defined functions.
  • A SQL Server 2005 instance (any edition), with the sample AdventureWorks database 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.

IMPORTANT Practices in this chapter build upon each other

All the lesson practices in this chapter build upon each other; to move to the next practice, you need to finish the previous one.

< Back      Next >

 

 

© Microsoft. All Rights Reserved.