Oracle Database 11g – PL/SQL Fundamentals

Overview

Course Description

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.

Audience Profile

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

Prerequisites

Oracle Database 11g – SQL Fundamentals

Learning Objectives

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.

Course Outline

Course Outline

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

Module 2: Volume 2
Lessons
• 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

Register for Course

Tuition
Available Registrations: Unlimited
The Tuition ticket is sold out. You can try another ticket or another date.

Cost

$2,650.00

Course Code

FRCORA-4

Course Duration

5

Instructions Method

Instructor Led
Category
REGISTER