Name: Oracle Database 10g: Advanced PL/SQL
Course Code: OR17220
Duration: 2
Scheduled Dates for OR17220
In this course, students learn how to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner. Using advanced features of program design, packages, cursors, extended interface methods, and collections, students learn how to write powerful PL/SQL programs. Programming efficiency, use of external C and Java routines, PL/SQL server pages, and fine-grained access are covered.
Target Audience
Technical Consultant
Database Designers
PL/SQL Developer
Key Topics
- Introduction
- PL/SQL Programming Concepts Review
- Design Considerations
- Collections
- Advanced Interface Methods
- PL/SQL Server Pages
- Fine Grained Access Control
- Performance and Tuning
- Analyzing PL/SQL Code
Objectives
- Design PL/SQL packages and program units that execute efficiently
- Write code to interface with external applications and the operating system
- Create PL/SQL applications that use collections
- Write and tune PL/SQL code effectively to maximize performance
- Implement a virtual private database with fine-grained access control
- Perform code analysis to find program ambiguities, test, trace, and profile PL/SQL code
Required Skills/Experience
- Oracle Database 10g: Program with PL/SQL
Fee: $1,200.00
Course Schedule:
Back to Course Description
Austin
Charlotte
Columbia
Hunt Valley
Lansing
Madison
Milwaukee
Minneapolis
Oak Brook
Oklahoma City
Phoenix
Raleigh
San Antonio
Schaumburg
Tulsa
Washington DC
