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

Q: Is GST/ VAT applicable on the published fee?

No, the published fee includes all applicable taxes.

Overview Schedule & Fees Course Benefits Student Feedback FAQ Course Modules

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 18 - 20 Oct 09:00 AM - 05:00 PM CST (8 Hours/Day) 01 - 03 Nov 09:00 AM - 05:00 PM CST (8 Hours/Day) 06 - 08 Dec 09:00 AM - 05:00 PM CST (8 Hours/Day)	1-on-1 Training (GTR) 2900 4 Hours 8 Hours Week Days Weekend Start Time : At any time 12 AM 12 PM Training Schedule: GTR=Guaranteed to Run

Special Solutions for Corporate Clients! Click here

Hire Our Trainers! Click here

Customers who bought this course also bought

Developing Applications for the Java EE 7 Platform Ed 1

Oracle Database 19C:Administration Workshop Certification Training Course

Oracle SQL Certification Training Course

R12.x Oracle General Ledger Management Fundamentals

10% discount on 2nd course:

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

Request a call back?

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.