🇩🇪
Programm

  1. Introduction

  2. PL/SQL Programming Concepts: Review

  3. Designing PL/SQL Code

  4. Overview of Collections

  5. Using Collections

  6. Manipulating Large Objects

  7. Using Advanced Interface Methods

  8. Performance and Tuning

  9. Improving Performance with Caching

  10. Analyzing PL/SQL Code

  11. Profiling and Tracing PL/SQL Code

  12. 12:Implementing VPD with Fine-Grained Access Control

  13. Safeguarding Your Code Against SQL Injection Attacks


Ziele
This Oracle Database 12c: Advanced PL/SQL training teaches you how to use the advanced features of PL/SQL to design and tune PL/SQL to interface with the database and other applications. Expert Oracle University instructors will help you explore advanced features of program design, packages, cursors, extended interface methods and collections.



Nach Abschluss des Seminars haben die Teilnehmer Kenntnisse zu folgenden Themen:


  • Write powerful PL/SQL programs.

  • Explore programming efficiency.

  • Use external C and Java routines.

  • Apply 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.
Voraussetzungen
Für dieses Seminar werden folgende Kenntnisse empfohlen:

  • Basic Knowledge of SQL, PL/SQL

  • Familiarity with programming languages

  • Oracle Database: Develop PL/SQL Program Units

  • Oracle Database: SQL Workshop I