Menu
Oracle Training and Certification

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.

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.

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.

  • IT Infrastructure Training and Certification

    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.

     

  • Cloud Computing Training & Certification

    OEMCC-13c-IU: Oracle Enterprise Manager Cloud Control 13c: Install & Upgrade

    RM4,500.00
    2 Days ILT, VILT

    In the Oracle Enterprise Manager Cloud Control 13c: Install & Upgrade course, you’ll learn about the architecture of Oracle Enterprise Manager Cloud Control 13c, implementation options and you’ll perform a standard single-server installation. In this course we will also review the available upgrade paths from previous versions and execute a 1-system upgrade from Enterprise Manager Cloud Control 12c 12.1.0.5

    Learn To:

    • Install Oracle Enterprise Manager Cloud Control 13c.
    • Plan and execute a 1-system upgrade from Oracle Enterprise Manager Cloud Control 12c.
  • Analytics and Data Training and Certification

    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.

  • Analytics and Data Training and Certification

    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.

  • Analytics and Data Training and Certification

    OD-NDD: Oracle NoSQL Database for Developers

    RM4,500.00
    2 Days ILT, VILT

    In the Oracle NoSQL Database for Developers Ed 1 course, you will learn how to use the Oracle NoSQL Database developer APIs for Java. You will also discover how to access the KVStore from a Java application to store and manipulate data in a KVStore.

    Learn To:

    • Understand the key concepts of the NoSQL technology and when to use the Oracle NoSQL Database versus an RDBMS.
    • Learn to design the schema for a Java application using a table based approach as well as a key value pair approach.
    • Learn to create the code for storing, manipulating and deleting data stored in a KVStore.
    • Handle exceptions and implement security, consistency, and durability policies for the KVStore and an application.

    You will identify the features and benefits of the Oracle NoSQL Database and will discover why and how Oracle NoSQL Database is used to store data, generally Big Data.

  • Analytics and Data Training and Certification

    OD-NDA: Oracle NoSQL Database for Administrators

    RM4,500.00
    2 Days ILT, VILT

    This Oracle NoSQL Database for Administrators training teaches you how to deploy a KVStore and troubleshoot installation and hardware failures. Expert Oracle University instructors will also teach you how to monitor and manage a KVStore.

    Learn To:

    • Plan installation of Oracle NoSQL Database.
    • Install and configure Oracle NoSQL Database.
    • Deploy Oracle NoSQL Database KVStore.
    • Secure the configuration.
    • Extend a KVStore by increasing the replication factor or capacity of the KVStore.
    • Troubleshoot installation and hardware failures.
    • Monitor and optimize Oracle NoSQL Database performance.
    • Perform backup, recovery, and upgrades.

    When you walk away from this course, you’ll be able to identify the features and benefits of the Oracle NoSQL Database. You’ll have a deeper understanding of how to optimize the KVStore’s performance.

  • Analytics and Data Training and Certification

    OD-MMA: Oracle Database: Managing Multitenant Architecture

    4 Days ILT, VILT

    This OD-MMA: Oracle Database: Managing Multitenant Architecture course covers all aspects of the multitenant architecture, providing detailed information on the components of an Oracle multitenant container database and its regular and application pluggable databases.

    You learn why and how to create and manage a multitenant container database and its regular and application pluggable databases, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged pluggable databases in multitenant container databases using various methods.

    In addition, you learn how to create common and local users and administer database security to meet your business requirements by using encryption, Database Vault and auditing and you will learn how to create a database deployment in the Cloud.

    Versions Supported: 19c, 18c, 12c

  • Analytics and Data Training and Certification

    OD-ULE: UNIX and Linux Essentials

    RM5,000.00
    3 Days ILT, VILT

    This UNIX and Linux Essentials course is designed for users and administrators who are new to the Oracle Linux and Oracle Solaris operating systems. It will help you develop the basic UNIX skills needed to interact comfortably and confidently with the operating system.

    Learn To:

    • Manage files and directories from the command line and learn to use the vim editing tool.
    • Perform remote connections and file transfers.
    • Customize the user environment and use advanced shell features in shell scripts.
    • Archive and compress files and directories.
    • Understand and manage process control.
    • View and modify file and directory permissions.

    Benefits to You

    Learn to work effectively with UNIX and Oracle Linux environments and master the fundamental administrative tasks for these operating systems. These are the first steps to ensuring 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 Oracle Cloud or private clouds.

  • Analytics and Data Training and Certification

    OD-DPUW: Oracle Database: Deploy, Patch and Upgrade Workshop

    RM4,500.00
    2 Days ILT, VILT

    This Oracle Database: Deploy, Patch and Upgrade Workshop gives you detailed information to help you install Oracle Database 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.
    • 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.

  • Analytics and Data Training and Certification

    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.
  • Analytics and Data Training and Certification

    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.
  • Analytics and Data Training and Certification

    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.
  • Analytics and Data Training and Certification

    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.
  • Analytics and Data Training and Certification

    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.
  • Analytics and Data Training and Certification

    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.
  • Analytics and Data Training and Certification

    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
  • Analytics and Data Training and Certification

    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.
  • Analytics and Data Training and Certification

    ODS-DC: Oracle Database Security: Detective Controls

    RM6,500.00
    5 Days ILT, VILT

    In the Oracle Database Security: Detective Controls course, students learn how they can use Oracle Database administration auditing features to meet the compliance requirements of their organization. The current regulatory environment requires better security at the database level. Students learn how to audit the access to their databases and how to use the auditing and compliance features to monitor data access and confidentiality. The course provides suggested Oracle solutions for common problems.

    Learn To:

    • Enumerate Oracle auditing solutions to monitor database security requirements.
    • Implement Oracle Audit Vault and Oracle Database Firewall.
    • Configure Oracle Audit Vault and Oracle Database Firewall.
    • Explain Oracle Compliance Framework.
    • Configure basic Compliance Framework rules.
  • Analytics and Data Training and Certification

    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.
  • Analytics and Data Training and Certification

    OD-XMLF: Oracle Database: XML Fundamentals

    RM4,500.00
    2 Days ILT, VILT

    This XML Fundamentals training introduces you to the basics of XML. In this 2 day hands on course, you will learn the central XML technologies, including writing well formed and valid XML, creating Document Type Definitions (DTDs) and XML schema documents and using XPath and XQuery.

    Learn To:

    • Create well-formed and valid XML documents.
    • Use XML Namespaces in an XML document to resolve name ambiguities in XML documents.
    • Create Document Type Definition and XML schema documents to validate XML documents.
    • Use XPath expressions and functions to find and select nodes in XML documents.
    • Transform XML documents by using stylesheets and XPath expressions.
    • Use Oracle JDeveloper to view, create, edit, and test XML and other XML-related documents.
    • Use XQuery to query, generate, and transform XML content.
    • Identify the features and benefits of Oracle XML DB
  • Analytics and Data Training and Certification

    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.
  • Analytics and Data Training and Certification

    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.
  • Analytics and Data Training and Certification

    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.
  • Analytics and Data Training and Certification

    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.

Frequently Asked Questions

Company

Customer Service

Principals

HRD Corp Training Provider 2
HRD Corp Training Provider 2

Trainocate: A Global Leader in Technology, Business, and People Development

In a world that never stands still, we help you move forward.

With over 30 years of experience, Trainocate has been empowering individuals and businesses to build the essential skills that drive growth and success. Whether it’s professionals advancing in their careers or organizations transforming their workforce, our training programmes deliver results.

Specializing in cloud computing, data & AI, cybersecurity, and digital leadership, our training is powered by industry-leading technology partners like AWS, Alibaba Cloud, Cisco, EC-Council, Fortinet, Google Cloud, IBM, ISACA, ISC2, Microsoft, NetApp, Nutanix, Oracle, Palo Alto, Splunk, Red Hat, Rocheston, Trend Micro, and VMware.

Trainocate Group operates in 24 countries blending global expertise with localized insights to train the next generation of tech professionals and business leaders.

Trainocate Malaysia, based in KL Eco City, is proud to be an HRD Corp Registered Training Provider and a Yayasan Peneraju ALTI, driving workforce development across Malaysia.

© Copyright Trainocate 2021. All rights reserved. IT Training Provider Malaysia
Go to Top