Database Tutorial

Course Tutorial Site

Site Admin

Lab #1: MySQL Monitor

without comments

Lab #1: Oracle Assignment

After you copy and start the Fedora image, you need to log into the instance as the student user. Login as the student user, as shown in the following screen shots:

  1. [2 points] Open and learn the basics of using the Fedora Gnome interface:

After you launch the Terminal, you can do the following steps as the student user. If you expand the Instruction Details, you can see the individual subtasks:

  1. [2 points] Navigate to the lab1 directory from the student home directory:

  1. [2 points] Connect to mysql as the student user:

  1. [2 points] Run the apply_mysql_lab1.sql script, which runs three scripts: (a) the cleanup_mysql.sql script, (b) the create_mysql_store.sql script, and (c) the seed_mysql_store.sql script.

  1. [2 points] Query the data dictionary to find the tables created by the create_oracle_store.sql script.:

Written by michaelmclaughlin

September 18th, 2015 at 12:49 am

Posted in