Database Tutorial

Course Tutorial Site

Site Admin

Description

without comments

Lab #1: Installations

Learn about hierarchical, networked, and relational databases; introduce you to how to navigate Oracle’s SQL*Plus Command-line Interface (CLI); and how basic SQL queries work.

Lab Description

[30 points] Click the Lab Instructions link to open the instructions inside the current webpage.

The lab requires that you test the elements of the environment and write one integration script. The integration script calls two unit test programs found in the following directory:

/home/student/Data/cit225/oracle/lib1

Please perform these tasks after you have downloaded VMware and opened the Fedora virtual instance.

The lab has six parts that are worth five points each. The individual parts are explained in step web pages. The steps are:

  • Step 1: Open and learn the basics of using the Fedora Gnome interface.
  • Step 2: Navigate to the following directory from the student home directory.

    /home/student/Data/cit225/oracle/lib1

  • Step 3: Connect to sqlplus as the student user and experiment with the Command-Line Interface (CLI).
  • Step 4: Create an apply_oracle_lab1.sql script file in the following directory:

    /home/student/Data/cit225/oracle/lab1

    The apply_oracle_lab1.sql script should run three scripts from the referenced library directory. You can implement that logic by putting the following into the apply_oracle_lab1.sql script file:

    -- Open log file.
    SPOOL apply_oracle_lab1.txt
     
    -- Run instructor provided setup scripts.
    @@/home/student/Data/cit225/oracle/lib1/utility/cleanup_oracle.sql
    @@/home/student/Data/cit225/oracle/lib1/create/create_oracle_store2.sql
     
    -- Close log file.
    SPOOL OFF

  • Step 5: Connect to SQL Developer and view the contents of the tables you created in Step 4.
  • Step 6: Connect to APEX Web Interface and query the contents of the tables you created in Step 5.

Written by michaelmclaughlin

August 3rd, 2018 at 12:06 am

Posted in