Oracle Advanced PL/SQL

Delegates:This course, designed for Oracle database administrators and software development personnel who need to gain practical experience of the advanced features of PL/SQL such as program design, packages, cursors, large objects and collections. Objectives:By the end of this course delegates will be able to effectively tune PL/SQL code; create subtypes; create and use collections; execute external C programs and Java programs from PL/SQL;use fine-grained access control; use LOB data types and the DBMS_LOB package; use SecureFile LOBs; effectively design cursors; improve memory usage with PL/SQL result caching and SQL result sets; and apply coding standards to avoid SQL injection attacks. This course is suitable for delegates intending to sit the Oracle exam #1Z0-146: Oracle Database 11g: Advanced PL/SQL . Note:Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience. Topics Covered: Designing PL/SQL Code for Performance Using Collections Calling C and Java from PL/SQL Virtual Private Database and Fine Grained Access Control Manipulating Large Objects Administering SecureFile LOBs Tuning PL/SQL Code for Performance Using Result Caching to Improve Performance Using the SQL Query Result Cache Using the PL/SQL Function Cache Analyzing PL/SQL Code Tracing PL/SQL Program Execution Profiling PL/SQL Applications Creating Code Secure from SQL Injection Attacks Using the DBMS_ASSERT Package