WA1382 Oracle Database 10g: Advanced PL/SQL Programming & Tuning
Audience
The target audience for this course is senior application developers. Developers who will be building, debugging and tuning PL/SQL program units will benefit from this course.
Course Prerequisites

Mandatory prerequisites for this course are the following courses:

• The course Oracle Database 10g: Introduction to SQL - Complete Library
• The course Oracle Database 10g: Program With PL/SQL - Complete Library

Course Objectives:
The objective of this course is to allow experienced PL/SQL developers to write efficient programs. Advanced techniques which not only improve execution speed but also enhance the functionality of the programs are also discussed. Among the specific objectives to be met with this course are these:

• Exploiting and managing cursor sharing.
• Utilizing cursor variables.
• Invoking external procedures.
• Including dynamic SQL and other advanced programming techniques.
• Efficiently executing dynamic SQL using bulk bind techniques.
• Tuning with the DBMS_PROFILER() system-supplied package.
• Debugging with the DBMS_TRACE() system-supplied package.
• Performance tuning and analysis of PL/SQL applications

Duration:
Four days.
More Information
Schedule this course
Course Outline
Download this page as a word document