Oracle Database 11g R2: PL/SQL Fundamentals
Duration - 5 days
Description
This Oracle 11g training textbook will 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 textbook equips students to develop database server-side PL/SQL program units within an Oracle database.
Certification Examination
This course considers subjects useful for certification as an Oracle Certified Master (OCM), the most advanced and prestigious Oracle database certification level.
Prerequisites
The following is a mandatory prerequisite for this course:
• ORACLE DATABASE 11G R2: SQL FUNDAMENTALS
Content
CHOOSING A SQL & PL/SQL INTERFACE
LANGUAGE FEATURESDECLARE CLAUSE
BEGIN CLAUSE
EXCEPTION CLAUSE
EXPLICIT CURSORS
ADVANCED PROGRAMMING: DECLARED SUBPROGRAMS
INTRODUCING DATABASE PROGRAM UNITS
CREATING STORED PROCEDURES & FUNCTIONS
MAINTAINING STORED PROCEDURES & FUNCTIONS
CREATING & MAINTAINING PACKAGES
ADVANCED CURSOR TECHNIQUES
USING SYSTEM - SUPPLIED PACKAGES
REATING DATABASE TRIGGERS
MAINTAINING DATABASE TRIGGERS
IMPLEMENTING SYSTEM EVENT TRIGGERS
Next Course
After some weeks or months of PL/SQL programming experience, it is strongly recommended that the following course be taken next:
• ORACLE DATABASE 11G R2: NEW & ADVANCED FEATURES FOR DEVELOPERS
