Advanced PL/SQL Programming

Course Code IP1470

Contents

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Screenshot

Description

The Advanced PL/SQL Programming WBT is the third course in this curriculum. This course will enable users to create functions, packages, database objects, collections, and triggers. Additionally, it will enable users to create transactions, apply locks, and use dynamic SQL.

Audience

This course is designed for Application Developers who want to create database components using Oracle 8.

Prerequisites

Knowledge of database concepts.

Objective

Upon completion of this course, the student will be able to:

Create PL/SQL packages Manage PL/SQL packages Identify various Oracle server-supplied packages Use stored functions in PL/SQL packages Manage database objects Manipulate database objects Manipulate PL/SQL variables using collections Implement varrays Integrate database using PL/SQL triggers Apply database triggers Manipulate data using cursors Declare a cursor variable Integrate transactions with database Restrict database access by applying locks Control user access Define dynamic SQL Use DBMS_SQL to execute non-query DDL and DML statements Use the DBMS_SQL package to execute queries Identify the different types of exceptions Handle user-defined exceptions List PL/SQL debugging techniques Minimize the occurrence of bugs using special programming methodologies

Topics Include

Working with Oracle8 Packages

• Introducing PL/SQL Packages
• Applying Advanced Package Concepts
• Quiz

Working with Objects and Collections

• Configuring Objects and Methods
• Grouping Objects using Collections
• Working with Database Triggers and Cursors
• Developing Database Triggers
• Manipulating Data with Cursors
• Quiz

Maintaining Data Concurrency and Consistency

• Adding Transactions and Locks
• Quiz

Using Dynamic SQL

• Removing Errors and Bugs from PL/SQL Programs
• Handling Exceptions
• Debugging PL/SQL
• Quiz

Duration

6 hrs

Minimum Requirements

Netscape or Internet Explorer (versions 4.0 or higher). Browsers should be capable of accepting cookies; SVGA Hi-color mode 800x600 resolution display. Macromedia Shockwave 6.02 or higher.

Media

Web Based Training