Setup Instructions for
Introduction to SQL using Oracle

  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.

Installing Northwind on Oracle

  1. The Northwind-Oracle.sql installation script for the database used in class is in the ClassFiles/Setup directory. Open that file in your Oracle client software and execute it.
  2. To test the setup, execute the following command:
  3. 		SELECT * FROM Employees;  	
  4. You should see a listing of employees.

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

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

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