David B. Paradice, Ph.D.
Harbert Eminent Scholar in Business Analytics
Raymond J. Harbert College of Business
MySQL Workshop Materials
Don't do anything before you set up a mysql database using these directions:MySQL Directions. This file also tells you how to access your database and set up the tables.
After you set up your mysql database, click on the file names below to download the files we will use in the workshop.
MySQL Workshop PowerPoint Slides: This is the PowerPoint deck that Dr. Paradice will use to cover relational database concepts and very basic SQL concepts.
MySQL Setup File: This files sets up the tables and puts data in them.
MySQL Data Def and Data: This describes the tables and the data in them.
MySQL Workshop Lab Work: These are the workshop commands to execute in the lab.
MySQL Quick Reference: A quick reference guide of MySQL commands.
Firm Data Setup File: A data file to setup firm data. Play with this later.
Pet Data Setup File: A data file to setup firm data. Play with this later.