Setup Instructions for
Introduction to SQL using SQL Server

  1. If you haven't already, download the class files listed at the bottom of this page.
  2. Create a folder in the root of your C drive called "Webucator" and extract the class files zip file to that folder.
  3. Make sure that you have installed the software you plan to use in class.
    1. See the course outline for your class to determine the software requirements (link below).
    2. If this is for a private onsite class make sure that each computer has the database and client software installed.

Using SQL Server 2000

If you have Query Analyzer installed on your machine and access to SQL Server 2000, all you need to do is make sure that you have the Northwind database installed. If you do not, see “Installing Northwind” below.

Using SQL Server 2005

If you SQL Server Management Studio and access to SQL Server 2005, you must install the Northwind database. See "Installing Northwind" below.

If do not have SQL Server 2005, you can install the Express Edition with Advanced Services by following the Webucator-specific directions.

Installing Northwind on SQL Server

  1. Unzip the SQLServer-setup.zip file in the Setup directory in the class files.
  2. Startup SQL Server Management Studio or Query Analyzer.
  3. Open Northwind-SQLerver.sql and press the F5 key to execute the script.
  4. To test the setup, type the following and the press F5.
    5. 		SELECT * FROM Employees;
  5. You should see a listing of employees.

Outline available at http://www.webucator.com/Database/SQL103.cfm

Class files available at http://www.webucator.com/ClassFiles/SQL103.zip

Technical requirements listed at http://www.webucator.com/Database/SQL103.cfm#TechReqs.