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:


Oracle12c PL/SQL Foundations

Vendor# OR130

GK# 7489

Course Overview

In this course, you will learn about the Oracle 12c PL/SQL programming language. You will be able to control data sharing and locking, develop an understanding of multi-user and concurrent transactions, and develop triggers, procedures, functions, and packages.

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.


    $3650 CAD

    5 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

  • The PL/SQL environment
  • PL/SQL program structure
  • Native compilation
  • Update, insert, and delete statements
  • Variable scope rules
  • Error functions and debugging
  • Logical comparisons
  • Defining, executing, and testing both procedures and functions
  • Creating package specifications and bodies
  • Creating triggers
  • Using Oracle supplied packages
  • Understanding advanced PL/SQL features


Oracle 12c Foundations: SQL and SQL*PLUS (OR103) or equivalent experience

Who Needs To Attend

Application Developers and Database Administrators who need a comprehensive understanding of Oracle 12c PL/SQL language

Course Outline

Download Course Outline