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

Cart () Loading...

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

    $

Oracle 12c PL/SQL Introduction

Vendor# OR120

GK# 7379

Course Overview

In this course, you will receive a hands-on introduction to the Oracle12c PL/SQL procedural language for SQL. You will cover how to insert, update, and delete data, control data sharing and locking, debug and use error report procedures. You will also learn how to develop database triggers and store 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.

    From

    $2160 CAD

    2 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 and program structure
  • Update, insert, and delete statements
  • Error report functions
  • Debugging procedures
  • Logical comparisons
  • Define, store and execute procedures and functions
  • Create package specifications and package bodies
  • Create composite datatypes
  • Work with implicit and explicit cursors

Prerequisites

Who Needs To Attend

Anyone who needs to extract and organize information from an Oracle database, including:

  • Application designers
  • Developers
  • Database administrators
  • End users