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

GK# 7379 Vendor# OR120

Course Overview

TOP

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.

What You'll Learn

TOP
  • 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

Outline

TOP
Viewing outline for:

Virtual Classroom Live Outline

1. PL/SQL Basics

  • SQL and PL/SQL
  • PL/SQL anonymous block structure and datatypes
  • Variable declarations and naming conventions
  • Object naming rules
  • Executable statements
  • Operators in PL/SQL
  • Conditional control / repetition control
  • LOOP statements - Basic LOOP, WHILE, FOR
  • CASE Expressions and Statements
  • Nested blocks
  • Labels and block identification
  • Basic coding standards
  • SQL*PLUS development environment
  • Using SQL developer
  • Bind variables / substitution variables
  • Datatypes: scalar, collection, record, reference
  • Commenting code

2. Working with Database Data

  • SELECT statements in PL/SQL
  • Selecting single and multiple rows
  • Referencing other variables or a database column's datatypes with %TYPE
  • Using %ROWTYPE
  • Using sequences in PL/SQL
  • Modifying database data (DML)
  • Transaction control commands
  • Selecting data into PL/SQL variables
  • Explicit cursors / Cursor attributes
  • Transaction control commands
  • Referencing other structures datatypes
  • Using the cursor FOR LOOP
  • FOR UPDATE / WHERE CURRENT OF

3. Exception Handling

  • Writing an exception handler section
  • Handling predefined and user-defined exceptions
  • Controlling exception processing
  • Preventing unhandled exceptions
  • RAISE_APPLICATION_ERROR
  • Using SQLCODE and SQLERRM

4. Stored PL/SQL Objects

  • Introduction to procedures and functions stored in the database
  • Creating stored PL/SQL objects
  • Passing values with parameters
  • Creating procedures, functions, packages, and package bodies in SQL*Plus and SQL Developer
  • Introduction to database triggers
  • Viewing and recompiling stored code

Labs

TOP
Viewing labs for:

Virtual Classroom Live Labs

  • Lab 1: Using PL/SQL to Create an Anonymous Block
  • Lab 2: PL/SQL Basics
  • Lab 3: Using SQL Developer
  • Lab 4: Selecting and Updating Database Data
  • Lab 5: Using Explicit Cursors
  • Lab 6: Handling Exceptions
  • Lab 7: Creating a Procedure
  • Lab 8: Creating a Function
  • Lab 9: Creating a Package from Procedures and Functions
  • Lab 10: Creating a Database Trigger

Prerequisites

TOP

Who Should Attend

TOP

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

  • Application designers
  • Developers
  • Database administrators
  • End users
Course Delivery

This course is available in the following formats:

Virtual Classroom Live

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

Duration: 2 day

Request this course in a different delivery format.
Enroll