1-877-WEBUCATE
(1-877-932-8228)
info@webucator.com
 
Microsoft Training
Java Training
XML Training
Database & SQL Training
PHP, Perl, ASP, Groovy, Grails, Ruby on Rails Training
HTML, JavaScript, Ajax & CSS Training
Adobe CS3 Training
◊ PUBLIC ORACLE TRAINING

How about taking a class directly from your home or office with a live instructor?
When you register for one of our instructor-led online Oracle classes, we send you a computer headset, the courseware for class, and some other goodies. At the time of class, you simply put your headset on and log in to our web conferencing software. You can hear everything the instructor says, see the complete presentation, and ask questions at any time. Classes are small, generally 2-6 students, full of hands-on exercises, and are never cancelled due to low enrollment.

To have someone contact you about our instructor-led online classes, please fill out the form below. We will also email you a class schedule and pricing.

* (Required)
* (Required)
* (Required)
* (Required)
* (Required)
(The number of people requiring training)
* (Required)
(For Federal Government Pricing)

Introduction to Oracle PL/SQL Training on Oracle 10g (4 days)

Classes for individuals are delivered via the Web by a Webucator instructor over a live web conference. For more information on how these classes are delivered click here or call us toll free at 877-932-8228.

Click here for our private onsite Oracle classes

Start Date Price Register
June 2, 2008
(Start time: 10:00 AM ET)		 $1,695.00
August 4, 2008
(Start time: 10:00 AM ET)		 $1,695.00
October 6, 2008
(Start time: 10:00 AM ET)		 $1,695.00
December 1, 2008
(Start time: 10:00 AM ET)		 $1,695.00
You may also register by calling 1-877-932-8228.

Introduction to Oracle PL/SQL Overview

The primary objective of this course is to provide an introduction to the PL/SQL database programming language, based upon the latest features available in Oracle 10g.

Introduction to Oracle PL/SQL Course Goals

  • Understand the environment and context in which PL/SQL operates.
  • Consider the advantages and benefits of PL/SQL within a database environment.
  • Learn to declare program variables and complex data types.
  • Learn to develop logic within PL/SQL program blocks.
  • Learn to fetch data from the database into program variables.
  • Learn to return program output to users.
  • Learn to handle program exceptions.
  • Learn to use explicit and implicit database cursors.
  • Learn to use the advanced features of nested blocks and subprograms.
  • Learn to take advantage of new features such as regular expression support and the handling of string literals within program code.

Introduction to Oracle PL/SQL Course Prerequisites

Experience in the following areas is required:

  • Oracle SQL as taught in our Introduction to Oracle SQL and Advanced Oracle SQL classes.

Introduction to Oracle PL/SQL Course Outline

  1. Language Features
    1. Understanding Pl/SQL
    2. Structure Of A Pl/SQL Program Block
    3. Pl/SQL From Interactive Tools
    4. Generating Output Within SQL*Plus
  2. Declare Clause
    1. About The Declare Clause
    2. Declare Simple Types
    3. Complex Types
  3. Begin Clause
    1. About The Begin Clause
    2. Performing Data Manipulation
    3. Logic Control & Branching
  4. Exception Clause
    1. About The Exception Clause
    2. Isolating The Specific Exception
  5. Explicit Cursors
    1. About Explicit Cursors
    2. Advanced Cursor Techniques
  6. Advanced Programming: Nested Blocks
    1. About The Advanced Features
    2. Using Nested Blocks
  7. Advanced Programming: Declared Subprograms

Introduction to Oracle PL/SQL Course Materials

Each student will receive a comprehensive set of materials, including course notes and all the programming examples.

Introduction to Oracle PL/SQL Technical Requirements

  1. Oracle 10g
    • Download - - Oracle Database 10g Express Edition
      1. The file you want to download is Oracle Database 10g Express Edition (Western European) - OracleXE.exe.
      2. You will need to register for a free account.
      3. Run through the Installer accepting all the defaults. Make sure to write down your password.
      4. Follow steps 1-3 of the Getting Started Guide available at the Oracle Web site
  2. Editor Options
    • (Recommended) Toad for Oracle
      • Download
      • Run through the Installer accepting all the defaults.
    • SQL*Plus Instant Client

Class Files for Introduction to Oracle PL/SQL

The class files for this course will be sent by email before the class.

home - onsite classes - instructor-led online courses - self-paced online courses - why webucator - partners - contact - sitemap
© 2007 Webucator. All rights reserved. info@webucator.com | Toll Free: 877-WEBUCATE (877-932-8228) | From Outside the USA: 315-446-0560 | Fax: 315-410-5320
Phoenix, AZ | Santa Clara, CA | Santa Clara, CA | Los Angeles, CA | Sacramento, CA | Washington, DC | Atlanta, GA | Chicago, IL | Indianapolis, IN | Muncie, IN
New Orleans, LA Boston, MA | Cambridge, MA | Charlestown, MA | Framingham, MA | Ipswich, MA | Lincoln, MA | Wellesley, MA | Worcester, MA | Bangor, ME | Detroit, MI
Raleigh, NC Winston-Salem, NC | Lincoln, NE | East Hanover, NJ | Eatontown, NJ | Madison, NJ | Parsippany, NJ | Trenton, NJ | Albany, NY | Buffalo, NY | Rochester, NY
New York City, NY | Syracuse, NY | West Babylon, NY | Dayton, OH | Bethlehem, PA | Philadelphia, PA | Pittsburgh, PA | Pittsburgh, PA | State College, PA
Middletown, RI | Rapid City, SD | Austin, TX | Dallas, TX | Houston, TX | Arlington, VA | McLean, VA | Seattle, WA | Toronto, Canada | Ottawa, Canada | Calgary, CA