NET111

Technical Requirements

Operating System Options

This class only supports Windows Operating Systems.

• Windows XP Service Pack 2 or above
• Windows Vista
• Windows 7

Visual Studio 2008

• Download

Important

• Make sure that SQL Server Express is enabled.
• Make sure to install all Documentation associated with Visual Studio.

Microsoft SQL Server - 2000 or later

You need to have full administrator access to SQL Server. If you do not, you can install SQL Server 2005 Express locally:

• First, please read the instructions on Installing_SQL_Server_2005_Express
• Download SQL Server
• Ensure that you add the current Windows user as a SQL Server administrator on the Database Engine Configuration step

Installing Northwind

If you do not have the Northwind database installed, please follow the instructions below:

Installing Northwind on SQL Server 2000 and 2005

NOTE: you should download the class files below before following these instructions, as it contains the Northwinds Database file(s).

1. Open Northwind-SQLServer.sql (located either in the Webucator/ClassFiles or the Webucator/ClassFiles/Setup directory) using either SQL Server Management Studio (for SQL Server 2005 or later) or SQL Server Enterprise Manager (for SQL Server 2000).
2. Press the F5 key to execute the script.
3. To test the setup, type the following and the press F5.

          SELECT * FROM Employees;

Microsoft SQL Server Sample Databases

• Download
  • Download the file named AdventureWorksDB.msi (it should be the first file listed).
  • Double-click the AdventureWorksDB.msi file after downloading to launch the install wizard.

Class Files

1. Download the class files.