Training Courses and On-Line Classes Preferred By IT Pros
Toll Free:  800.631.0410

Advanced PL/SQL Tips and Techniques

Course:  OPLSQL2
Duration:  3 Days
Level:  II
Course Summary

Give your IT staff the knowledge of using advanced features of Oracle's procedural language: PL/SQL.

The focus of this course is to advance attendee knowledge of the PL/SQL programming language. This is an excellent course for those people that need a better knowledge of the PL/SQL language. This course covers all the latest features of PL/SQL using databases Oracle9i, Oracle10g, and Oracle11g.

The attendees have the opportunity to 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.

The course utilizes a variety of current tools. Students will have the opportunity to learn more about TOAD, SQL Developer, as well as the Oracle tools like SQL*Plus.

« Hide The Details
Topics Covered In This Course

PL/SQL Overview/Review

PL/SQL Compiler

Definer/Invoker Rights

Executing and Exception handling

Autonomous Transactions

Package Options

Overloading

Database Triggers

  • DML, Instead of, ServerError, Startup, Shutdown, Logon

Working with Cursors

  • User Defined Datatypes
  • Cursor Sharing
  • Cursor Variables
  • Strong vs Weak Cursors

Working with Collections

  • Associate Arrays
  • Nested Tables
  • Varrays
  • Bulk Collect/Forall Bulk Binding
  • Using Collections for Reference Table

Oracle Provided Packages

  • DBMS_Alert
  • DBMS_Job
  • DBMS_Output
  • DBMS_Scheduler
  • UTL_File
  • UTL_Mail
  • Other Provided Packages

DBMS_SQL and Dynamic SQL

Working with Large Objects

Debugging PL/SQL Routines

PL/SQL Profile

Oracle Trace

Recommended Prerequisites

A working knowledge of SQL and PL/SQL is required.

« Hide The Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com