Oracle Database 11g: Advanced PL/SQL Ed 1

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, large objects, and collections, students learn to write powerful PL/SQL programs. Also learn programming efficiency, use of external C and Java routines, fine-grained access and safeguarding your code against SQL Injection attacks.

Vorkenntnisse erforderlich

• D49988 Oracle Datenbank 11g: Professioneller Einstieg in Oracle SQL



• D49992 Oracle Datenbank 11g: PL/SQL und Datenbankprogrammierung

Kursbeschreibung

Sachgebiete

• Overview of the Development Environments
• Design Considerations
• Using Collections
• Using Advanced Interface Methods
• Implementing VPD with Fine-Grained Access Control
• Manipulating Large Objects
• Administering SecureFile LOBs
• Tuning and Performance
• Improving Performance with SQL and PL/SQL Caching
• Analyzing PL/SQL Code
• Profiling and Tracing PL/SQL Code
• Safeguarding Your Code Against SQL Injection Attacks

Teilnehmerkreis

• Application Developers
• Developer
• PL/SQL Developer

Kategorie

Oracle Grundlagen und Sprachen

Sprache Unterlagen

English