Course Code: OAP
Duration: 3 days
Our training courses can also be delivered at a location of your choice...
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.
Versions supported 11gR2, 12cR2, 18c, 19c.
The delegate will learn and acquire skills as follows:
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.
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.
This Oracle Advanced PL/SQL course will teach the major topics required for the delegate to work towards achieving the following Oracle examinations:
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.
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.
Oracle Advanced PL/SQL
Duration: 3 days
RRP: £1,350.00 exc. VAT
Virtual & London Schedule
We are running a full Virtual schedule
|08 Jul 2020||Spaces||Book|
|21 Dec 2020||Spaces||Book|
|30 Mar 2021||Spaces||Book|
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 - November 2019
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
Excellent Course, everything explained well and good layout of course material.
Julian - Graduate Systems Consultant
A useful course by a knowledgable instructor, which has been of value and should prove beneficial to my career and my orgainasation.
Steve - Systems Analyst
Public Scheduled and Closed
UK and Overseas
Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.
Cannot see a sutiable date?
Please call us and we will try an accommodateyour needs!
StayAhead Live Virtual Classroom
Our Course Curriculum