COURSE OBJECTIVE
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.
WHO CAN BENEFIT
- Application Developers
- Database Administrators
GAINING SKILLS
After completing this course, students will be able to:
- Design PL/SQL packages and program units that execute efficiently
- Write code to interface with external applications and the operating system
- Create PL/SQL applications that use collections
- Write and tune PL/SQL code effectively to maximize performance
- Implement a virtual private database with fine-grained access control
- Write code to interface with large objects and use SecureFile LOBs
- Gain an understanding of the Oracle Database Exadata Express Cloud Service
COURSE CERTIFICATION
OCP Developer
PREREQUISITE
Before attending this course, students must have:
- Basic Knowledge of SQL, PL/SQL
- Familiarity with programming languages
COURSE CONTENT
- Introduction
- PL/SQL Programming Concepts: Review
- Designing PL/SQL Code
- Overview of Collections
- Using Collections
- Manipulating Large Objects
- Using Advanced Interface Methods
- Performance and Tuning
- Improving Performance with Caching
- Analyzing PL/SQL Code
- Profiling and Tracing PL/SQL Code
- 12:Implementing VPD with Fine-Grained Access Control
- Safeguarding Your Code Against SQL Injection Attacks
- Oracle Cloud Overview
ABOUT INSTRUCTOR
