Setup Instructions for
Introduction to SQL using MySQL
- If you haven't already, download the class files listed at the bottom of this page.
- Create a folder in the root of your C drive called "Webucator" and extract the class files zip file to that folder.
- Make sure that you have installed the software you plan to use in class.
- See the course outline for your class to determine the software requirements (link below).
- If this is for a private onsite class make sure that each computer has the database and client software installed.
Installing Northwind on MySQL
- 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.
- To test the setup, execute the following command:
SELECT * FROM Employees;
- 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.