Oracle Database 12c: Advanced PL/SQL Certification Training Course - 1Z0-148

Download Course Contents

Oracle Database 12c: Advanced PL/SQL Course Overview

Oracle Database 12c: Advanced PL/SQL training course helps you understand how to use the advanced features of PL/SQL to design and tune PL/SQL to interface with the database and other applications. In Oracle Database 12c: Advanced PL/SQL training you will learn 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 Should do this course?

  • Application Developers
  • Database Administrators
 
  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Introduction
  • Course Objectives
  • Course Agenda
  • Describe the development environments
  • Identify the tables, data, and tools used in this course
  • Identify PL/SQL block structure
  • Packages, procedures and functions
  • Cursors
  • Handle exceptions
  • Dependencies
  • Describe the predefined data types
  • Create subtypes based on existing types for an application
  • List the different guidelines for cursor design
  • Describe cursor variables
  • White List
  • Overview of collections
  • Use Associative arrays
  • Navigate using associative methods
  • Use Nested tables
  • Use Varrays
  • Compare nested tables and varrays
  • Write PL/SQL programs that use collections
  • Use Collections effectively
  • Enhancements to PL/SQL Type Binds
  • Working with LOBs
  • Overview of SecureFile LOBs
  • 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
  • Understand and influence the compiler
  • Tune PL/SQL code
  • Enable intra unit inlining
  • Identify and tune memory issues
  • Recognize network issues
  • Describe result caching
  • Use SQL query result cache
  • Use PL/SQL function cache
  • Review PL/SQL function cache considerations
  • Finding Coding Information
  • PL/Scope Concepts
  • DBMS_METADATA Package
  • PL/SQL Enhancements
  • Tracing PL/SQL Execution
  • Tracing PL/SQL: Steps
  • Understand how fine-grained access control works overall
  • Describe the features of fine-grained access control
  • Describe an application context
  • Create an application context
  • Set an application context
  • List the DBMS_RLS procedures
  • Implement a policy
  • Query the dictionary views holding information on fine-grained access
  • SQL Injection Overview
  • Reducing the Attack Surface
  • Filtering Input with DBMS_ASSERT
  • Introduction to Oracle Cloud & Oracle Cloud Services
  • Cloud Deployment Models
  • Evolving from On-premises to Exadata Express
  • What is in Exadata Express?
  • Exadata Express for Users & Developers
  • Oracle Exadata Express Cloud Service
  • Getting Started with Exadata Express
  • Service Console & Web Access through Service Console
Live Online Training (Duration : 24 Hours)
Group Training 2550 Per Participant Incl. Official Courseware
06 - 08 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 06 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training 5100 2900 + If you accept merging of other students. Incl. Official Courseware
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Ultra-Fast Track

If you can't spare 24 hours. We can offer you an Ultra-Fast Track for 12 hours for only USD 2,320

Course Prerequisites
  • Basic Knowledge of SQL, PL/SQL
  • Familiarity with programming languages
  • Oracle Database: Develop PL/SQL Program Units
  • Oracle Database: SQL Workshop I

On Completion of this course you will be able to:-

  • 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

Give an edge to your career with Oracle certification training courses. Students can join the classes for Oracle Database 12c: Advanced PL/SQL Training & Certification Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

Request More Information

Add Name and Email Address of participant (If different from you)