CIT 111: Introduction to Databases

Activity: Explore SQL Workbench

Overview

Instructions

  1. Watch the following four videos and follow along on your computer:

    • Exploring Workbench 1:

        0:00  Home Screen, 1:10 Editor, 3:41 Reconnect, 5:00 Preferences, 8:43 Sidebar Panel (Schema List)

      (16:09 mins, "Workbench 1" Transcript)

    • Exploring Workbench 2:

         0:00 Query Tab and Toolbar, 5:41 Output Panel, 7:51 Table Editor

      (10:22 mins, "Workbench 2" Transcript)

    • Exploring Workbench 3:

         0:00 Models, 0:52 Reverse Engineer, 2:18 Create a new Model, 6:34 Add a table to a model, 11:00 Relationship Tools


      (16:59 mins, "Workbench 3" Transcript)

    • Exploring Workbench 4:

         0:00 Forward Engineer, 3:10 Table Editor, 4:27 Adding data to a table in Workbench, 6:57 SQL Dump File

      (11:21 mins, "Workbench 4" Transcript)

  2. If you created the store database. Right-select on the store database name in the schema list and click on 'Drop Schema..." and select the 'Drop Now' button. This will delete the database we created. We won't be using it again. This is the only database we will drop. Don't drop any others.

  3. Open up the Workbench Preferences window and under the 'SQL Editor' section uncheck the 'Show Metadata and Internal Schemas' so the MySQL schemas won't show in the list anymore once the list is refreshed. While in Preferences, take a screenshot of the Defaults window under Modeling that shows the 'PK Column Name:' pattern and the 'Column Name:' pattern that you changed in the videos.

  4. Refresh your schema list and you shouldn't see the MySQL schema because it is hidden and you won't see the store schemas anymore because it was deleted (dropped). Take a screenshot of the schema list.

Submission

Upload two screenshots to Canvas. Screenshot images should be .png, .jpg, or .pdf

  1. a screenshot of the preferences showing the default patterns under modeling
  2. a screenshot of your schema list

Useful Links: