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.
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.
Oracle Advanced PL/SQL
Duration: 3 days
RRP: £1,350.00 exc. VAT
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!
Our Course Curriculum