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 knowledge of SQL and the ability to develop Oracle procedures, functions, and database triggers using PL/SQL. The course utilizes a variety of current tools.  Students will have the opportunity to learn more about SQL Developer, TOAD, as well as the Oracle tools like SQL*Plus.

Course Objectives

The attendees have the opportunity to construct various PL/SQL routines to solve simple and complex business questions. Instructor will cover topics including how to code PL/SQL, accessing data in a variety of methods, error handling, and will touch on debugging PL/SQL.

Students will learn how to use TOAD **OR** Oracle’s free Project Raptor tool to assist with their day-to-day development needs.  Attendees will be able to use TOAD or SQL Developer to do the lab exercises and learn how to use the Procedure Editor and debug their PL/SQL routines.  Students will also see how to enter their SQL using the TOAD or SQL Developer interface, easily create spreadsheets from data, display data, see various application relationships, and more.

Attendees Receive the Following:

• Study guide with presentations and relevant white papers
• Book: Oracle9i Development by Example
• 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, Project Raptor, and TOAD
• TOAD or Project Raptor Tips and Techniques

Topics Covered in the Course Include:

• Oracle Architecture
• Introduction to PL/SQL
• Syntax and language structure
• PL/SQL Topics
• Cursor management
• Exception handling
• Procedures/Functions/Triggers
• Packages
• Optional TOAD or Project Raptor Tips and Techniques for IT

Lectures and topics are enhanced with live illustrations and hands-on exercises.

Course Agenda

Day 1: Introduction to Oracle PL/SQL

• Oracle RDBMS Architecture overview
• Introduction to TOAD/SQL*Plus
• Introduction to PL/SQL
  • Basic Syntax
  • Variables
  • Cursors
    • Implicit & Explicit
    • Cursor Loops
• PL/SQL Control Structures

Day 2: Introduction to Oracle PL/SQL

• PL/SQL Exception Handling
• Procedures/Functions/Database Triggers
• Passing Parameters
• Packages
• PL/SQL 10g New Features
• Array Processing

Optional Day 3: TOAD Tips and Techniques for IT

• SQL Editor Tips and Techniques (viewing/changing Data, creating reports, extracting Data, working with SQL, discovering all of the help available, creating SQL with minimal key strokes using templates & auto substitution)
• Schema Browser Tips and Techniques (viewing/changing Data, creating reports, extracting Data, working with scripts, working with spreadsheets, etc)
• Procedure Editor Usage (develop, execute, and debug PL/SQL routines, work with templates to create procedures/functions/triggers)
• SQL Modeler/ER Diagrammer/Master Detail Browser (viewing application data relationships/viewing related data)
• Miscellaneous topics include TOAD configuration and other topics not covered in the other areas such as using the TOAD explain plan and using TOAD with the Oracle Trace Facility (a great interface to TKProf).

Prerequisites

Delivery

For more information about scheduling one of these courses, please  call us at: 1 (800) 887-4513, or e-mail us at: