Oracle Database 11g - PL/SQL Fundamentals

Course Overview

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

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 Prerequisites

Course Outline

1 - Volume 1

  • Choosing a SQL & PL/SQL Interface
  • Language Features
  • Declare Clause
  • Begin Clause
  • Exception Clause
  • Explicit Cursors
  • Advanced Programming: Declared Subprograms

2 - Volume 2

  • Introducing Database Program Units
  • Creating Stored Procedures & Functions
  • Maintaining Stored Procedures & Functions
  • Creating and Maintaining Packages
  • Advanced Cursor Techniques
  • Using System-Supplied Packages
  • Relating Database Triggers
  • Maintaining Database Triggers
  • Implementing System Even Triggers