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.

  • 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.

  • 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-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-MMSE: Oracle Database 19c: Monitoring and Maintaining a Secure Environment

    Price range: RM4,000.00 through RM5,062.00
    1 Day ILT, VILT

    Gain skills and knowledge needed to design and implement security policies to protect data from accidental, unauthorized, or inappropriate actions. 

    After completing this course, you will have the skills and knowledge necessary to design and implement security policies to protect data from accidental, unauthorized, or inappropriate actions. You will also be able to create and enforce practices of auditing and accountability for such actions. In addition, you will be able to develop applications that provide desired services securely in a variety of computational models, making use of database and directory services to maximize both efficiency and ease of use. This course is therefore essential for anyone who wants to work in the field of computer 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-SF: Oracle Database 19c: Security Fundamentals

    Price range: RM4,000.00 through RM5,062.00
    1 Day ILT, VILT

    This OD-19c-SF: Oracle Database 19c: Security Fundamentals course teaches you Security aspect related to the latest release of Oracle Database (19c).

     

  • 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.
  • 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.

  • 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.

  • 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.

  • 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.

  • 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.
  • 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.
  • 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
  • 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.
  • 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.
  • 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.
  • 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.

  • 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
  • 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.

  • 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
  • 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.

  • 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.

  • 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.
Go to Top