Oracle Database 12c R2: Advanced PL/SQL Ed 2/1Z0-134

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

The Oracle Database 12c R2: Advanced PL/SQL Ed 2 training course will give you a detailed overview on using the advanced features of PL/SQL to design and tune PL/SQL to interface with the database and integrate with the other applications efficiently. During the training you will get knowledge of writing powerful PL/SQL programs with the help of external C/Java routines, fine-grained access packages, cursors, extended interfaces and collections.

Who Should Do Oracle Database 12c R2: Advanced PL/SQL Ed 2 training?

  • Application Developers
  • Database Administrators
  • Support Engineer
This course prepares you for Exam 1Z0-134. Test your current knowledge on Qubits42

Oracle Database 12c R2: Advanced PL/SQL Ed 2 (24 Hours) Download Course Contents

Live Online Training
Group Training 3400
27 - 29 Dec GTR 09:00 AM - 05:00 PM PST
(8 Hours/Day)
03 - 05 Jan 09:00 AM - 05:00 PM CST
(8 Hours/Day)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Buy Flexi For Only $99 (Online Training Re-imagined)

Course Modules

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
  • 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
Download Course Contents

Request More Information

Course Prerequisites
  • Fundamental awareness of SQL, PL/SQL
  • Basic knowledge of programming languages
  • Awareness of PL/SQL Program Units
  • Oracle Database: Develop PL/SQL Program Units Ed 2
  • Oracle Database: SQL Workshop I Ed 2

Upon Completion of this course you will know following:

  • 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