Home / Courses / AI, Data & Analytics / Oracle Database: PL/SQL Fundamentals

Oracle Database: PL/SQL Fundamentals

Name: Oracle Database: PL/SQL Fundamentals
Availability: InStock
Rating: 4.6 (5878 reviews)

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:

16.00 hours

13.0 CPD hours

Overview:

The Oracle Database: PL/SQL Fundamentals Ed 2 course introduces students to the PL/SQL programming language. In the class, students learn to create PL/SQL blocks of application code.

Learn To:

- Use various features of PL/SQL.
- Write anonymous blocks of code in PL/SQL.
- Use various PL/SQL conditional constructs and loops in program blocks.
- Interface the PL/SQL code with the database.
- Use stored procedures and functions in their program blocks.
- Handle Exceptions in PL/SQL code.
Benefits To You

Students will benefit from this course as it enables programmers with the skill of using this programming language. In the class students will learn to create anonymous PL/SQL blocks, to create procedures, functions and triggers. Students will learn to use explicit cursors in their program blocks. Demonstrations and hands-on practice reinforce the fundamental concepts. Students use Oracle SQL Developer to develop these program units. SQL*Plus is introduced as optional tools.

Description:

- Introduction
- Introduction to PL/SQL
- Declaring PL/SQL Variables
- Writing Anonymous PL/SQL blocks
- Using SQL Statements within a PL/SQL Block
- Writing Control Structures
- Working with Composite Data Types
- Using Explicit Cursors
- Handling Exceptions
- Creating Stored Procedures and Functions

Course Outline:

Introduction

- Course Objectives, Course Agenda and Class Account Information
- The Human Resources (HR) Schema
- Appendices Used in this Course
- PL/SQL Development Environments
Introduction to PL/SQL

- Understanding the benefits and structure of PL/SQL
- Understanding PL/SQL Blocks
- Generating output messages in PL/SQL
Declaring PL/SQL Variables

- Identifying valid and invalid identifiers
- Declaring and initializing variables
- Various data types
- Identifying the benefits of using the %TYPE attribute
- Using bind variables
Writing Anonymous PL/SQL blocks

- Lexical Units in a PL/SQL Block
- Using SQL Functions in PL/SQL
- Data Type Conversion
- Using Nested Blocks as Statements
- Referencing an Identifier Value in a Nested Block
- Qualifying an Identifier with a Label
- Operators in PL/SQL
- Using Sequences in PL/SQL Expressions
Using SQL Statements within a PL/SQL Block

- Using SQL Statements in PL/SQL
- Retrieving Data in PL/SQL with the SELECT statement
- Using Naming Conventions in DML Statements and data retrieval
- Manipulating Data on the Server Using PL/SQL
- SQL Cursors
- Using SQL Cursor Attributes to Obtain Feedback on DML
- Saving and Discarding Transactions
Writing Control Structures

- Controlling PL/SQL Flow of Execution
- Using IF and CASE Statements for conditional processing
- Handling Nulls
- Building Boolean Conditions with Logical Operators
- Using Iterative Control with Loop Statements
Working with Composite Data Types

- Composite Data Types of PL/SQL Records and Tables
- Using PL/SQL Records
- Inserting and Updating PL/SQL Records
- Using INDEX BY Tables
- Using Associative arrays
- Declaring and Using VArrays
Using Explicit Cursors

- Cursors
- Explicit Cursor Operations
- Controlling Explicit Cursors
- Using Explicit Cursors to Process Rows
- Cursors and Records
- Cursor FOR Loops Using Subqueries
- Explicit Cursor Attributes
- %NOTFOUND and %ROWCOUNT Attributes
Handling Exceptions

- Concept of Exception
- Handling Exceptions with PL/SQL
- Predefined Exceptions
- Trapping Predefined and Non-predefined Oracle Server Errors
- Functions that Return Information on Exceptions
- Usage of PRAGMA keyword
- Trapping User-Defined Exceptions
- Propagating Exceptions
Creating Stored Procedures and Functions

- Overview of Stored Procedures and Functions
- Differentiating between anonymous blocks and subprograms
- CREATE OR REPLACE PROCEDURE | FUNCTION
- Understanding the Header Area of a Stored Procedure and Function
- Creating Simple Procedures and Functions
- Creating a Simple Procedure with an IN Parameter
- Executing a Procedure and a Function

Available Delivery Options for Oracle Database: PL/SQL Fundamentals

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: PL/SQL Fundamentals provide?

The 2 day Oracle Database: PL/SQL Fundamentals course gives you up to 13.0 CPD hours/structured learning hours.

Who is the correct audience for Oracle Database: PL/SQL Fundamentals?

- Database Administrators
- System Analysts
- Forms Developer
- Technical Consultant
- Portal Developer
- PL/SQL Developer

Do you provide training for Oracle Database: PL/SQL Fundamentals?

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

What is the duration of Oracle Database: PL/SQL Fundamentals?

The Oracle Database: PL/SQL Fundamentals training takes place over 2 day(s), with each day lasting approximately 16.00 hours including breaks.

What other terms do people search for?

Popular related searches include: Oracle Database: PL/SQL Fundamentals, Oracle Database Training, D80182

Why are Nexus Human the best provider for Oracle Database: PL/SQL Fundamentals?

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: PL/SQL Fundamentals?

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

DURATION 16.00 Hours

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.