The information helps you get started on the Oracle Certified Database Administrator and/or the Certified Application Developer tracks. Another important goal of this series is to 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. 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. This language offers procedural techniques to build your SQL commands. You can use this language to construct packages, procedures, triggers, functions, and more.

After completing this course, you will be able to:

1. Create stored PL/SQL objects
2. Create your own customized functions that can be used in queries
3. Add triggers to your tables to assure that rows inserted into the tables contain valid data
4. Create a PL/SQL procedure, which encapsulates logic and can be executed simply by calling it by name
5. Wrap a set of procedures and functions into a single container called a package
6. 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