Course Code: OPPL
Duration: 5 days
The Oracle Program with PL/SQL training course introduces the delegate to Oracle's PL/SQL programming language and provides practical experience in writing stand-alone programs, developing database triggers and implementing stored functions, procedures and packages. 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.
To provide the skills needed to develop, write and maintain PL/SQL scripts, triggers, stored program units and packages.
Oracle database administrators, software development personnel and database support staff who need to write PL/SQL scripts and implement or maintain database triggers, program units and packages.
Combination of the PL/SQL and PL/SQL Stored Program Units courses. Delegates may book this course as a one 5 Day course starting on a Monday or as two courses, the dates to be selected from the PL/SQL and PL/SQL Stored Program Units scheduled dates.
The delegate will learn and acquire skills as follows:
The Oracle Program with PL/SQL course will teach the major topics required for the delegate to work towards achieving the following exam:
Attending this course will help delegates gain many of the skills and product knowledge requirements as outlined in the exam objectives. Studying this course and its associated reference materials can form part of the preparation to achieve certification. Experience, practice, self-study and aptitude are also key requirements for exam success.
Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.
Exams are not included as part of the course.
A working knowledge of Oracle SQL or SQL Developer is required along with practical experience in writing SQL statements. This can be obtained by attendance on the pre-requisite courses. Some previous programming experience will also prove advantageous.
The course provided the exact amount of detail in each area for what I needed. I feel I have drawn a lot out of the course and this is massively improve the work that I carrying out in my day to day work.
Tim - Trainee Application Developer - Defence - February 2022
Kevin is a greater instructor and very knowledgeable trainer in PL/SQL database development. he has a very good mind to debug coding problems given to him.
Brian - IT - December 2021
The trainer is a great mentor who uses the training materials to supplement his teaching methods. He demonstrated and created worked examples in front of us, showing us how the code fits together to achieve the task at hand. His explanations were always clear. 10/10 would recommend.
Hayden - Applications Developer - IT
An enjoyable course. The pace and balance between theory, exercises and breaks was spot on. The instructors were very knowledgeable and patient. A good week.
Alan - Computer Programmer - Utilities
The trainers were very thorough and went the extra mile to explain the concepts and supply additional materials. I found them very dedicated to the work, which helped create the right learning atmosphere.
Isaac - Data Analyst - Retail / Hire
Excellent course, very detailed. The instructor paced the course over the 5 days to ensure I got the most out of the course for my specific needs. I was encouraged to ask questions and raise my hand when stuck. I would highly recommend this course to others.
Lee - Reporting, Quality and Analyst Manager - Insurance
Duration: 5 days
Price: £2,120.00 exc. VAT
Live Virtual Classroom
Our Customers Include
Our Course Curriculum