Oracle 12c PL/SQL training and certification in washington DC
George Mason University, Volgenau School of Engineering

TAIT 0428: Program with PL/SQL


This is an outstanding course and “yes”, I would recommend that DBAs and other Oracle users take this course to improve their skills.- Student

I have not worked as a DBA before, so the course introduced me to this field. The instructor was tactful enough to let me catch up in a way that did not draw the class behind. - Student

Overview

PL/SQL is one of the four highly demanded computer industry courses offered in the Oracle 12c Database Administration certificate program. This hands-on course will give you an introduction to PL/SQL, which is Oracle's proprietary programming language.

Audience and Prerequisites

This course is designed for individuals who have knowledge of Oracle Structured Query Language. (SQL). Contact us at 703-993-1551 for more information on this course or Oracle career paths.

Course Outline Detail

PL/SQL

What is PL/SQL

  • PL/SQL Environment
  • Benefits of PL/SQL
  • Stored Procedures, Functions, and Triggers
  • Stored Procedures and SQL Scripts

Structure of a PL/SQL Block

  • Header Section
  • Declaration Section
  • Execution Section

Creating a PL/SQL Procedure
Creating a PL/SQL Function
PL/SQL Variables and Constants

  • Declaring PL/SQL Variables
  • Declaring PL/SQL Constants
  • Assigning Values to Variables
  • Using Variables

Control Structures in PL/SQL

  • IF Statement
  • Loops
  • Cursors
  • Nested Loops

Error Handling

  • Exceptions
  • System Defined Exceptions
  • Programmer Defined Exceptions

Other PL/SQL Tools

  • PL/SQL Packages
  • Triggers
  • Views used with PL/SQL
Registration
Click here to download the registration form (fax or mail)

Register online*

*Full payment by Visa or Mastercard only required at the time of online registration.

Schedule

August 7, 2017 - August 9, 2017
Monday and Wednesday
Time: 6:00 PM - 10:00 PM
Schedule Details

Location: Arlington 
Section: A07

Tuition
$800
CEUs
0.8 CEUs
8 Hours
Onsite Opportunity

Enhance your organization's competitive edge!

George Mason University's TechAdvance Program can tailor programs to meet your organization's needs. Companies or agencies interested in bringing this program on site should contact TechAdvance at 703-993-1551.

Contact Info.
Address:

  George Mason University
TechAdvance
Volgenau School of Engineering
  3351 Fairfax Drive, Suite 448
  Arlington, VA 22201

Telephone: 703-993-1551
Email: advance@gmu.edu
Volgenau School of Engineering George Mason University