Home / Courses / AI, Data & Analytics / Oracle Database: Develop PL SQL Program Units

Oracle Database: Develop PL SQL Program Units

Name: Oracle Database: Develop PL SQL Program Units
Availability: InStock
Rating: 4.6 (5878 reviews)

This Oracle Database: PL/SQL Program Units course builds on existing knowledge of PL/SQL block structure, variables, control structures and exception handling to explore the benefits of building Progran Units in this powerful programming language.<br><br>Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and triggers...

4.6 out of 5 rating
Last updated : 23/07/2026
English

Available as Instructor Led Training, Live Online & In Person at your Offices or Ours.

Enquire Now

Download Overview

Duration:

24.00 hours

19.5 CPD hours

Overview:

This Oracle Database: PL/SQL Program Units course builds on existing knowledge of PL/SQL block structure, variables, control structures and exception handling to explore the benefits of building Progran Units in this powerful programming language.

Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and triggers and utilise Oracle provided packages.

Description:

- Develop stored procedures to carry out database modifications.
- Write functions to be called from PL/SQL code or SQL statements.
- Use PL/SQL packages to group and contain related constructs.
- Create triggers to solve business challenges.
- Use Oracle supplied PL/SQL packages to generate screen output and file output.
- Examine the dependency chain on program units prior to implementing changes.

Available Delivery Options for Oracle Database: Develop PL SQL Program Units

Live Instructor Led Classroom Online (Live Online)
Traditional Instructor Led Classroom training (TILT/ILT)
Delivery at your offices in United Kingdom
Private dedicated course for your staff

How many CPD hours does Oracle Database: Develop PL SQL Program Units provide?

The 3 day Oracle Database: Develop PL SQL Program Units course gives you up to 19.5 CPD hours/structured learning hours.

Who is the correct audience for Oracle Database: Develop PL SQL Program Units?

- Database Administrator
- Developer
- Implementer
- Systems Administrator

Do you provide training for Oracle Database: Develop PL SQL Program Units?

Yes, we provide corporate training, dedicated training and closed classes for Oracle Database: Develop PL SQL Program Units. This can take place anywhere in United Kingdom including London, Manchester, Birmingham, Edinburgh or live online.

What is the duration of Oracle Database: Develop PL SQL Program Units?

The Oracle Database: Develop PL SQL Program Units training takes place over 3 day(s), with each day lasting approximately 24.00 hours including breaks.

What other terms do people search for?

Popular related searches include: Oracle Database: Develop PL SQL Program Units, Oracle Database Training, OCDBDPSPU

Why are Nexus Human the best provider for Oracle Database: Develop PL SQL Program Units?

Nexus Human are recognised as one of the best training companies. Our trainers have won awards including Small Firms Best Trainer, national training partner of the year for Ireland, and global top 30 instructor awards in 2012, 2019 and 2021.

Is there a discount code for Oracle Database: Develop PL SQL Program Units?

Yes, the discount code PENPAL5 is currently available for Oracle Database: Develop PL SQL Program Units training. Only one discount code can be used per booking.

DURATION 1 Day

No scheduled classes available at this time.

Training Insurance Included!

When you organise training, we understand that there is a risk that some people may fall ill, become unavailable.

To mitigate the risk we include training insurance for each delegate enrolled on our public schedule, they are welcome to sit on the same Public class within 6 months at no charge, if the case arises.