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. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.
MODULE 1
Introduction
MODULE 2
PL/SQL Programming Concepts: An Overview
MODULE 3
PL/SQL code design
MODULE 4
Collection overview
MODULE 5
Using collections
MODULE 6
Handling large objects
MODULE 7
Using advanced interface methods
MODULE 8
Performance and tuning
MODULE 9
Increasing performance with caching
MODULE 10
Analysis of PL/SQL code
MODULE 11
PL/SQL code profiling and monitoring
MODULE 12
Implementation of VPD with fine-grained control approach
MODULE 13
Code protection against SQL injection
Benefits to you:
Discover how to write PL/SQL routines that analyze the PL/SQL applications and caching techniques that can improve performance.
By investing in this course, you’ll be introduced to the Virtual Private Database(VPD) to implement security policies and explore techniques and tools to strengthen your applications against SQL injection attacks. Expand programming resources by creating PL/SQL programs that interface with C and Java code.
Learn To:
- 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.
- Gain an understanding of the Oracle Database Exadata Express Cloud Service.
Course attendance certificate issued by Semos Education
Payment with credit cards