Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


Oracle 11g PL/SQL Intermediate

Vendor# OR125

GK# 8404

Course Overview

In this course, you will receive hands-on instruction in the intermediate and advanced features of Oracle11g PL/SQL procedural language for SQL. You will learn how to control data sharing and locking, debug and use error reporting procedures use Oracle supplied packages, and develop database triggers, stored procedures, and functions for future reuse.

Delivery Format Options

  • Virtual Classroom Live

    Virtual Classroom Live

    Experience expert-led online training from the convenience of your home, office or anywhere with an Internet connection.


    $2565 CAD

    3 day

  • Private Group Training

    Private Group Training

    Train your entire team in a private, coordinated professional development session at the location of your choice.

    Receive private training for teams online and in-person.

Request a date or location for this course.

What You'll Learn

  • PL/SQL Environment
  • PL/SQL Program Structure
  • Native Compilation
  • Update, Insert, and Delete Statements
  • Error Functions/Debugging
  • Defining, Executing, and Testing Functions and Procedures
  • Creating Package Specifications and Bodies
  • Creating Triggers of All Types
  • Using Oracle-Supplied Packages
  • Advanced PL/SQL Features


  • Oracle 11g SQL Basics & SQL*PLUS or equivalent experience
  • Oracle 11g PL/SQL Introduction or equivalent experience

Who Needs To Attend

Application developers and database administrators who need a comprehensive understanding of Oracle 10g PL/SQL language

Course Outline

Download Course Outline