1. Log in to ubuntu.

2. a. Here is a video tutorial: https://www.youtube.com/watch?v=X_umYKqKaF0

b. https://docs.oracle.com/cd/E19078-01/mysql/mysql-workbench/wb-getting-started-tutorial.html

(You have already seen the EER diagram material)

c. Here are links to the manual. This is the most important feature for now, in "database development"

        https://dev.mysql.com/doc/workbench/en/wb-sql-editor.html

The performance tab might also be of interest.

3. After you are comfortable using Workbench, pull up the Stanford DB11 video. You job in this lab is to reproduce the demos Prof. Widom shows on constraints. 




Last modified: Monday, September 19, 2016, 7:09 AM