| Lesson 2 | Oracle 8i PL/SQL Requirements |
| Objective | Verify that you have the correct background for this course. |
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
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 .
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.
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
You can reach the Software Store at any time by clicking the above link.
The houseopets.zip file contains several files that you will need to complete the course project exercises:
In the next lesson, the course resources will be discussed.
-
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
- Sample data for the optional On Your Own exercises: the SQL file will help you create the sample database for the course project
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