MIS5101 (F11) - Data Management and Warehousing

To do our work with SQL statements, we’ll be using MySQL as the database and MySQL Workbench as our query tool.

Instructions for how to use MySQL in the lab (and to set it up on your own computer) is here.

A set of slides briefly explaining the relationship between Workbench and the MySQL server, and an overview of what Workbench does, is here.

A few other points:

• We’ll be using this material in Weeks 5 and 6 (September 28 and October 5).
• Your username as password for the MySQL server is posted to the gradebook.
• You’ll also need a username and password for the computers in the lab (for our in-class exercises those weeks). That is also posted to the gradebook.