Main Office: | 800.631.0410 | |
---|---|---|
Sales Office: | 800.533.3893 |
This class covers advanced topics related to Oracle PL/SQL. This class provides the technical expertise necessary to utilize these powerful components of Oracle.
Attention in this class is given to some aspects of PL/SQL that are often not clearly understood (collections and overloading) or fully utilized (default values for program units, package startup code) along with advanced topics such as autonomous transactions, REF cursors and bulk binding. Some of the newer features of PL/SQL (the MERGE and CASE statements) are introduced. Techniques for measuring PL/SQL performance and features to enhance the performance of PL/SQL are also presented.
The functionality of a number of highly leverable Oracle supplied PL/SQL packages is covered.
This class can be conducted over a span of 2 or 3 days. See the Course Topics sections for the exact contents of each class duration.
Intermediate Oracle PL/SQL developers and DBAs.
Solid understanding of PL/SQL, including the use of program units (procedures, functions, packages and triggers) is required to succeed in this class.
Lecture with frequent hands on labs and several multi-group projects.
Code | Course Title | Duration | Level | |
---|---|---|---|---|
OR11D1 |
Oracle 11g/12c Developer: Introduction to PL/SQL |
2 Days |
I |
Details |
OR11E |
Oracle 11g/12c Essentials: SQL, SQL*Plus and PL/SQL |
5 Days |
I |
Details |
OR11D |
Oracle 11g/12c Developer: PL/SQL Complete |
5 Days |
I |
Details |
ORAPEX |
Oracle APEX Version 5.0.4 |
5 Days |
II |
Details |
OR11D2 |
Oracle 11g/12c Developer: Intermediate PL/SQL |
3 Days |
II |
Details |
ORSQLA |
Oracle 11g New and Advanced SQL Features For Developers |
3 Days |
III |
Details |
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.