Oracle PL/SQL Requirements

This course can be taken on Windows, MacOS, or Linux platforms.

During this course, you will be studying and writing SQL commands. The course has been designed so that you can complete it successfully without any other software.

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.
Please note that this setup is optional and is not required to take the course.

I recommend that you work with a real Oracle server during this course even though this is not specifically required.
If you have an Oracle database available to you now, use the sample database script and instructions for installation.
To run the database script and populate the database with data, you will need access to Oracle8 or higher.

You cannot use another brand of database for practice because the majority of this course covers Oracle's own extensions to SQL, such as the DECODE function.

If you want to look into ordering a trial version of Oracle Enterprise Edition Server or Personal Oracle, go to Oracle's Web site and click on the try-and-buy link.
You can run Oracle on Windows . To install Oracle, run the setup program, and the installation wizard will guide you through the installation. All the SQL shown in this course can be run using Oracle.

The petstore.sql file contains what you need to complete the course project exercises.
If you wish to complete the optional On Your Own course exercises, you will need to download a copy of the SQL file to help you create the sample database for the course project.
In the next lesson, the database course project will be discussed.

Click the Exercise link below to download the petstore.sql files you willl need to complete the course project.
Download Course Files