Home / Courses / Software Development & Programming / Oracle 19c PL/SQL Fundamentals (TTOR12019)

Oracle 19c PL/SQL Fundamentals (TTOR12019)

Name: Oracle 19c PL/SQL Fundamentals (TTOR12019)
Availability: InStock
Rating: 4.6 (5878 reviews)

Oracle 19c PL/SQL Fundamentals®is a three-day, hands-on technical course that introduces Oracle database programming using the PL/SQL programming language. Throughout the course students will explore the core syntax, structure and features of the language. This course will also lay the foundation for the entire Oracle PL/SQL programming series, allowing one...

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:

Description:

Oracle 19c PL/SQL Fundamentals is a three-day, hands-on technical course that introduces Oracle database programming using the PL/SQL programming language. Throughout the course students will explore the core syntax, structure and features of the language. This course will also lay the foundation for the entire Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. The course also explores applying the newly learned skills to the development of database applications. Participants will learn how to use database-resident stored program units such as procedures, functions, packages and database triggers. Students will also learn about the latest features in Oracle 19c.

Course Outline:

Selection & Setup of the Database Interface

Considering Available Tools
Selecting the Appropriate Tool
Oracle Net Database Connections
Oracle PAAS Database Connections
Setup SQL Developer
Setup SQL *Plus
Setup JDeveloper
About BIND and Substitution Variables
Using SQL Developer
Using SQL *Plus
Choosing a Database Programming Language

What is Database Programming
PL/SQL Programming
PL/SQL Performance Advantages
Integration with Other Languages
PL/SQL Language Essentials

PL/SQL Program Structure
Language Syntax Rules
Embedding SQL
Writing Readable Code
Generating Readable Code
Generating Database Output
SQL * Plus Input of Program Block
DECLARE Section

About the Declare Section
Declare Primitive Types
Declaration Options
Not Null
Constant
Data Dictionary Integration
% Type
Declare Simple User-Defined Types
Type ¦ Table
Type ¦ Record
Extended User Defined Types
BEGIN Section

About the Begin Section
Manipulating Program Data
Logic Control & Braching
GOTO
LOOP
IF-THEN-ELSE
CASE
EXCEPTION Section

About the Exception Section
Isolating the Specific Exception
Pragma Exception_INIT
SQLCODE &SQLERRM Example
SQL%ROWCOUNT & Select ¦ Into
Beyond the Basics : Explicit Cursors

About Explicit Cursors
Extend Cursor Techniques
For Update of Clause
Where Current of Clause
Using for ¦ Loop Cursors
Introduction Database Resident Programming Units

About Database €œ Resident Programs
Physical Storage & Execution
Types of Stored Program Units
Stored Program Unit Advantages
Modular Design Principles
Creating Stored Procedures and Functions

Stored Procedures & Functions
Create Procedure / Create Function
Creating Procedures & Functions
Raise_Salary() Procedure
Salary_Valid() function
The Parameter Specification
Default Clause
System & Object Privileges
Using the Development Tools
Executing Stored Procedures and Functions

Calling Procedures & Functions
Unit Testing with Execute
Anonymous Block Unit Testing
Specifying a Parameter Notation
SQL Worksheet Unit Testing
Calling Functions from SQL
Maintaining Stored Programming Units

Recompiling Programs
Mass Recompilation Using UTL_RECOMP()
Dropping Procedures & Functions
Drop Procedures & Functions
Drop Procedure / Function
Data Dictionary Metadata
Using USER_OBJECTS
Using USER_SOURCE
Using USER_ERRORS
Using USER_OBJECT_SIZE
Using USER_DEPENDENCIES
Managing Dependencies

Dependency Internals
Tracking Dependencies
The Dependency Tracking Utility
SQL Developer Dependency Info
Dependency Strategy Checklists
Creating & Maintaining

About Packages
Creating Packages
Maintaining Packages
Performance Considerations
Advanced Package Capabilities

Definer & Invoker Rights
White Lists & Accessible By
Persistent Global Objects
Defining Initilization Logic
Object Orientation Support
Advanced Cursor Techniques

Using Cursor Variables
Using SYS_REFCURSOR
Using_Cursor Expressions
Using System Supplied Packages

DBMS_OUTPUT()
UTL_FILE()
FOPEN() Example
Database Trigger Concepts

About Database Triggers
DML Event Trigger Sub-Types
Database Trigger Scenario
Trigger Exhaustion Mechanisms
Trigger within SQL Worksheet
Creating Database Triggers

Statement Level Triggers
Using Raise Application_Error()
Row-Level Triggers
Examples of Triggers
Employee_Salary_Check Example
Employee_Journal Example
Budget_Event Example
Instead of Triggers
Triggers within and Application
Maintaining Database Triggers

Call Syntax
Trigger Maintenance Tasks
Show Errors Trigger
Drop Trigger
Alter Trigger
Multiple Triggers for a Table
Handling Mutating Table Issues
Implementing System Event Triggers

What are System Event Triggers
Defining the Scope
Available System Events
System Event Attributes

Available Delivery Options for Oracle 19c PL/SQL Fundamentals (TTOR12019)

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 19c PL/SQL Fundamentals (TTOR12019) provide?

The 3 day Oracle 19c PL/SQL Fundamentals (TTOR12019) course gives you up to 19.5 CPD hours/structured learning hours.

Who is the correct audience for Oracle 19c PL/SQL Fundamentals (TTOR12019)?

This course is geared for anyone needing to interface with an Oracle database such as end users, business analysts, application developers and database administrators / DBAs. Attendees should have incoming basic SQL experience, as well as an understanding of databases (required to manipulate it with PL/SQL).

Do you provide training for Oracle 19c PL/SQL Fundamentals (TTOR12019)?

Yes, we provide corporate training, dedicated training and closed classes for Oracle 19c PL/SQL Fundamentals (TTOR12019). This can take place anywhere in United Kingdom including London, Manchester, Birmingham, Edinburgh or live online.

What is the duration of Oracle 19c PL/SQL Fundamentals (TTOR12019)?

The Oracle 19c PL/SQL Fundamentals (TTOR12019) 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: PL/SQL; Oracle

Why are Nexus Human the best provider for Oracle 19c PL/SQL Fundamentals (TTOR12019)?

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 19c PL/SQL Fundamentals (TTOR12019)?

Yes, the discount code PENPAL5 is currently available for Oracle 19c PL/SQL Fundamentals (TTOR12019) 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.