Oracle PL/SQL Training: Introduction to Oracle 10g PL/SQL Programming

Course Number: ORC-104
Duration: 3 days
view class outline

Oracle 10g PL/SQL Training Overview

In Accelebrate's Introduction to Oracle 10g PL/SQL Programming training, students write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle. They learn programming, management, and security issues of working with PL/SQL program units. Programming topics will include the built-in packages that come with Oracle^®, the creation of triggers, and stored procedure features.

Accelebrate also offers an Advanced Oracle 10g PL/SQL training class.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=course&page=ORA111.

Oracle 10g PL/SQL Training Prerequisites

A solid understanding of SQL and 3GL programming is required. It is recommended the student understand Oracle 10g SQL features.

Hands-on/Lecture Ratio

This course is 60% hands-on, 40% discussion, with the longest discussion segments lasting 20 minutes.

Oracle 10g PL/SQL Training Materials

All students receive comprehensive courseware and a related textbook.

Software Needed on Each Student PC

A complete installation of Oracle 10g

Please contact us for detailed setup instructions if you have purchased this class.

Oracle 10g PL/SQL Training Objectives

All attendees will learn how to:

Understand the environment and context in which PL/SQL operates.
Consider the advantages and benefits of PL/SQL within a database environment.
Declaring program variables and complex data types.
Developing logic within PL/SQL program blocks.
Fetching data from the database into program variables.
Returning program output to users.
Handling program exceptions.
Using explicit and implicit database cursors.
Using the advanced features of nested blocks and subprograms.
How to take advantage of new features such as regular expression support and the handling of string literals within program code.

Oracle 10g PL/SQL Training 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
Type ... Table
Type ... Record

Begin clause

About the begin clause
Performing data manipulation
Logic control & branching
if-then-else
Case

Exception clause

About the exception clause
Isolating the specific exception
Pragma exception_init
SQL%rowcount & select...into

Explicit cursors

About explicit cursors
Advanced cursor techniques

Advanced programming: nested blocks

Advanced programming: declared subprograms

Introducing database program units

About database program units
Types of PL/SQL program units
Types of stored program units
Advantages of using stored program units
Development tools

Creating stored procedures & functions

About stored procedures & functions
Creating procedures & functions
Executing procedures & functions
Handling compilation errors

Maintaining stored procedures & functions

Recompiling & dropping programs
Data dictionary storage
Managing dependencies

Conclusion

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
SharePoint Training

Adobe Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.