CIT 111: Introduction to Databases

Week 04: Activity (1 of 2): Querying Databases

This activity will install the course database. This database will be used throughout the remainder of the semester. You will use this database to learn to query tables.

Steps

  1. Import and run the db-intro-database-setup.sql dump file.
    1. You are importing all the databases you will use for the rest of the course by clicking on the blue link and downloading the .sql file.
      • Open the .sql file from MySQL Workbench with File 'Open SQL Script' and run all the code (you can use the regular lightning bolt)
      • This is a very large file, it may take a while. Even scrolling through the file may freeze up your computer for a moment, this is normal.
    2. One of the new databases is the v_art database so you have correctly entered data for this activity.
    3. The Drop Statements inside this dump file will delete any previous databases of the same names if you have downloaded and run this file before.
  2. The bike database will also be downloaded from step 1, so you have correctly entered data for this activity.

    1. Follow along with the video by typing and running all the queries.

      The first part of the video has you create the database, you will have already completed that from the above step.

      (36:41 mins, Single Table Queries Transcript)

  3. You will need the information from the video to help with Saturday's assignment.

Submission

There is no submission for this activity, however make sure you typed and ran all the queries in the video.

Useful Links: