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 as well as practical experience in writing SQL statements.
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
Instructors were knowledgeable and helpful and the course content was useful and appropriate. The course will assist me with my job.
William - Trainee Developer - Legal
A fantastic instructor who cares and is clear with the content materials and yet considers everyone at a pace of which is comfortable for that individual. Helped in great depth with all of the course content by going through each section at a good pace and demonstrating with practical exercises. I really learned a lot this week and enjoyed my experience at Stay Ahead Training - I'm very pleased. Thanks very much.
Michael - Placement Student - Database Programmer - Government
Duration: 5 days
Price: £2,120.00 exc. VAT
Live Virtual Classroom
Our Customers Include
Our Course Curriculum