Oracle Database 11g: Advanced PL/SQL

Students learn to write PL/SQL routines that analyze the PL/SQL applications and caching techniques that can improve performance. Students are also introduced to Virtual Private Database (VPD) to implement security policies and they also learn techniques and tools to strengthen their applications against SQL injection attacks.

Learn To:

• PL/SQL designing best practices
• Create PL/SQL applications that use collections
• Implement a virtual private database with fine-grained access control
• Write code to interface with external C and Java applications
• Write code to interface with large objects and use SecureFile LOBs
• Write and tune PL/SQL code effectively to maximize performance

Audience:

• Database Beheerder
• Applicatie Ontwikkelaar met PL/SQL

Course 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
• Write code to interface with large objects and use SecureFile LOBs

Required Prerequisites:

• Knowledge of SQL
• PL/SQL Programming experience
• Oracle Database 11g: Introduction to SQL Release 2