	Training/Mentoring

	E-Business Suite
	Business Intelligence
	Custom Development
	Database Services
	Managed Services
	Training/Mentoring
		The Service
		The Value
		References
		Contact Us / Registration
		Oracle Certification Prep
		Pricing
		Course Schedule
		Directions, Travel & Accommodations
		Register Online
	Oracle Licensing

PL/SQL

Click here to contact us

Course Overview

PL/SQL is designed for application developers who are new to the Oracle RDBMS environment. It provides developers with a solid foundation for developing applications using PL/SQL, the "lifeblood" of almost every Oracle application. The course progresses through each of the foundational components of the PL/SQL language, beginning with an overview of PL/SQL concepts and the relationship of PL/SQL to the Oracle Database. After providing students with a foundational basis, the course works its way to building the database-level triggers, stored procedures, functions and packages common to any Oracle Database application. Students also will learn how errors are propagated within PL/SQL and be provided with techniques for handling those errors. An introduction to a number of Oracle's built-in packages will raise students' awareness of the tools provided within the Oracle RDBMS. This course allows students to expand their knowledge of the presented concepts through the use of numerous hands-on exercises based upon real-world PL/SQL applications.

Course Goals

To gain an understanding of PL/SQL commands and concepts
To obtain a foundational hands-on experience through lab exercises in an instructor-led environment

Prerequisites

SQL & SQL*Plus or equivalent experience with ANSI-standard SQL

Who Should Attend?

Application developers
Application database administrators

Course Materials

PL/SQL Course Notes
PL/SQL Reference Publication
PL/SQL Sample Script Disk

Duration

Three days

Tuition

$1,395

Course Outline

Overview
- Why use PL/SQL?
- PL/SQL and Oracle RDBMS
- PL/SQL and the Oracle tools
- PL/SQL and the object relational database
PL/SQL components and syntax
- Block structure
- Variable scope
- Syntax and punctuation
- Running PL/SQL code from SQL*Plus
- Exercise I
- Variables and program units
- Anchoring variables
- TYPE operator
- PL/SQL-provided functions
- Exercise II
PL/SQL control structures
- Conditional control structures
- Sequential control structures
- Iterative control structures
  - The Basic Loop
  - The Numeric FOR Loop
  - The WHILE Loop
  - The Cursor FOR Loop
- Exercise III
- Exercise IV
PL/SQL cursors
- Overview
- Implicit cursors
- Explicit cursors
- Exercise V
- Cursor attributes
- Exercise VI
- The Cursor FOR Loop
- Exercise VII
- Tips and techniques
- Exercise VIII
- SELECT FOR UPDATE clause
PL/SQL exception handling
- Exception overview
- Exception types
- Tips and techniques
- Exercise X
PL/SQL stored program units
- Overview
- Procedures and functions
- Creating and maintaining program units
- Running stored program units
- Exercise XI
- Exercise XII
- Packages
- Stored program units and the Oracle data dictionary
- Exercise XIII
- Exercise XIV
PL/SQL built-in packages
- Overview
- DBMS_JOB
- DBMS_SQL
- DBMS_PIPE
- UTL_FILE
Database triggers
- Overview
- Creating triggers
- Managing triggers
10g new features
- Overview
Miscellaneous tips and techniques
- Coding standards
- Source code control
- Debugging tips
Review
For more information
Bibliography