Introduction to Oracle PL/SQL Training on Oracle 11g/10g

Date		Location
5th Oct, 2009		Webucator Webinar		[Register]
30th Nov, 2009		Webucator Webinar		[Register]

Introduction to Oracle PL/SQL Training Class Overview

The primary objective of this Oracle training class 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 Training Class 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 Training Class 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 Training Class 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 Training Class Materials

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

Class Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away:

• Click here for technical requirements and setup instructions

Webucator - Webucator delivers customized onsite, instructor-led online and at-your-own-paced technical training throughout the United States and worldwide. Webucator has trained 40 percent of the Fortune 100. Onsite Class Delivery: Our onsite classes are delivered for private groups at your offices or a location of your choice. These classes can also be delivered through a web conference for...