-
-
Cart
There are no items in your cart. Continue shopping on our Course Directory page.
SUBTOTALPay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.
-
Oracle PL/SQL Programming Training
Level: Intermediate
Rating:
4.69/5 Based on 163 Reviews
This Oracel 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.
Key Features of this PL/SQL Training
- After-course instructor coaching benefit
- Learning Tree end-of-course exam included
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
Choose the Training Solution That Best Fits Your Individual Needs or Organisational Goals
LIVE, INSTRUCTOR-LED
In Class & Live, Online Training
- 5-day instructor-led training course
- After-course instructor coaching benefit
- Learning Tree end-of-course exam included
TRAINING AT YOUR SITE
Team Training
- Bring this or any training to your organisation
- Full - scale program development
- Delivered when, where, and how you want it
- Blended learning models
- Tailored content
- Expert team coaching
Customize Your Team Training Experience
CONTACT USSave More on Training with Learning Tree Training Vouchers!
Our flexible, easy-to-redeem training vouchers are available to any employee within your organisation. For details, please call 0800 282 353 or chat live.
In Class & Live, Online Training
Note: This course runs for 5 Days *
*Events with the Partial Day Event clock icon run longer than normal but provide the convenience of half-day sessions.
-
10 - 14 Aug 9:00 AM - 4:30 PM BST Online (AnyWare) Reserve Your Seat
-
12 - 16 Oct 9:00 AM - 4:30 PM BST London / Online (AnyWare) Reserve Your Seat
-
22 - 26 Feb 9:00 AM - 4:30 PM GMT London / Online (AnyWare) Reserve Your Seat
-
24 - 28 May 9:00 AM - 4:30 PM BST London / Online (AnyWare) Reserve Your Seat
-
5 - 9 Oct 2:00 PM - 9:30 PM BST New York / Online (AnyWare) Reserve Your Seat
-
8 - 12 Feb 2:00 PM - 9:30 PM GMT Herndon, VA / Online (AnyWare) Reserve Your Seat
-
22 - 26 Mar 1:00 PM - 8:30 PM GMT New York / Online (AnyWare) Reserve Your Seat
Guaranteed to Run
When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time — will run. Guaranteed.Partial Day Event
Learning Tree offers a flexible schedule program. If you cannot attend full day sessions, this option consists of four-hour sessions per day instead of the full-day session.PL/SQL Course Information
-
Requirements
- Knowledge at the level of:
- Course 2226, Oracle Database 12c Introduction, or
- Course 925, SQL Programming Language Introduction
- Knowledge at the level of:
-
Software
- This course is currently running on Oracle 12c
PL/SQL Course Outline
-
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
-
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
-
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
-
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
-
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
-
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
-
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
Team Training
PL/SQL Training FAQs
-
What software does this Oracle PL/SQL course run on?
This course is currently running on Oracle 12c.
-
Can I learn Oracle PL/SQL programming online?
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.
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.