| Lesson 2 | PL SQL Stored Objects Requirements |
| Objective | Learn what you need to complete this course. |
While not explicitly required, it's better to work with a real Oracle Server during this course. If you have an Oracle database
available to you now, go to the Resources page and download the sample database script and instructions on how to install it on your
database. To run the database script and populate the database with data, you will need access to Oracle11g or higher.
Sample DB Script
The sample database script is identical to the script found in Courses 1 and 2, so if you have already downloaded the script,
you do not have to do it again.
You cannot use another brand of database to practice 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.
You can order a trial version of Oracle11g Enterprise Edition Server or Personal Oracle11g from Oracle's web site.
Either of these two versions of the database can be used during this course. The difference is that the Enterprise Edition supports multiple concurrent users while the Personal edition supports only one user at a time.
Older Oracle software
You can order a trial version of Oracle11g Enterprise Edition Server or Personal Oracle11g from Oracle's web site.
Either of these two versions of the database can be used during this course. The difference is that the Enterprise Edition supports multiple concurrent users while the Personal edition supports only one user at a time.
All the PL/SQL shown in this course can be run using Oracle 9i and Oracle10g.
Optional books
Several books are available to assist you as you work with PL/SQL.
Course WebStore
Purchase the optional texts for this course online by visiting the course . These books are not required to take this course, but do contain helpful,
additional information. You can reach the Web Store at any time by clicking the following link.
RelationalDBDesign WebStore
Course download
RelationalDBDesign WebStore
The petstore.zip file on the Resources page contains several files that you need to complete the course project exercises. You will
get a database diagram and a document listing of all the tables and data you need to do the course projects without any database
software.
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.
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
Click the link below to complete the Course Project for the course.
Download Course Project
