Advanced Oracle PL/SQL Training on Oracle 11g/10g

Date		Location
5th Oct, 2009		Webucator Webinar		[Register]
7th Dec, 2009		Webucator Webinar		[Register]

Advanced Oracle PL/SQL Training Class Overview

In this Advanced Oracle PL/SQL training class, students learn to develop database server-side PL/SQL program units within an Oracle database.

Advanced Oracle PL/SQL Training Class Goals

• Understanding application partitioning within a client/server or multi-tiered web-based architecture.
• Understanding the basic form and structure of program units stored within the database.
• Building and maintaining database stored program units.
• Encapsulating stored units within packages and taking advantage of accompanying advanced programming techniques such as cursor variables and cursor expressions.
• Handling intricate theoretical challenges, such as mutating tables.
• Building and maintaining DML-event and system-event database triggers.
• Discuss the storage and execution model for database programs and how one can write efficient programs to maximize performance.
• Using system-supplied packages to extend the power of your SQL statements and PL/SQL applications.

Advanced Oracle PL/SQL Training Class Outline

1. Introducing Database Program Units
   1. Types Of Pl/SQL Program Units
   2. Types Of Stored Program Units
   3. Advantages Of Using Stored Program Units
   4. Development Tools
2. Creating Stored Procedures & Functions
   1. Creating Procedures & Functions
   2. Executing Procedures & Functions
   3. Handling Compilation Errors
3. Maintaining Stored Procedures & Functions
   1. About Application Maintenance
   2. Recompiling & Dropping Programs
   3. Data Dictionary Storage
   4. Managing Dependencies
4. Creating & Maintaining Packages
   1. About Packages
   2. Creating Packages
   3. Advanced Programming Techniques
   4. Maintaining Packages
5. Advanced Cursor Techniques
   1. Using Cursor Variables
6. Using System-Supplied Packages
   1. Dbms_Output()
   2. Utl_File()
7. Creating Database Triggers
   1. About Database Triggers
   2. Statement-Level Triggers
   3. Row-Level Triggers
   4. Examples Of Triggers
   5. Instead Of Triggers
   6. Employing Triggers With An Application
8. Maintaining Database Triggers
   1. About Trigger Maintenance
   2. Call Syntax
   3. Multiple Triggers Per Event
   4. Trigger Maintenance Tasks
   5. Handling Mutating Table Issues
9. Implementing System Event Triggers
   1. What Are System Event Triggers?
   2. Defining The Scope
   3. Available System Events
   4. System Event Attributes

Advanced Oracle PL/SQL Training Class Prerequisites

Experience in the following areas is required:

• Experience with Oracle SQL as taught in our Introduction to Oracle SQL and Advanced Oracle SQL classes.
• Experience with Oracle PL/SQL as taught in our Introduction to Oracle PL/ SQL course

Advanced 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...