Course Code: OAP
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 11g R2 and Oracle Database 12c.
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 11g R2 and Oracle Database 12c.
Practical experience of Oracle SQL or SQL Developer and a good working knowledge of the fundamentals of the PL/SQL programming language are required.
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.
That was an excellent course and a very good teacher. I enjoyed the whole content explained by the trainer.
Justyna - Application Database Administrator - Pharmaceuticals - December 2017
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
If the course you require is not scheduled at your preferred centre, please contact us on 020 7600 6116 or firstname.lastname@example.org to enquire if we can accommodate your venue requirements.
Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.
Very informative course. Covered a lot of ground in the time given. Good basis to further develop upon. I look forward to further follow up training in due course. Instructor was very engaging and knowledgeable.Naj - Analyst - Finance - March 2018