Course Code: OPI
Duration: 2 days
The Oracle PL/SQL course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs of the PL/SQL Programming Language.
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 write stand-alone programs using the main features of Oracle's PL/SQL Programming Language.
Oracle database administrators, software development personnel and database support staff who need to write PL/SQL scripts to enhance their productivity in manipulating data.
The 2 Day Oracle PL/SQL course can be combined with the 3 Day Stored Program Units course, this is equivalent to attending the 5 Day Oracle Program with PL/SQL course.
The delegate will learn and acquire skills as follows:
This Oracle PL/SQL course, together with the Oracle PL/SQL Stored Program Units course, covers 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 these courses and their 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 SQL*Plus or SQL Developer and Oracle SQL is required along with practical experience in writing SQL statements. This can be obtained by attendance on the pre-requisite course. Some previous programming experience will also prove advantageous.
The course covered everything I needed to learn with regards to PL/SQL, it was also delivered in a very engaging and understanding way.
Matt - Application Support Analyst/Programmer - Housing Association / Managed - March 2021
I think taking this course is a right step for anyone who wishes to enhance their current skills and learn in depth about practices, principles and efficient PL/SQL coding. Course content is phenomenal and packed full of information!
Kasia - Business Systems Engineer - Manufacturing
Great informative course, easy to understand. Duncan is fantastic at helping you to understand the parts of the course your aren't familiar with, great instructor.
Sarah - Application support analyst - Transport
Good course, relevant materials and well explained. Good lab work and opportunities for question answering. Facilities excellent, clean and well maintained.
Jamie - Utilities
I thought this was a really well placed course and the instructor was excellent.
Will - Developer - Government
The trainer was extremely helpful, very pleasant atmosphere and an overall positive experience.
Kamila - Trainee Oracle Developer - IT
Duration: 2 days
Price: £895.00 exc. VAT
Live Virtual Classroom
Our Customers Include
Our Course Curriculum