Taking too long? Close loading screen.

Oracle Database 11g R2: PL/SQL Fundamentals I and II

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 with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming. This course equips students to develop database server-side PL/SQL program units within an Oracle database.

Who Should Attend

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
• Business users and non-technical senior end users

Course Outlines

Volume I:
CHOOSING A SQL & PL/SQL INTERFACE
LANGUAGE FEATURES
DECLARE CLAUSE
BEGIN CLAUSE
EXCEPTION CLAUSE
EXPLICIT CURSORS
ADVANCED PROGRAMMING: DECLARED SUBPROGRAMS

Volume II:
INTRODUCING DATABASE PROGRAM UNITS
CREATING STORED PROCEDURES & FUNCTIONS
MAINTAINING STORED PROCEDURES & FUNCTIONS
CREATING & MAINTAINING PACKAGES
ADVANCED CURSOR TECHNIQUES
USING SYSTEM-SUPPLIED PACKAGES
CREATING DATABASE TRIGGERS
MAINTAINING DATABASE TRIGGERS
IMPLEMENTING SYSTEM EVENT TRIGGERS