PL/SQL Programming  «Prev  Next»

Lesson 2 Oracle PL/SQL Requirements
ObjectiveRequirements for learning and studying Programming PL/SQL.

Oracle PL/SQL Requirements

Platform Support

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.

On Your Own exercises (Applied 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.
Please note that this setup is optional and is not required to take the course.

Oracle server software

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.

Oracle PL/SQL Programming

Recommend Oracle Database

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.

Course downloads

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.

Download Course Files - Exercise

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