Training

How We're Different

Course Summaries

Course Logistics

Client-site Classes

Virtual Classes

Request Information

Course Surveys

Overview

Give your IT staff the knowledge of using Oracle’s procedural language: PL/SQL. The focus of this course is to provide students with a working but basic knowledge of SQL and the PL/SQL languages. The course utilizes a variety of current tools.  Students will have the opportunity to learn more about TOAD and SQL Developer, as well as the Oracle tools like SQL*Plus.

Course Objectives

The attendees will learn how to find the poorly-performing components of PL/SQL routines, use Oracle’s newer DEBUG routines to find problems in PL/SQL logic and how to use the latest features of the PL/SQL language such as the new optimizing compiler and collections.

Attendees Receive the Following:

• Study guide with presentations and relevant white papers
• Diskette full of example SQL and SQL*Plus scripts
• Opportunity to ask the tough Oracle questions
• A hands-on opportunity to learn more about Oracle, TOAD, and SQL Developer

Topics Covered in the Course Include:

• Oracle Architecture
• Introduction to PL/SQL
• Syntax and language structure review
• PL/SQL Topics
• Package Usage (both User Defined and Oracle Defined Packages)
• Profiling/Debugging/Compiling
• Cursor Sharing/Cursor Variables
• Collections
• Dynamic SQL
• Autonomous Transactions
• PL/SQL Coding Tips
• Debugging PL/SQL
• Working with Oracle Trace

Course Agenda

Day 1: Advanced Oracle PL/SQL

• PL/SQL Overview/Review
  • PL/SQL Compiler
  • PL/SQL Structure/Procedures/Packages
  • Executing and Exception handling
  • Autonomous Transactions
• Working with User Defined Packages
  • Benefits
  • Overloading
• Working with Oracle Supplied Packages
  • DBMS_OUTPUT
  • UTL_FILE
  • DBMS_ALERT
  • DBMS_PIPE
  • DBMS_JOB

Day 2: Advanced Oracle PL/SQL

• Working with Triggers
• Working with Oracle Objects
• Object Types
• Object Tables
• PL/SQL Collections
• Package Cursor/Variable Sharing
• Dynamic SQL

Day 3: Advanced Oracle PL/SQL

• Working with Large Objects
• PL/SQL Coding Tips
• Debugging PL/SQL Routines
• PL/SQL Profile
• Oracle Trace
• Definer/Invoker Rights
• Oracle10g Format_Error_Backtrace
• Oracle10g Optimizing Compiler

Prerequisites

Delivery