|
Oracle Database 10g: Advanced PL/SQL Programming & Tuning |
|
|
|
Course Length - 4 Days 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 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.
Mandatory Prerequisites
• The Dashcourses International course Oracle Database 10g: Introduction to SQL - Complete Library
• The Dashcourses International course Oracle Database 10g: Program with PL/SQL - Complete Library
|
