Introduction to Oracle PL/SQL Programming - 2 Days
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 the ability to develop Oracle procedures, functions, and database triggers using PL/SQL.
Attendees have the opportunity to construct various PL/SQL routines to solve simple and complex business questions. The instructor will cover how to code PL/SQL, access data in a variety of methods, error handling, and will touch on debugging PL/SQL.
The optional 3rd day involves training the attendees in 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.
The course utilizes a variety of current tools. Students will have the opportunity to learn more about SQL Developer, TOAD, as well as Oracle tools like SQL*Plus.
Workshop Prerequisites:
A working knowledge of SQL is required.
Topics covered:
- 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 real-world examples and hands-on exercises
Attendees Receive:
- 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
Course Outline:
|
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!!!)
|
Not finding the course or date that you're looking for? Let us know!
- Item #: plsql001
