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 delegates will practise:
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.
NOTE: Course technical content is subject to change without notice.
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.
Having previously undertaken a similar course in the past I expected this course to not be especially beneficial, however this was not the case at all. I have garnered some very useful new skills and knowledge. The trainer's subject knowledge and delivery are a credit to himself and Stayahead. I was constantly engaged and rarely found myself requiring a repeat of the coursework but when needed he was more than helpful in explaining where I was struggling.Laurence - Operations Support - Finance - September 2017