Home
Courses
Oracle® PL/SQL Training

Oracle® PL/SQL Training

Course 493

Duration: 5 days
Labs: Yes
Language: English
29 NASBA CPE Credits (live, in-class training only)
Level: Intermediate

This Oracle® PL/SQL training course will teach you to increase the productivity, performance, scalability, portability, and security of your Oracle database. With this training, you will learn how to execute PL/SQL programs in Oracle, build stored procedures, design, and execute modular applications, and increase the efficiency of data movement — essential skills for any Oracle developer.

Oracle PL/SQL Programming Training Delivery Methods

In-Person
Online

Oracle PL/SQL Programming Training Course Information

In this Oracle PL/SQL Programming training, you will learn how to:

Develop efficient PL/SQL programs to access Oracle databases.
Create stored procedures and functions for reuse and maintenance.
Design modular applications using packages.
Manage data retrieval for front-end applications.
Invoke native dynamic SQL to develop high-level abstract code.

Oracle PL/SQL Programming Training Course Prerequisites

Students taking this course should have basic knowledge of SQL as taught in Learning Tree course 925, Introduction to SQL Course OR Learning Tree course 2226, Introduction to Oracle Database 12c Training.

Oracle PL/SQL Course Outline

Module 1: Introduction and Overview

PL/SQL fundamentals

Declaring and anchoring variables to database definitions
Flow control constructs

Oracle 11g and 12c PL/SQL features

PL/Scope in Oracle 11g
Returning implicit cursor results from stored procedures in Oracle 12c
Declaring local functions within SELECT statements in Oracle 12c

Module 2: Data Manipulation Techniques

Maintaining data with DML statements

Employing the RETURNING INTO clause
Solving the fetch-across-commit problem

Managing data retrieval with cursors

Implications of explicit and implicit cursors
Simplifying cursor processing with cursor FOR LOOPs
Embedding cursor expressions in SELECT statements

Cursor variables

Strong vs. weak cursor variables
Passing cursor variables to other programs
Defining REF CURSORS in packages

Module 3: Developing Well-Structured and Error-Free Code

Error handling using EXCEPTIONs

Propagation and scope
"Retrying" problem transactions with EXCEPTION processing

Debugging PL/SQL blocks

Simplifying testing and debugging with conditional compilation
Interpreting compiler messages
Applying structured testing techniques
Building and applying a test bed
Leveraging the debugging facilities in SQL Developer

Module 4: Achieving Maximum Reusability

Writing stored procedures and functions

Calling and invoking server-side logic
Passing input and output parameters
Implementing an autonomous transaction

Coding user-written functions

Calling PL/SQL functions from SQL
Building table-valued functions

Developing safe triggers

Employing :OLD and :NEW variables
Avoiding unreliable trigger constructs
Exploiting schema and database triggers

Module 5: Exploiting Complex Datatypes

Collection types

PL/SQL tables, nested tables, VARRAYs
Stepping through dense and nonconsecutive collections

Bulk binding for high performance

Moving data into and out of PL/SQL blocks
BULK COLLECT INTO and FORALL
BULK cursor attributes
BULK EXCEPTION handling

Module 6: Invoking Native Dynamic SQL

Finessing the compiler

The EXECUTE IMMEDIATE statement
The RETURNING INTO clause

Types of dynamic SQL

Building SQL statements during runtime
Autogenerating standard code

Module 7: Package Tips and Techniques

Package structure: SPEC and BODY
Eliminating dependency problems
Overloading for polymorphic effects
Evaluating application frameworks
Declaring and using persistent global variables

Get This Course $3,190

5-day instructor-led training course
Learning Tree end-of-course exam included
After-course instructor coaching benefit

#493

Oct 30 - Nov 3 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
Nov 27 - Dec 1 9:00 AM - 4:30 PM EST

Herndon, VA or Virtual
Dec 11 - 15 11:00 AM - 6:30 PM EST

Aurora, CO or Virtual
Jan 8 - 12 9:00 AM - 4:30 PM EST

New York or Virtual
Feb 12 - 16 12:00 PM - 7:30 PM EST

San Francisco or Virtual
Mar 18 - 22 9:00 AM - 4:30 PM EDT

Herndon, VA or Virtual
Apr 22 - 26 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
Jun 10 - 14 11:00 AM - 6:30 PM EDT

Aurora, CO or Virtual

Scroll to view additional course dates

5-day instructor-led training course
Learning Tree end-of-course exam included
After-course instructor coaching benefit

#493

Oct 30 - Nov 3 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
Nov 27 - Dec 1 9:00 AM - 4:30 PM EST

Herndon, VA or Virtual
Dec 11 - 15 11:00 AM - 6:30 PM EST

Aurora, CO or Virtual
Jan 8 - 12 9:00 AM - 4:30 PM EST

New York or Virtual
Feb 12 - 16 12:00 PM - 7:30 PM EST

San Francisco or Virtual
Mar 18 - 22 9:00 AM - 4:30 PM EDT

Herndon, VA or Virtual
Apr 22 - 26 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
Jun 10 - 14 11:00 AM - 6:30 PM EDT

Aurora, CO or Virtual

Scroll to view additional course dates

Bring this or any training to your organization
Full-scale program development
Delivered when, where, and how you want it
Blended learning models
Tailored content
Expert team coaching

#493

Questions about this course?

Customize Your Team Training Experience

Fill out the form below or call 888-843-8733

* Required Fields

Preferred method of contact:

Phone

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Course FAQs

This course is currently running on Oracle 12c.

Yes! We know your busy work schedule may prevent you from getting to one of our classrooms, which is why we offer convenient online training to meet your needs wherever you want, including online training.

Oracle® PL/SQL Training

Oracle PL/SQL Programming Training Delivery Methods

Oracle PL/SQL Programming Training Course Information

Oracle PL/SQL Course Outline

Module 1: Introduction and Overview

Module 2: Data Manipulation Techniques

Module 3: Developing Well-Structured and Error-Free Code

Module 4: Achieving Maximum Reusability

Module 5: Exploiting Complex Datatypes

Module 6: Invoking Native Dynamic SQL

Module 7: Package Tips and Techniques

Course FAQs

What software does this Oracle PL/SQL course run on?

Can I learn Oracle PL/SQL programming online?

Related Courses