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

Oracle Database 12c: Advanced PL/SQL Certification Training 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
 
This course prepares you for Exam 1Z0-148.

Oracle Database 12c: Advanced PL/SQL Certification Training Course - 1Z0-148 (Duration : 24 Hours) Download Course Contents

Live Virtual Classroom
Group Training 2550
02 - 04 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 08 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 2900
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: Introduction
  • Course Objectives
  • Course Agenda
  • Describe the development environments
  • Identify the tables, data, and tools used in this course
Module 2: PL/SQL Programming Concepts: Review
  • Identify PL/SQL block structure
  • Packages, procedures and functions
  • Cursors
  • Handle exceptions
  • Dependencies
Module 3: Designing PL/SQL Code
  • 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
Module 4: Overview of Collections
  • Overview of collections
  • Use Associative arrays
  • Navigate using associative methods
  • Use Nested tables
  • Use Varrays
  • Compare nested tables and varrays
Module 5: Using Collections
  • Write PL/SQL programs that use collections
  • Use Collections effectively
  • Enhancements to PL/SQL Type Binds
Module 6: Manipulating Large Objects
  • Working with LOBs
  • Overview of SecureFile LOBs
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
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
Module 9: Improving Performance with Caching
  • Describe result caching
  • Use SQL query result cache
  • 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
Module 11: Profiling and Tracing PL/SQL Code
  • Tracing PL/SQL Execution
  • Tracing PL/SQL: Steps
Module 12: Implementing VPD with Fine-Grained Access Control
  • 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
Module 13: Safeguarding Your Code Against SQL Injection Attacks
  • SQL Injection Overview
  • Reducing the Attack Surface
  • Filtering Input with DBMS_ASSERT
Module 13: Oracle Cloud Overview
  • 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
Download Course Contents

Request More Information

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.

FAQ's


Yes, fee excludes local taxes.