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 SQL & PL/SQLPLUS Express Introduction

Vendor# OR111

GK# 7378

Course Overview

In this course, you will receive an introduction to Oracle's relational database and a hands-on introduction in how to add, update, extract and organize information from the database. You will cover how to format reports and export data using ODBC. You will also work with Oracle's Structured Query Language (SQL), SQL*Plus, and Procedural Language for SQL (PL/SQL). Debugging, error reporting procedures, and how to define, execute, and store procedures for reuse will also be covered in this course.

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

    $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

  • Extract and organize information from the database
  • Format reports using SQL*Plus commands
  • Insert, update, and delete information in database tables
  • Work with the PL/SQL environment and program structure
  • Use error report functions and debugging procedures
  • Use logical comparisons
  • Define and execute procedures and functions
  • Test procedures and functions
  • Create package specifications and package bodies
  • Create DML triggers
  • Store PL/SQL program units

Who Needs To Attend

Anyone who needs to extract and organize information from an Oracle database, including formatting reports, adding, updating, and deleting data, and exporting data to ODBC files, including:

  • Application designers
  • Developers
  • Database administrators
  • End users

Course Outline

Download Course Outline