|Lesson 2||PL SQL Stored Objects Requirements|
|Objective||Learn what you need to complete this course.|
PL/SQL Stored Objects Requirements
Oracle12c Server Software
While not explicitly required, it is better to work with a real Oracle Server during this course.
If you have an Oracle database available to you now, use the sample database script (previously downloaded) and instructions on how to install it on your database at the following link
To run the database script and populate the database with data, you will need access to Oracle11g or higher.
Visit the following page to download a version of Oracle for your machine.
Sample DB Script
You cannot use another brand of database to practice the sql because the majority of this course covers Oracle's own extensions to the SQL language, such as the DECODE function. I urge you to get some live practice into your studies by
installing Oracle11g on your home or office workstation.
Either of these two versions of the database (standard or enterprise) can be used during this course.
Older Oracle software
All the PL/SQL shown in this course should be run using Oracle11g or higher.
Purchase the optional texts for this course online by visiting the ecommerce store below .
These books are not required to study this course, but do contain helpful information. Several books are available to assist you as you work with PL/SQL.
The following textbook by Steve Feuerstein is recommended for this course.
PL/SQL Programming: A Developers Workbook
If you wish to complete the optional On-Your-Own course exercises, or if you wish to work on the course project exercises with your own copy of the course project tables, you will need to use the downloaded SQL file to help you create the sample database for the course project.
The next lesson examines some of the features of the course.
Click the link below to complete the Course Project for the course.
Download Course Project