The three courses listed below
- Oracle SQL Extensions
- Programming PL/SQL
- PL/SQL Stored Objects
will help you get started on the Oracle Certified Database Administrator or the Certified Application Developer.
The three courses listed above will
- enable you to create advanced SQL queries,
- write beginning to intermediate PL/SQL blocks, and
- become familiar with Oracle's unique SQL extensions.
PL/SQL is an integral part of the Oracle database engine and this course will introduce you to PL/SQL and explain how you can build PL/SQL programming structures
The term PL stands for Procedural Language
and this language offers procedural techniques to build your SQL commands.
You can use this language to construct
After completing this course, you will be able to:
Create stored PL/SQL objects
Create your own customized functions that can be used in queries
Add triggers to your tables to assure that rows inserted into the tables contain valid data
Create a PL/SQL procedure, which encapsulates logic and can be executed simply by calling it by name
Wrap a set of procedures and functions into a single container called a package
Set up security to allow or not allow access to your database objects, including the procedures, functions, and packages that you create in this course
The next lesson explains prerequisites for this course.