- GS-35F-0556S
- Toll Free 877.932.8228
Loved the online environment and teacher! ...
More Testimonials »
Introduction to Oracle PL/SQL Training on Oracle 11g
Delivery Options
- Live eLearning (4 days): $2,100.00 (Register)
- Customized Onsite Training (3 days): Request a Proposal
| Class Date and Time |
Price
|
Register |
|---|---|---|
| May 10 - 13, 2010 10:00 AM - 5:00 PM ET | $2,100.00 or 4 vouchers | Register |
| Jun 7 - 10, 2010 10:00 AM - 5:00 PM ET | $2,100.00 or 4 vouchers | Register |
Class Description
Class Overview
The primary objective of this Oracle training class is to provide an introduction to the PL/SQL database programming language, based upon the latest features available in Oracle 10g.
Class Goals
- Understand the environment and context in which PL/SQL operates.
- Consider the advantages and benefits of PL/SQL within a database environment.
- Learn to declare program variables and complex data types.
- Learn to develop logic within PL/SQL program blocks.
- Learn to fetch data from the database into program variables.
- Learn to return program output to users.
- Learn to handle program exceptions.
- Learn to use explicit and implicit database cursors.
- Learn to use the advanced features of nested blocks and subprograms.
- Learn to take advantage of new features such as regular expression support and the handling of string literals within program code.
Class Outline
- Language Features
- Understanding Pl/SQL
- Structure Of A Pl/SQL Program Block
- Pl/SQL From Interactive Tools
- Generating Output Within SQL*Plus
- Declare Clause
- About The Declare Clause
- Declare Simple Types
- Complex Types
- Begin Clause
- About The Begin Clause
- Performing Data Manipulation
- Logic Control & Branching
- Exception Clause
- About The Exception Clause
- Isolating The Specific Exception
- Explicit Cursors
- About Explicit Cursors
- Advanced Cursor Techniques
- Advanced Programming: Nested Blocks
- About The Advanced Features
- Using Nested Blocks
- Advanced Programming: Declared Subprograms
Class Materials
All students receive a course manual or book and all the class examples.
Students in private onsite classes will also receive:
Class Prerequisites
Experience in the following areas is required:
- Oracle SQL as taught in our Introduction to Oracle SQL and Advanced Oracle SQL classes.
Technical Requirements
Our computer technical requirements and setup process is easy, with support just a click away.
Live eLearning
Like a class you would go to, but you don't have to go anywhere. More...
Customized Onsite Training
The trainer comes to you and delivers a class customized for your team. More...
Self-Paced eLearning
Our least expensive option. You proceed through the course entirely at your own pace. More...
Reference Library
Partner Programs
Courseware
Microsoft Partner
