Oracle 11g Advanced PL/SQL
Duration: 3 Days
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.
Topics Covered In This Course
Oracle's SQL tools
New Oracle features
Working with block hierarchies
Advanced exception handling
Maintaining PL/SQL stored program units
Advanced features of packages
Advanced features of triggers
Advanced cursor topics
Oracle supplied packages
PL/SQL composite variables
Working with large objects (LOBs)
PL/SQL performance tuning
Advanced compilation techniques
Who Should Take This Course
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.
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.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]