Virtual Instructor-Led Training

Onsite Training

Oracle Database: PL/SQL Fundamentals Ed 2

Networking

AI & Data

Oracle Database

Oracle

<ul><li>Course Objectives, Course Agenda and Class Account Information</li><li>The Human Resources (HR) Schema</li><li>Appendices Used in this Course</li><li>PL/SQL Development Environments</li></ul>

Introduction

<ul><li>Understanding the benefits and structure of PL/SQL</li><li>Understanding PL/SQL Blocks</li><li>Generating output messages in PL/SQL</li></ul>

Introduction to PL/SQL

<ul><li>Identifying valid and invalid identifiers</li><li>Declaring and initializing variables</li><li>Various data types</li><li>Identifying the benefits of using the %TYPE attribute</li><li>Using bind variables</li></ul>

Declaring PL/SQL Variables

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

Writing Anonymous PL/SQL blocks

<ul><li>Using SQL Statements in PL/SQL</li><li>Retrieving Data in PL/SQL with the SELECT statement</li><li>Using Naming Conventions in DML Statements and data retrieval</li><li>Manipulating Data on the Server Using PL/SQL</li><li>SQL Cursors</li><li>Using SQL Cursor Attributes to Obtain Feedback on DML</li><li>Saving and Discarding Transactions</li></ul>

Using SQL Statements within a PL/SQL Block

<ul><li>Controlling PL/SQL Flow of Execution</li><li>Using IF and CASE Statements for conditional processing</li><li>Handling Nulls</li><li>Building Boolean Conditions with Logical Operators</li><li>Using Iterative Control with Loop Statements</li></ul>

Writing Control Structures

<ul><li>Composite Data Types of PL/SQL Records and Tables</li><li>Using PL/SQL Records</li><li>Inserting and Updating PL/SQL Records</li><li>Using INDEX BY Tables</li><li>Using Associative arrays</li><li>Declaring and Using VArrays</li></ul>

Working with Composite Data Types

<ul><li>Cursors</li><li>Explicit Cursor Operations</li><li>Controlling Explicit Cursors</li><li>Using Explicit Cursors to Process Rows</li><li>Cursors and Records</li><li>Cursor FOR Loops Using Subqueries</li><li>Explicit Cursor Attributes</li><li>%NOTFOUND and %ROWCOUNT Attributes</li></ul>

Using Explicit Cursors

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

Handling Exceptions

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

Creating Stored Procedures and Functions

Familiarity with data processing concepts and technique.

Project Management Professional (PMP)

courseBanner

Course Banner

courseOverview

Course Overview section

courseAnnouncement

Additional information.

courseDetails

What you will learn

targetAudience

Who should attend

courseOutline

Course Outline

courseFAQ

Coursepromobanner

Course Promobanner Section

courseRelatedTargets

Course Related Targets

courseTicker

Course Ticker

preRequisites

Prerequisites

courseTestimonials

Customer Testimonials

courseLocations

Find More Locations by NetCom Learning For This Training

For Your convenience we are offering This course at more locations. Expand your training options and accelerate your learning journey with NetCom.

Oracle Database: PL/SQL Fundamentals Ed 2 will help students learn to create PL/SQL blocks of application code.

Oracle Database: PL/SQL Fundamentals Ed 2 Course 

Microsoft

AI CERTs™

Google Cloud

Cisco

Amazon Web Services

CompTIA

EC-Council

ISC2

ITIL

Autodesk

Cloud

Security

App Development

Architecture & Design

Business Applications

Business Process

Business & Leadership

e-Learning

Trainings

Managed Learning Services

NetCom365

Learning Passport

EdAssist

Talents for Hire

NetCom Learning Academy

AI Summer Skill Fest 2025

Financial Services

Healthcare

Federal Government

State & Local Government

Technology

Complimentary AI+ Foundation™ Training

Free AI Training Consultation

AI Certs Training Bundles

CompTIA Continuing Education (CE)

CompTIA Exam Prep e-Learning Bundles

Microsoft ECIF Program

Microsoft QuickStart Program

Microsoft Partner Training

Microsoft AI Bootcamp for Educators

Microsoft Applied Skills

AWS Skill Builder

AWS Blended Learning

AWS Learning Needs Analysis (LNA)

AWS e-Learning

Cisco Continuing Education (CE)

Cisco Learning Credits

Cisco U

Free Networking Training Consultation

Google Cloud Leadership AI Training

Solutions

Resources

Company

<p>The Oracle Database: PL/SQL Fundamentals Ed 2 course introduces students to PL/SQL programming, teaching them to create PL/SQL blocks and develop application code in an Oracle environment.</p>

Oracle Database: PL/SQL Fundamentals Ed 2

Upcoming Schedules

Course Prerequisites

Required

Course Outline