Oracle PL/SQL Training

PL/SQL is Oracle's extension language for standard SQL.

In this PL/SQL training class, students who already know SQL learn to use PL/SQL to write sophisticated queries against an Oracle database.

Location

Public Classes: Delivered live online via WebEx and guaranteed to run . Join from anywhere!

Private Classes: Delivered at your offices , or any other location of your choice.

Course Topics
  1. Learn what PL/SQL is.
  2. Learn how to declare, name, assign and output variables in PL/SQL.
  3. Learn about data types in PL/SQL.
  4. Learn about the main features of PL/SQL.
  5. Learn how to write a simple block of PL/SQL code.
  6. Learn about subprograms in PL/SQL.
  7. Learn to create and call procedures.
  8. Learn to create and call functions.
  9. Understand BOOLEAN values and expressions.
  10. Learn to write IF conditions.
  11. Learn to use the CASE statement.
  12. Learn to handle exceptions in PL/SQL.
  13. Learn about how cursors works.
  14. Learn to use implicit cursors.
  15. Learn to use explicit cursors.
  16. Learn to use packages to group related PL/SQL objects.
  17. Learn to use triggers for validating data and auditing changes to the database.
Outline
  1. PL/SQL Basics
    1. What is PL/SQL?
    2. Blocks
    3. Outputting Information
    4. Variables and Constants
    5. Constants
    6. Data Types
    7. Naming Variables and Other Elements
    8. Embedding SQL in PL/SQL
    9. SELECT...INTO and RETURNING...INTO
    10. PL/SQL Features
  2. Subprograms
    1. Introduction to Subprograms
    2. Procedures
    3. Variable Declarations
    4. Dropping a Procedure
    5. Parameters
    6. Parameters with Default Values
    7. Parameter Modes
    8. IN Mode
    9. OUT Mode
    10. IN OUT Mode
    11. Named Notation
    12. Using SQL in a Subprogram
    13. %TYPE
    14. Functions
    15. Using PL/SQL Functions in SQL Queries
  3. Conditional Processing
    1. Conditions and Booleans
    2. IF-ELSIF-ELSE Conditions
    3. ELSIF
    4. BOOLEAN Values and Standard SQL
    5. The CASE Statement
    6. CASE Expressions
  4. Exceptions
    1. Introduction to Exceptions
    2. Predefined Exceptions
    3. The EXCEPTION Part of the Block
    4. User-defined Exceptions
    5. User-defined Exceptions in Subprograms
    6. Re-raising Exceptions
    7. Naming Unnamed Predefined Exceptions
    8. WHILE Loops
    9. When to Use Exceptions
  5. Cursors
    1. Implicit Cursors
    2. Explicit Cursors
    3. %ROWTYPE
    4. Explicit Cursor Use Case
    5. Cursor FOR LOOP
    6. Cursor Parameters
  6. Packages
    1. Package Basics
    2. The Package Specification
    3. The Package Body
    4. Building an Employee Package
    5. Overloading Subprograms
    6. Auditing
    7. Validation Procedures
    8. Package Cursors
    9. Benefits of Packages
  7. Triggers
    1. What are triggers?
    2. Trigger Parts
    3. Validation Triggers
    4. The WHEN Clause
    5. Audit Triggers
    6. Statement-level Triggers
    7. Compound Triggers
    8. Trigger Warning
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Prerequisite Courses

Courses that can help you meet these prerequisites:

Training for Yourself

$2,875.00 or 5 vouchers

Upcoming Live Online Classes

  • See More Classes

Please select a class.

Training for your Team

Length: 5 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

What people say about our training

Effective and concise. Real world experience in the subject matter made for relevant examples that I will be able to apply in the office.
David Kawalauskas
FortisAlberta Inc
The class was very helpful in learning the basics of Microsoft Project 2010. I will now be able to start a Project, add tasks, add resources and update and edit the information for the projects I am responsible for.
Charles Kutach
Halliburton
The classes provided have been great. I can surely say they've increased my knowledge in regards to Oracle and PL/SQL.
Robert Kline
Defense Finance & Accounting Services (DFAS)
Knew nothing in beginning, now feel much more comfortable with HTML.
Paul Gibbons
GateHouse Media

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

64,439

Students who have taken Instructor-led Training

11,983

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

10.00

Students rated our Oracle PL/SQL Training trainers 10.00 out of 10 based on 1 reviews

Contact Us or call 1-877-932-8228