Oracle Database 11g: PL/SQL Fundamentals - Part 2

**Please note that CompuWorks will only accept students registering through a company or organization. Please click here for more information**
Download the outline in PDF format

 

Description:     The objective of this course is to equip students to develop database server-side PL/SQL program units within an Oracle database.

 

Days:                3

 

Prerequisites:   ORACLE DATABASE 11G: SQL FUNDAMENTALS and

                         ORACLE DATABASE 11G: PL/SQL FUNDAMENTALS I

Audience:         Target audience for this course is all Oracle professionals.

                         Among the specific groups for whom this course will be

                         helpful are:

     • Application designers and developers

     • Database administrators

 

INTRODUCING DATABASE PROGRAM UNITS

·         ABOUT DATABASE PROGRAM UNITS

·         TYPES OF PL/SQL PROGRAM UNITS

·         TYPES OF STORED PROGRAM UNITS

·         ADVANTAGES OF USING STORED PROGRAM UNITS

CREATING STORED PROCEDURES & FUNCTIONS

·         ABOUT STORED PROCEDURES & FUNCTIONS

·         CREATING PROCEDURES & FUNCTIONS

·         EXECUTING PROCEDURES & FUNCTIONS

MAINTAINING STORED PROCEDURES & FUNCTIONS

·         RECOMPILING & DROPPING PROGRAMS

·         DATA DICTIONARY STORAGE

·         MANAGING DEPENDENCIES

CREATING & MAINTAINING PACKAGES

·         ABOUT PACKAGES

·         CREATING PACKAGES

·         ADVANCED PROGRAMMING TECHNIQUES

·         MAINTAINING PACKAGES

ADVANCED CURSOR TECHNIQUES      

·         USING CURSOR VARIABLES

·         USING CURSOR EXPRESSIONS

USING SYSTEM-SUPPLIED PACKAGES

·         DBMS_OUTPUT()

·         UTL_FILE()

CREATING DATABASE TRIGGERS

·         ABOUT DATABASE TRIGGERS

·         STATEMENT-LEVEL TRIGGERS

·         ROW-LEVEL TRIGGERS

·         EXAMPLES OF TRIGGERS

·         INSTEAD OF TRIGGERS

·         EMPLOYING TRIGGERS WITHIN AN APPLICATION

MAINTAINING DATABASE TRIGGERS

·         CALL SYNTAX

·         TRIGGER MAINTENANCE TASKS

·         SHOW ERRORS TRIGGER

·         DROP TRIGGER

·         ALTER TRIGGER

·         HANDLING MULTIPLE TRIGGERS FOR A TABLE

·         HANDLING MUTATING TABLE ISSUES

IMPLEMENTING SYSTEM EVENT TRIGGERS

·         WHAT ARE SYSTEM EVENT TRIGGERS?

·         DEFINING THE SCOPE

·         AVAILABLE SYSTEM EVENTS

·         SYSTEM EVENT ATTRIBUTES

Aug 23, 2010 - Aug 25, 2010
Sep 15, 2010 - Sep 17, 2010
Oct 20, 2010 - Oct 22, 2010
Nov 03, 2010 - Nov 05, 2010



Price: $1,495
Group Rate: $9,995
(Up to 14)