In this course, students learn 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 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.

• Introduction
• PL/SQL Programming Concepts Review
• Designing PL/SQL Code
• Using Collections
• Manipulating Large Objects
• Using Advanced Interface Methods
• Performance and Tuning
• Improving Performance with Caching
• Analyzing PL/SQL Code
• Profiling and Tracing PL/SQL Code
• Implementing VPD with Fine-Grained Access Control
• Safeguarding Your Code Against SQL Injection Attacks

• Knowledge of SQL
• PL/SQL Programming experience