Oracle10g/11g PL/SQL Programming
Summary:
This class provides the technical expertise necessary to utilize this powerful component of Oracle. The content of this course applies to developing PL/SQL blocks for stand alone use, stored procedures, functions, packages and triggers or in the Oracle Forms or Reports development tools. manage all types of program units: procedures, functions, packages and triggers.
Duration:
5 Days Lecture/Lab
Audience:
* Intermediate Oracle SQL developers and DBAs* Intermediate Oracle PL/SQL developers and DBAs wishing to ‘back fill’ gaps in their expertise* Technical managers needing Oracle expertise for project administration
Topics:
- SQL tool
- The Petsaver database
- PL/SQL language fundamentals
- PL/SQL scalar variables
- SELECT statements in PL/SQL
- DML statements in PL/SQL
- Transaction control in PL/SQL
- PL/SQL control structures
- PL/SQL composite variables
- PL/SQL cursors
- PL/SQL block hierarchies
- PL/SQL exception handling
- Advanced exception handling
- Basic Oracle supplied packages
- PL/SQL performance tuning
- New features of PL/SQL in Oracle10g
- Creating stored procedures
- Creating stored functions
- Advanced features of procedures and functions
- Creating packages
- Advanced features of packages
- Creating database triggers
- Advanced features of triggers
- Maintaining program units
- Dynamic SQL in PL/SQL
- Advanced compilation techniques
- Advanced Oracle supplied packages
- Working with large objects (LOBs)
Prerequisites:
* Skill with GUI interfaces* Data processing background* A solid understanding of SQL (6 months of experience) is required to succeed in this class.* Persons attending without this will experience difficulty.
Last Update: May 22, 2012
