RelationalDBDesign
RedhatLinuxSys Seomining
prev next prev next
Course navigation
Lesson 2 Oracle 8i PL/SQL Requirements
Objective Verify that you have the correct background for this course.
Platform support
You can take this course on Windows, Macintosh, or UNIX platforms.
On Your Own exercises
This course makes use of optional On Your Own exercises. An On Your Own exercise is a good way for you to practice the skills you have learned.
It is not scored and is an optional hands-on exercise that you can do if you have access to an Oracle database.
If you want to perform the optional hands-on On Your Own course exercises, you will need the following hardware and software .
Oracle8 server software
I recommend that you work with a real Oracle server during this course even though this is not specifically required.
To run the database script and populate the database with data, you will need access to Oracle8i. You may also wish to install Oracle Enterprise Manager because many of the courses reference this tool.

You cannot use another brand of database for practice because the majority of this course covers Oracle's exclusive management tools, parameters, and features.

If you want to look into ordering a trial version of Oracle8i Enterprise Edition Server, Oracle Enterprise Manager, or Personal Oracle8i, go to the OracleStore website.
Oracle requires you to register and allows you to download the software for free. This free software is a 60-day evaluation copy.
You can run Oracle8i on Windows NT, Windows 95, Windows 98, LINUX, SCO, and NETWARE. To install Oracle8i, run the setup program. The installation wizard will guide you through the installation. Software Store
You can purchase all of this software online by visiting our Web Store.
You can reach the Software Store at any time by clicking the above link.
Course downloads
The houseopets.zip file contains several files that you will need to complete the course project exercises:
  1. The House-O-Pets course project schema: a database diagram and a document listing of all the tables and data you need to work the course projects without any database software
  2. Sample data for the optional On Your Own exercises: the SQL file will help you create the sample database for the course project
In the next lesson, the course resources will be discussed.
Files Required Download Exercise
Click the Exercise link below to download the files you will need to complete the course project exercises and the On Your Own optional exercises. Files Required Download Exerise
Course navigation