SQL103

Technical Requirements

Operating System Options

This class only supports Windows Operating Systems.

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

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;

Class Files

1. Download the class files.
2. After downloading the class files, create a directory on your hard drive named "Webucator" that can be found easily.
   1. On Windows it is recommended the new folder have a path of C:\Webucator.*
   2. On Mac OS X a good location for the new folder may be in your Documents directory.
3. Extract the files to the folder you just created.

FAQ

1. Question: I get a warning "Microsoft Internet Information Services (IIS) is either not installed or is disabled". Answer: You do not need to have IIS Installed for the Introduction to SQL Course.