Course Code: OAP
Duration: 3 days
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.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Versions supported 11gR2, 12cR2, 18c, 19c.
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.
Software development personnel and Oracle database administrators who need to take advantage of the advanced features of PL/SQL in Oracle Database.
Practical experience of Oracle SQL or SQL Developer and a good working knowledge of the fundamentals of the PL/SQL programming language are required.
Versions supported 11gR2, 12c, 18c and 19c.
The delegate will learn and acquire skills as follows:
Practical experience of Oracle SQL and the PL/SQL programming language is required. This can be gained by attendance on the pre-requisite courses. Familiarity with the Oracle Database is also required.
Fantastic course, learned a lot. Great pace, concepts well explained. Thanks!
Gail - Senior BI Developer - Finance - March 2022
Documentation and lab environments are great and the instructor was friendly and very knowledgeable.
Scott - September 2021
Very useful course explaining new features for use within Oracle PL/SQL for Interfaces, programming standards and large data volumes. The sections exploring many techniques for Pl/SQL performance tuning, profiling, tracing, best practices and code analysis will be very useful in my role in support to assist trouble-shooting performance issues in our PL/SQL code and processes used in the Production systems. new techniques for development were also discussed. The instruction was good and with practice where required and plenty of discussion for the real world application. Would recommend this course for Advanced Pl/SQL developers.
Andrew - Application Support Manager - Transport
That was an excellent course and a very good teacher. I enjoyed the whole content explained by the trainer.
Justyna - Application Database Administrator - Pharmaceuticals
Course was excellent and I can take away and use many of the areas explained straight away. I'd recommend this course to any established PL/SQL Developer as you will learn about new things that can be used in the workplace. The course tutor was excellent and shows the real depth of their knowledge of the Oracle database environment.
Andy - Senior Developer - IT
Excellent tutorship; friendly, engaging and very knowledgeable. The course surpassed my expectations. The content will certainly help me deliver more when back at work.
Luke - Developer - Finance
Live Virtual Classroom
Our Customers Include
Our Course Curriculum