Oracle Database 12c R2: Advanced PL/SQL Ed 2 Training

Live Online & Classroom Enterprise Certification Training

Looking for a private batch ?

REQUEST A CALLBACK

Certified Trainer
Authorized Courseware
Completion Certificate from ATP

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is 12c R2: Advanced PL/SQL Ed 2 Certification Training about?

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.

Students will benefit from using advanced features of program design, packages, cursors, extended interface methods, and collections and students learn how to write powerful PL/SQL programs.

Programming efficiency, use of external C and Java routines, PL/SQL server pages, and fine-grained access are covered. Students learn how to write PL/SQL routines that analyze the PL/SQL applications and caching techniques that can improve performance.

Students are introduced to the Virtual Private Database (VPD) to implement security policies and they learn techniques and tools to strengthen their applications against SQL injection attacks.

What are the objectives of 12c R2: Advanced PL/SQL Ed 2 Certification Training ?

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
Learn to work with JSON data in relational database
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

Who is 12c R2: Advanced PL/SQL Ed 2 Certification Training for?

Technical Consultant

Application Developers

Database Administrators

Support Engineer

What are the prerequisites for 12c R2: Advanced PL/SQL Ed 2 Certification Training?

Suggested Prerequisite

Basic Knowledge of SQL, PL/SQL
Familiarity with programming languages
Knowledge of PL/SQL Program Units

Required Prerequisite

Oracle Database 12c R2: SQL Workshop
Oracle Database: Develop PL/SQL Program Units Ed 2

Available Training Modes

Live Online Training

24 Hours

Classroom Training

3 Days

Course Outline Expand All

Expand All

Introduction

List the PL/SQL development environments Available in this course

Start SQL Developer and Create a Database Connection

Course Objectives

Use the SQL Worksheet

Course Agenda

Review the online Oracle Database 12c SQL and PL/SQL documentation and the additional available resources

Identify the Appendices Used in this Course

Describe the full Human Resources (HR) Schema

Oracle Database Exadata Express Cloud Service

Connecting to Exadata Express Database using Database Clients

Using SQL Developer to work with Exadata Express Database

Overview of Oracle Database Exadata Express Cloud Service

Accessing Cloud Database using SQL Workshop

Overview of Collections

Use Nested tables

Use Associative arrays

Use Varrays

Overview of Collections

Using Collections in PL/SQL

Enhancements to PL/SQL Type Binds

Use Collections effectively

Binding PL/SQL only datatypes to SQL statements using DBMS_SQL

Write PL/SQL programs that use collections

Manipulating Large Objects

Overview of SecureFile LOBs

Working with LOBs

Working with JSON Data

PL/SQL object types for JSON

Querying JSON columns

JSON data columns in tables

Generation of JSON data with SQL/JSON generation function

JSON Data

Using Advanced Interface Methods

Benefits of External Procedures

Java advanced interface methods

C advanced interface methods

Access PL/SQL blocks from from Java classes using JDBC

Understand how an external routine is called from PL/SQL

Calling External Procedures from PL/SQL

Performance and Tuning

Designing Applications for Real World Performance

Understand and influence the compiler

Recognize network issues

Identify and tune memory issues

Enable intra unit inlining

Tune PL/SQL code

Improving Performance with Caching

Review PL/SQL function cache considerations

Use PL/SQL function cache

Describe result caching

Analyzing PL/SQL Code

PL/Scope Concepts

PL/SQL Enhancements

PL/SQL Pragma to mark an item deprecated

Finding Coding Information

DBMS_METADATA Package

Profiling and Tracing PL/SQL Code

What is Tracing and Profiling

Tracing PL/SQL Execution

Tracing PL/SQL: Steps

Securing application through PL/SQL

Managing Access to data using PL/SQL

Creating Secure Application roles to control access to applications

Controlling Access to Program Units

Safeguarding Your Code Against SQL Injection Attacks

Filtering Input with DBMS_ASSERT

SQL Injection Overview

Reducing the Attack Surface

Security Features implemented through PL/SQL

List the DBMS_RLS procedures

Brief introduction to Security implementation

Fine Grained Access Control

Implement a policy

Query the dictionary views holding information on fine-grained access

Application Context

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

12c R2: Advanced PL/SQL Ed 2 Certification Training - Certification & Exam

SpringPeople is the Authorized Training Partner of Oracle.
The training fees is exclusive of exam cost.
For any queries; feel free to reach us at oracle@springpeople.com

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree