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.
Start learning today!
Click Hereto customize your Training
Private training brings the classroom or virtual classroom experience to your office or a preferred offsite location. Convenient, practical, and effective training tailored to your company's needs.
If you have multiple locations, please list them in the comments section.
Module 1: Introduction
Module 2: Oracle Database Exadata Express Cloud Service
Module 3: Overview of Collections
Module 4: Using Collections in PL/SQL
Module 5: Manipulating Large Objects
Module 6: Working with JSON Data
Module 7: Using Advanced Interface Methods
Module 8: Performance and Tuning
Module 9: Improving Performance with Caching
Module 10: Analyzing PL/SQL Code
Module 11: Profiling and Tracing PL/SQL Code
Module 12: Securing application through PL/SQL
Module 13: Safeguarding Your Code Against SQL Injection Attacks
Module 14: Security Features implemented through PL/SQL
This course is not associated with any Certification.