0345 4506120

Oracle Advanced PL/SQL

Software development personnel and Oracle database administrators who need to take advantage of the advanced features of PL/SQL in Oracle Database 10g and Oracle Database 11g.

Learning Objectives

By the end of this Oracle Advanced PL/SQL 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.

Pre-Requisites

Practical experience of Oracle SQL or SQL Developer and a good working knowledge of the fundamentals of the PL/SQL programming language are required.

Course Content

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.

It also introduces some of the Oracle-supplied packages.

This Oracle Advanced PL/SQL course is suitable for users of Oracle Database 10g and Oracle Database 11g.

Exams & Certification

This Oracle Advanced PL/SQL course is suitable for delegates intending to sit the Oracle examination #1Z0-146: Oracle Database 11g: Advanced PL/SQL.

Exams are not included as part of the course.

Before taking any exam, ensure you have the recommended experience.  The Oracle website lists all exam requirements and these are updated regularly.

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Our Customers Include