Oracle Database 12c R2: Advanced PL/SQL Ed 2
Duration : 3 Days (24 Hours)
Oracle Database 12c R2: Advanced PL/SQL Ed 2 Course Overview:
The Oracle Database 12c R2: Advanced PL/SQL Ed 2 training course provides a comprehensive understanding of advanced PL/SQL features for designing and optimizing PL/SQL programs that interact efficiently with the database and external applications. Participants will learn to write powerful PL/SQL programs using external C/Java routines, fine-grained access packages, cursors, extended interfaces, and collections. The course enables students to enhance their skills in leveraging the full potential of PL/SQL to develop robust and high-performance applications. By the end of the training, attendees will be equipped to design and tune sophisticated PL/SQL solutions, optimizing their database interactions and integration capabilities.
Intended Audience:
- Application Developers
- Database Administrators
- Support Engineer
Learning Objectives of Oracle Database 12c R2: Advanced PL/SQL Ed 2:
- Designing efficient PL/SQL packages and program units
- Creating PL/SQL applications which use collections
- Working with JSON data in relational database
- Implementing a virtual private database with fine-grained access control
- Writing code to interface with large objects and use SecureFile LOBs
Module 1: Introduction
- Course Objectives
- Course Agenda
- Describe the full Human Resources (HR) Schema
- Identify the Appendices Used in this Course
- Review the online Oracle Database 12c SQL and PL/SQL documentation and the additional available resources
- List the PL/SQL development environments Available in this course
- Start SQL Developer and Create a Database Connection
- Use the SQL Worksheet
Module 2: Oracle Database Exadata Express Cloud Service
- Overview of Oracle Database Exadata Express Cloud Service
- Accessing Cloud Database using SQL Workshop
- Connecting to Exadata Express Database using Database Clients
- Using SQL Developer to work with Exadata Express Database
Module 3: Overview of Collections
- Overview of Collections
- Use Associative arrays
- Use Nested tables
- Use Varrays
Module 4: Using Collections in PL/SQL
- Write PL/SQL programs that use collections
- Use Collections effectively
- Enhancements to PL/SQL Type Binds
- Binding PL/SQL only datatypes to SQL statements using DBMS_SQL
Module 5: Manipulating Large Objects
- Working with LOBs
- Overview of SecureFile LOBs
Module 6: Working with JSON Data
- JSON Data
- JSON data columns in tables
- Generation of JSON data with SQL/JSON generation function
- Querying JSON columns
- PL/SQL object types for JSON
Module 7: Using Advanced Interface Methods
- Calling External Procedures from PL/SQL
- Benefits of External Procedures
- Understand how an external routine is called from PL/SQL
- C advanced interface methods
- Java advanced interface methods
- Access PL/SQL blocks from from Java classes using JDBC
Module 8: Performance and Tuning
- Understand and influence the compiler
- Tune PL/SQL code
- Enable intra unit inlining
- Identify and tune memory issues
- Recognize network issues
- Designing Applications for Real World Performance
Module 9: Improving Performance with Caching
- Describe result caching
- Use PL/SQL function cache
- Review PL/SQL function cache considerations
Module 10: Analyzing PL/SQL Code
- Finding Coding Information
- PL/Scope Concepts
- DBMS_METADATA Package
- PL/SQL Enhancements
- PL/SQL Pragma to mark an item deprecated
Module 11: Profiling and Tracing PL/SQL Code
- What is Tracing and Profiling
- Tracing PL/SQL Execution
- Tracing PL/SQL: Steps
Module 12: Securing application through PL/SQL
- Controlling Access to Program Units
- Managing Access to data using PL/SQL
- Creating Secure Application roles to control access to applications
Module 13: Safeguarding Your Code Against SQL Injection Attacks
- SQL Injection Overview
- Reducing the Attack Surface
- Filtering Input with DBMS_ASSERT
Module 14: Security Features implemented through PL/SQL
- Brief introduction to Security implementation
- Fine Grained Access Control
- Application Context
- List the DBMS_RLS procedures
- Implement a policy
- Query the dictionary views holding information on fine-grained access
Oracle Database 12c R2: Advanced PL/SQL Ed 2 Course Prerequisites:
The course does not have any prerequisites. It is suitable for those who have some familiarity with the Oracle Business Intelligence technology stack and Oracle E-Business Suite.
Discover the perfect fit for your learning journey
Choose Learning Modality
Live Online
- Convenience
- Cost-effective
- Self-paced learning
- Scalability
Classroom
- Interaction and collaboration
- Networking opportunities
- Real-time feedback
- Personal attention
Onsite
- Familiar environment
- Confidentiality
- Team building
- Immediate application
Training Exclusives
This course comes with following benefits:
- Practice Labs.
- Get Trained by Certified Trainers.
- Access to the recordings of your class sessions for 90 days.
- Digital courseware
- Experience 24*7 learner support.
Got more questions? We’re all ears and ready to assist!
Request More Details
