Tackle performance, availability, security, and compliance with Oracle Database products.

Explore the most advanced features and methods for achieving maximum performance, availability, and reliability using core database technologies and features. Learn how to leverage enhancements in multitenant architecture, manage security, use RMAN, understand general Database Administration functionality, implement big data, and more.

Earning Oracle Database certification helps you achieve more, faster, with fewer resources, empowers you with the skills and gives you an edge over the competition.

From basics to advanced curriculum, learn everything you need to know about management, development, security, and enabling high availability and data warehousing in Oracle Database versions 19c, 18c, 12c, 12c R2, and 11g.

OAM-12c-AE: Oracle Access Management 12c: Administration Essentials

RM6,500.00
5 Days ILT, VILT
This OAM-12c-AE: Oracle Access Management 12c: Administration Essentials training teaches you how to install, configure and implement a real life deployment of Oracle Access Manager 12c PS3 (12.2.1.3). Work with expert Oracle University instructors to install, troubleshoot, diagnose and more.

Learn To:

Install and configure Oracle Access Manager 12c PS3.

Configure servers, data sources and agents.

Set up policy configuration (shared components and application domain).

Manage sign-on, sign-off and sessions. Configure detached credential collector [DCC] Set up auditing, logging and troubleshooting for OAM 12c PS3.

Manage sessions, policy and agents with the REST API.
OAV-IC: Oracle Audit Vault and Database Firewall: Install & Configure

RM4,500.00
2 Days ILT, VILT
In the Oracle Audit Vault and Database Firewall: Install & Configure course, students will learn how to deploy Oracle Audit Vault and Database Firewall.

Learn To:

Install, configure, and manage the Audit Vault Server.

Deploy the Audit Vault Agent.

Describe Database Firewall Networking.

Install, deploy, and manage a Database Firewall.

Install and enable Host Monitoring.
OAV-PR: Oracle Audit Vault and Database Firewall: Policies & Reports

RM4,500.00
2 Days ILT, VILT
No hands-on lab environment for the Training On-Demand course format

In the Oracle Audit Vault and Database Firewall: Policies & Reports course, students will learn how to create audit and Database Firewall policies, use built-in reports, create custom reports, and define alerts.

Learn To:

Create and provision audit policies for Oracle Databases.

Create and publish Database Firewall policies.

Configure and respond to alerts.

Use and customize built-in reports.

Manage entitlements.
OD-12c-GDS: Oracle Database 12c: Global Data Services

RM4,000.00
1 Day ILT, VILT
The Oracle Database 12c: Global Data Services seminar helps you learn about Oracle Database 12c Global Data Services (GDS). Expert Oracle instructors will teach you how to install, configure, administer and use Global Data Services.

Learn To:

Install Global Data Services.

Configure the Global Data Services framework.

Administer Global Data Services Clouds.

Topics Covered:

Global Data Services overview

Global Data Services framework

Global Services theory

Global connection load balancing

Global runtime connection load balancing

Global Services failover

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Explore Global Data Services

You’ll also learn about the benefits provided by Global Data Services for managing cloud-deployed distributed databases. Furthermore, you’ll review best practices for configuring Global Data Services to use Oracle Active Data Guard configuration and Oracle GoldenGate replication.
OD-12c-IP: Oracle Database 12c: Implement Partitioning

RM4,500.00
2 Days ILT, VILT
This Oracle Database 12c: Implement Partitioning training teaches you how to manage partitioning using Oracle Database 12c. Expert Oracle University instructors will demonstrate the benefits of partitioning for different types of workloads and learn the syntax for partitioning maintenance operations. In this course, you will be introduced to Oracle Database Cloud Service.

Learn To:

Apply partitioning strategies to enhance application performance.

Use partitioning techniques to reduce impact of table and index maintenance.

Use partitioning to decrease the time to refresh materialized views.

Partition lob segments, nested tables and object tables.

Understand the Oracle Partitioning methods for tables, index and materialized views available in Oracle Database 12c Release 1.

Gain an understanding of the Oracle Database Cloud Service.
OD-12c-PMT: Oracle Database 12c: Performance Management and Tuning

RM6,500.00
5 Days ILT, VILT
In the Oracle Database 12c: Performance Management and Tuning course, learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. In this course, you will be introduced to Oracle Database Cloud Service.

Learn To:

Use the Oracle tuning methodology.

Use Oracle-supplied tools for monitoring and diagnosing SQL and instance performance issues.

Use database advisors to proactively correct performance problems.

Identify and tune problem SQL statements.

Monitor instance performance by using Enterprise Manager.

Tune instance components.

Gain an understanding of the Oracle Database Cloud Service.
OD-12c-SQLW1: Oracle Database 12c R2: SQL Workshop I

RM5,000.00
3 Days ILT, VILT
The Oracle Database: SQL Workshop I Ed 3 course offers students an introduction to Oracle Database 12c database technology. The students are also introduced to Oracle Database Exadata Express Cloud Service. In this class students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

Learn To:

Identify what a SQL statement is.

Understand the Oracle Relational Database.

Use SQL Developer.

Write reports using SQL Statements.

Manipulate data in relational tables and save the data.
OD-12c-SQLW2: Oracle Database: SQL Workshop II

RM4,500.00
2 Days ILT, VILT
The Oracle Database: SQL Workshop II Ed 2 course will help students enhance their skills as Application developers by learning to manage the database objects, data dictionary views and multicolumn subqueries. Students also learn to write more efficient queries using the functions supporting the timezone and regular expressions.

Learn To:

Grant and revoke privileges and roles.

Manage schema objects and data dictionary views.

Write efficient and complex subqueries.

Use the in-built functions supporting the usage of regular expressions and time zone.
OD-12cR2-AP: Oracle Database 12c R2: Advanced PL/SQL

RM5,000.00
3 Days ILT, VILT
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.

Learn To:

Apply PL/SQL designing best practices.

Create PL/SQL applications that use collections.

Work with JSON data in the database.

Implement a virtual private database with fine-grained access control.

Write code to interface with external C and Java applications.

Write code to interface with large objects and use SecureFile LOBs.

Write and tune PL/SQL code effectively to maximize performance.
OD-12cR2-ASMA: Oracle Database 12c: ASM Administration

RM4,500.00
2 Days ILT, VILT
This Oracle Database 12c: ASM Administration training teaches you about Oracle ASM architecture. Expert Oracle University instructors will help you develop a deeper understanding of both standard ASM and Flex ASM applications. In this course, you will be introduced to Oracle Database Exadata Cloud Service.

Learn To:

Administer ASM files, directories, templates, and disk groups.

Manage and administer Oracle Cloud File System and its components.

Configure and manage advanced CloudFS features like ACFS Auditing and Encryption, ACFS Replication and High Availability NFS.

Gain an understanding of the Oracle Database Exadata Cloud Service.
OD-12cR2-AW: Oracle Database 12c R2: Administration Workshop

Price range: RM6,500.00 through RM7,680.00

5 Days ILT, VILT

The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner.
OD-12cR2-BRW: Oracle Database 12c R2: Backup and Recovery Workshop

Price range: RM6,500.00 through RM7,680.00
5 Days ILT, VILT
In this Oracle Database 12c R2: Backup and Recovery Workshop, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several failure situations.

Learn To:

Develop appropriate backup and recovery procedures to address your business needs.

Implement backup and recovery settings and perform backup operations to disk and tape.

Employ Oracle Database recovery procedures to recover from media and other failures.

Diagnose and repair data failures.

Use Flashback Technologies and data duplication to complement backup and recovery procedures.

Secure the availability of your database by appropriate backup and recovery strategies.
OD-12cR2-CA: Oracle Database 12c: Clusterware Administration

RM5,500.00
4 Days ILT, VILT
This Oracle Database 12c: Clusterware Administration training will explore general cluster concepts and Oracle Clusterware architecture. Work with expert Oracle University instructors through interactive instruction and hands-on exercises to reinforce your learning. In this course, you will be introduced to Oracle Database Exadata Cloud Service.

Learn To:

Perform Grid Infrastructure pre-installation tasks.

Install both Standard and Flex clusters.

Add and remove nodes from a cluster in addition to upgrading and patching existing Grid Homes.

Manage and administer both Standard Clusters and Policy-Managed Clusters.

Use Oracle Clusterware to make applications highly available.

Gain an understanding of the Oracle Database Exadata Cloud Service.
OD-12cR2-HANF: Oracle Database 12c R2: High Availability New Features

RM5,500.00
4 Days ILT, VILT
The Oracle Database 12c R2: High Availability New Features course covers High Availability new features introduced in the Oracle Database 12c Release 2. Focus areas include Clusterware, ASM, ACFS, RAC, and Data Guard.

Learn To:

Configure and administer the Oracle Database 12c R2 high availability new features contained in Oracle Clusterware Infrastructure (including Automatic Storage

Management [ASM] and Cloud FS.

Configure and administer RAC new features.

Describe the new features contained in Oracle Data Guard.

Describe Oracle Data Guard Enhancements.

Gain an understanding of the Oracle Database Exadata Cloud Service.

Gain an understanding of Clusterware Manageability Enhancements.

Gain an understanding of ASM New Features.

Gain an understanding of ACFS Manageability New Features & Performance Enhancements.

Gain an understanding of Real Application Cluster New Features.

Gain an understanding of Data Guard and Broker New Features.
OD-12cR2-IUW: Oracle Database 12c: Install and Upgrade Workshop

RM4,500.00
2 Days ILT, VILT
This Oracle Database 12c: Install and Upgrade Workshop gives you detailed information to help you install Oracle Database 12c software. Expert Oracle instructors will teach you how to create a container database and provision pluggable databases. In this course, you will be introduced to Oracle Database Cloud Service.

Learn To:

Install Oracle Grid Infrastructure for a Standalone Server.

Use Oracle Restart to manage components.

Upgrade an existing Oracle Database to Oracle Database 12c.

Create a container database and provision pluggable databases.

Gain an understanding of the Oracle Database Cloud Service.

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Gain Hands-On Experience

Get practical experience installing the Oracle Grid Infrastructure software and Oracle Database software by using Oracle Universal Installer. Expert Oracle instructors will teach you how to stop and start Oracle Restart using SRVCTL to manage components.
OD-12cR2-NFAP1: Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1

RM6,500.00

5 Days ILT, VILT

The Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1 training course will give you a detailed overview of following modules, the Using SQL New Features and Tools, the Understanding DB Architectures, and the Diagnosing Database Problems. During the training, you will be skilled with the knowledge about on-premises Multitenant databases and various other new features in different areas of database administration.
OD-12cR2-NFAP2: Oracle Database 12c R2: New Features for Administrators Part 2

RM6,500.00

5 Days ILT, VILT

Throughout the lessons of the Oracle Database 12c R2: New Features for Administrators Part 2 course constituted by five modules; the Securing Data module, the Making Data Available module, the Partitioning Data module, the Managing Information Lifecycle module and the Monitoring DB Operations and Managing Performance module, students receive a good knowledge of the Oracle Database 12c Release 2 new and enhanced features in different areas of database administration like Unified Auditing, Transparent Data Encryption (TDE) and other areas of security, Recovery Manager, online operations, Oracle Data Pump, SQL*Loader, new partitioning methods, Automatic Data Optimization, In-Memory Column Store, Full Database In-Memory Caching, and Automatic Big Table Caching.

Learn To:

Gain an understanding of the new and enhanced features of Oracle Database 12c Release 2 (12.2.0.1) amongst different areas such as security, availability, partitioning, performance, and Information Lifecycle Management (ILM).
OD-12cR2-PP: Oracle Database 12c R2: Program with PL/SQL

RM6,500.00
5 Days ILT, VILT
This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you’ll learn to develop stored procedures, functions, packages and more.

Learn To:

Conditionally control code flow (loops, control structures).

Create stored procedures and functions.

Use PL/SQL packages to group and contain related constructs.

Create triggers to solve business challenges.

Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.

Create custom packages for applications.

Write Dynamic SQL code for applications.
OD-12cR2-RACA: Oracle Database 12c: RAC Administration

RM5,500.00
4 Days ILT, VILT
This Oracle Database 12c: RAC Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion. In this course, you will be introduced to Oracle Database Exadata Cloud Service.

Learn To:

Install Oracle RAC software.

Create cluster databases.

Administer both administrator and policy-managed Oracle RAC databases.

Monitor and address performance issues.

Learn about services in a RAC environment as well as highly available connection features including Application Continuity and Transaction Guard.

Create and administer a RAC One Node Database.

Create and manage multitennant RAC databases.

Gain an understanding of the Oracle Database Exadata Cloud Service.
OD-12cR2-SPF: Oracle Database 12c: SQL and PL/SQL Fundamentals

RM6,500.00
5 Days ILT, VILT
This Oracle Database: SQL and PL/SQL Fundamentals training delivers the fundamentals of SQL and PL/SQL along with the benefits of the programming languages using Oracle Database technology. You’ll explore the concepts of relational databases.

Learn To:

Write queries against single and multiple tables, manipulate data in tables and create database objects.

Use single row functions to customize output. Invoke conversion functions and conditional expressions.

Use group functions to report aggregated data. Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.

Develop anonymous PL/SQL blocks, stored procedures and functions. Declare identifiers and trap exceptions.

Use DML statements to manage data.

Use DDL statements to manage database objects.

Declare PL/SQL Variables.

Conditionally control code flow (loops, control structures).

Describe stored procedures and functions.

Retrieve row and column data from tables.
OD-12cR2-SQLTD: Oracle Database12c R2: SQL Tuning for Developers

RM5,000.00
3 Days ILT, VILT
In the Oracle Database: SQL Tuning for Developers course, you learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code. Learn the different ways in which data can be accessed efficiently. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.

Learn To:

Use Oracle tools to identify inefficient SQL statements.

Use Automatic SQL Tuning.

Use Real Time SQL monitoring.

Write more efficient SQL statements.

Monitor and trace high load SQL statements.

Manage optimizer statistics on database objects.

Understand the optimizer process steps and operators.

Interpret execution plans.

Perform application tracing.

Gain an understanding of the Oracle Database Exadata Express Cloud Service
OD-18c-ARO: Oracle Database Appliance Release 18c Overview

RM4,500.00

2 Days ILT, VILT

The course covers planning, installation, and deployment of Oracle Database Appliance, Release 18c. Students will learn how Oracle Database Appliance compares to other Oracle engineered systems and the advantages of using Oracle Database Appliance. After reviewing and planning for a new deployment, students will utilize the Web Console to deploy a bare metal appliance and the Oracle Appliance Configuration Manager tool to generate a deployment plan configuration for a virtualized appliance. Additional instructional videos and simulation software covers the concepts of racking and cabling a newly arrived Oracle Database Appliance system, running first boot scripts, downloading and installing the end-user bundle, and applying the latest patch bundles. The simulation labs are performed for both bare metal deployments and virtualized Oracle Database Appliance deployments.
OD-18c-HANF: Oracle Database 18c: High Availability New Features Ed 1

RM4,000.00
1 Day ILT, VILT
In the Oracle Database 18c: High Availability New Features course, students will learn about new software features and improvements found in Oracle Clusterware, Oracle ASM, Real Application Clusters, and Oracle Data Guard.

Configure and implement Oracle Clusterware enhancments.

Use and manage ASM using the new features in this release.

Use additional enhancements for Oracle ACFS and ADVM.

Leverage Oracle RAC new featuers found in this release.

Configure and use Oracle Data Guard new features.

Use new Data Guard Broker commands.
OD-18c-NFA: Oracle Database 18c: New Features for Administrators

RM5,000.00
3 Days ILT, VILT
This course provides an overview of the Oracle Database 18c new features and enhancements related to Multitenant architecture, security, RMAN, general database areas, performance, data warehousing and Sharding.

Learn To:

Use new features like Application PDB Fleet and PDB snapshots carousel of the Multitenant architecture.

Understand new features like PDB keystores and encryption of sensitive data in Database Replay files of the Security.

Benefit from new features like reuse of preplugin backups and duplication of active PDBs into an existing CDB of RMAN.

Use new features like private temporary tables and online modification of partitioning and subpartitioning strategy of General Database.

Configure and use new features like Automatic In-Memory Management in Performance.

Manipulate new features like inline external tables and polymorphic table functions of the Data Warehousing.

Understand enhancements like user-defined sharding method and support for PDBs as shards in Sharding.
OD-19c-AP: Oracle Database 19c: Advanced PL/SQL

Price range: RM5,000.00 through RM6,062.00

3 Days ILT, VILT

Oracle Database 19c is the latest release of Oracle’s flagship relational database management system.

This Oracle Database course teaches you 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 19c: 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.
OD-19c-ASMAW: Oracle Database 19c: ASM Administration Workshop

RM4,500.00

2 Days ILT, VILT

Expand your database knowledge and gain an edge in a competitive IT marketplace.

Explore the most advanced features and methods for achieving maximum performance, availability, and reliability using core database technologies and features. Learn how to leverage enhancements in multitenant architecture, manage security, use RMAN, understand general Database Administration functionality, implement big data, and more.

This Oracle Database course teaches you about Oracle ASM architecture and its components. During the training, you will get a deep understanding of both standard ASM and Flex ASM applications.
OD-19c-AW: Oracle Database 19c: Administration Workshop

Price range: RM6,500.00 through RM7,562.00

5 Days ILT, VILT

Learn how to effectively manage and administer your Oracle Database.

This OD-19c-AW: Oracle Database 19c: Administration Workshop course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database.

In addition, you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.
OD-19c-BR: Oracle Database 19c: Backup and Recovery

Price range: RM6,500.00 through RM7,562.00

5 Days ILT, VILT

The student begins by gaining a deeper understanding of possibly the most important job of a DBA – backup and recovery. The concepts and architecture that support backup and recovery, along with implementation in various ways and situations are covered in detail. Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication.
OD-19c-CAW: Oracle Database 19c: Clusterware Administration Workshop

RM5,500.00

4 Days ILT, VILT

A High Availability Cluster and the Foundation for Oracle RAC.

Oracle Clusterware is a portable cluster software that allows clustering of independent servers so that they cooperate as a single system. Oracle Clusterware was first released with Oracle Database 10g Release 1 as the required cluster technology for the Oracle multi-instance database, Oracle Real Application Clusters (RAC).

This OD-19c-CAW: Oracle Database 19c: Clusterware Administration Workshop course teaches you general cluster concepts and Oracle Clusterware architecture. In this course you will learn in-depth understanding of installing, configuring, patching and maintaining Oracle Clusterware 19c.
OD-19c-DC: Oracle Database 19c: Data Confidentiality

Price range: RM4,000.00 through RM5,062.00
1 Day ILT, VILT
The threat to data has never been greater. Oracle Database helps reduce the risk of a data breach and simplifies regulatory compliance with security solutions for encryption and key management, granular access controls, flexible data masking, comprehensive activity monitoring, and sophisticated auditing capabilities.

The OD-19c-DC: Oracle Database 19c: Data Confidentiality course covers the following topics:

Application Contexts

Virtual Private Database

Oracle Label Security

Data Masking

Data Redaction

Real Application Security
OD-19c-DE: Oracle Database 19c: Data Encryption

Price range: RM4,000.00 through RM5,062.00
1 Day ILT, VILT
This is a newly curated course of one day duration that covers the Data Encryption aspect related to the latest of release of Oracle Database (19c).

The course covers the following topics:

Managing Endpoints and Oracle Wallets

Encryption

Key Vault and Transparent Data Encryption

Performing Oracle Key Vault Administrative Tasks
OD-19c-DGAW: Oracle Database 19c: Data Guard Administration Workshop

RM6,500.00

5 Days ILT, VILT

This Oracle course introduces the main architectural concepts of Oracle Data Guard. The delegate will learn how to use Oracle Data Guard to protect an Oracle Database against planned and unplanned downtime.

Through a blend of hands-on labs and interactive lectures you will also learn how to create and manage physical, logical and snapshot standby databases and how to use standby databases for reporting, querying and testing purposes.
OD-19c-DMT: Oracle Database 19c: Data Mining Techniques

RM4,500.00

2 Days ILT, VILT

The OD-19c-DMT: Oracle Database 19c: Data Mining Techniques course covers the basic concepts and primary terminologies associated with data mining. The course explains the steps associated with the data mining process, the use of Oracle Data Miner to perform data mining, and the options for deploying data mining predictive results.
OD-19c-DWC: Oracle Database 19c: Data Warehousing Concepts

RM4,500.00
2 Days ILT, VILT
This OD-19c-DWC: Oracle Database 19c: Data Warehousing Concepts course covers the following topics:

Evolution of information management systems and data warehousing

Need for machine learning, artificial intelligence, and big data in future data analytics

Data warehouse concepts and terminology

Multidimensional model concepts and create analytic views

Explain the business, logical, dimensional, and physical data warehousing models

Importance of extraction, transformation, and loading in data warehousing systems
OD-19c-DWT: Oracle Database 19c: Data Warehousing Techniques

RM5,000.00

3 Days ILT, VILT

The Oracle Database 19c: Data Warehousing Techniques course teaches you the various Data Warehousing concepts and techniques related to data extraction, transformation, and loading phases. You will learn about the different changed data capture methods for data refresh, and how to define summary management and implement materialized views. You will also learn about the role of warehouse metadata along with the various data warehouse implementation considerations.
OD-19c-FDS: Oracle Database 19c: Fundamentals for Devs and SysAdmins

RM4,500.00
2 Days ILT, VILT
This OD-19c-FDS: Oracle Database 19c: Fundamentals for Devs and SysAdmins course teaches you how to perform common, day-to-day administrative tasks that are required of an Oracle database administrator (DBA).

The Oracle database course covers the following topics:

Install the Oracle Database Software and Create a Database

Use Enterprise Manager Database Express

Use SQL*Plus and SQL Developer

Use the Listener Control Utility

Use SQL Developer to Shut Down and Restart a Database

View Initialization Parameters

Manage the Database Storage Structures

Administer Users and Security

Create Application Tables and Load Database

Perform Backup and Recovery

Monitor Database Performance