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.
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
Course content was well explained and we were given plenty of time to work on practical examples. All examples were explained in detail so even if I struggled with completing the exercises on first reading, subsequent explanation meant I understood the logic behind the example and could use it going forward. Workbook contains a great deal of content and useful references to practice what we learned going forward. Thank you for a great course!
Abbi - Production Support 1st Line Analyst - Insurance
Duration: 2 days
Price: £895.00 exc. VAT
|04 Mar 2021||Filling||Book Now|
|25 Mar 2021||Limited||Book Now|
|12 Apr 2021||Spaces||Book Now|
|22 Apr 2021||Spaces||Book Now|
|20 May 2021||Spaces||Book Now|
|07 Jun 2021||Spaces||Book Now|
|17 Jun 2021||Spaces||Book Now|
|22 Jul 2021||Spaces||Book Now|
|26 Jul 2021||Spaces||Book Now|
|19 Aug 2021||Spaces||Book Now|
|16 Sep 2021||Spaces||Book Now|
|20 Sep 2021||Spaces||Book Now|
|14 Oct 2021||Spaces||Book Now|
|11 Nov 2021||Spaces||Book Now|
|15 Nov 2021||Spaces||Book Now|
|09 Dec 2021||Spaces||Book Now|
|17 Jan 2022||Spaces||Book Now|
Live Virtual Classroom
Our Customers Include
Our Course Curriculum