Lab
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.
Objectives
The lab teaches you how to work with the Linux and Oracle environments. It requires you to download and install on your local Windows-based computer a copy of VMware Workstation or on your local MacOS-based computer a copy of VMware Fusion from https://www.vmware.com.
When installing VMware on our machine, choose the free 30 day installation option. You will receive an email with a code for a free copy of the software on Friday of the first week of class. The email will instruct you in how you convert your free 30-day license to a one-year license at no cost to you.
Secure a copy of the VMware instance for the course from the URL or from the instructor. After you have downloaded and installed VMware, open the VMware instance with VMware Workstation or VMware Fusion. When prompted whether you copied it or moved it, choose moved it.
After you have a working VMware instance, the lap helps you learn:
- How to the Gnome menus of the Linux environment
- How to use the Linux Command-Line Interface (CLI)
- How to connect to SQL*Plus as the student user
- How to use the SQL*Plus environment
- How to write, run, and unit test a small script file to create tables
- How to write, run, and unit test a small script file to add data to the tables
Business Scenario
Building data-centric application software requires a working environment. When you arrive at a new employer, you need to learn how to work effectively in their environment.
The lab is designed to teach you how work in the Linux and Oracle environment for the course. Your ability to succeed in the course depends on whether you dedicate adequate time to understand how the environment and command-line SQL*Plus interfaces work.
