Course Overview

This Oracle Database 11g: Advanced PL/SQL Programming & Tuning course will give attention to three fundamental pillars of effective implementation of PL/SQL applications. The PL/SQL programming language is at the core of most Oracle database applications. First, we will explore the advanced features of the language, which allow powerful and effective database applications to be built. Next, we will discuss performance tuning techniques, which allow these applications to run efficiently. Finally, we will consider critical security measures that should be implemented to counter hacker attacks and other security threats.

What you’ll learn

Upon completion of the Oracle Database 11g: Advanced PL/SQL Programming & Tuning course, students will be able to:

• Invoke external procedures and integrate these into PL/SQL applications. These include external Java classes using the JDBC interface and external C programs contained within DLL libraries
• Use dynamic SQL to extend the functionality and flexibility of database programs, including the DBMS_SQL() system-supplied package for maximum flexibility
• Identify SQL injection attack vulnerabilities within an application and applying countermeasures to address security risks and protect against hacking
• Incorporate collections and other advanced types into application logic to increase efficiency and execution speed
• Work with LOBs, including piece-wise data manipulation and dynamic modification of SecureFile storage options
• Expand functionality with system-supplied database utility packages
• Tune with the DBMS_PROFILER() system-supplied package and debug with the DBMS_TRACE() system-supplied package
• Write efficient PL/SQL code and avoiding common coding mistakes
• Enable native compilation and execution of all database-resident program units
• Control and manage PL/SQL compilation for high-efficiency execution
• Analyze PL/SQL code structure by means of the PL/Scope facility
• Analyze PL/SQL application performance and tune bottlenecks using the PL/SQL Hierarchical Profiler
• Recognize the dangers of SQL injection attacks against PL/SQL applications and applying countermeasures to this potential security threat from hackers
• Implement fine-grained security mechanisms as part of an advanced security model using application contexts and the Oracle virtual private database (VPD)
• Understand dynamic partitioning and DML parallelization using the system-supplied package. DBMS_PARALLEL_EXECUTE()