This is an original ORACLE Training on Demand online product.
Nutzen
In the Oracle Database 12c R2: Advanced PL/SQL course, students learn how to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and integrate with the other applications in the most efficient manner. They learn to write powerful PL/SQL programs using external C/Java routines, fine-grained access packages, cursors, extended interfaces and collections.
Learn To:
Apply PL/SQL designing best practices.
Create PL/SQL applications that use collections.
Work with JSON data in the database.
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.
Zielgruppe
Datenbankadministratoren
Anforderungen
Basic Knowledge of SQL, PL/SQL.
Knowledge of PL/SQL Program Units.
Familiarity with programming languages.
Oracle Database: SQL Workshop I Ed 2.
Oracle Database: Develop PL/SQL Program Units Ed 2.
Inhalte
Oracle Database Exadata Express Cloud Service
Overview of Collections
Using Collections in PL/SQL
Manipulating Large Objects
Working with JSON Data
Using Advanced Interface Methods
Performance and Tuning
Improving Performance with Caching
Analyzing PL/SQL Code
Profiling and Tracing PL/SQL Code
Securing application through PL/SQL
Safeguarding Your Code Against SQL Injection Attacks
