Setup Instructions for
Introduction to SQL using MySQL

  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 MySQL

  1. The installation script for the database used in class is in the ClassFiles/Setup directory. Open that file in your MySQL 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/SQL102.cfm

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

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