Menu
Oracle Training and Certification
Home » Courses » Oracle Education » Oracle Database » Page 2

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.

Home » Courses » Oracle Education » Oracle Database » Page 2

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.

  • Analytics and Data Training and Certification

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

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

  • Analytics and Data Training and Certification

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

  • Analytics and Data Training and Certification

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

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

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

Frequently Asked Questions

Company

Customer Service

Principals

2023 Top 20 IT Training and Technical Company
HRD Corp Training Provider 2
2023 Top 20 IT Training and Technical Company
HRD Corp Training Provider 2

No. 1 IT Training Center & Provider in Malaysia

Trainocate is the new and exciting development of the 25-year old establishment – Global Knowledge. The name Trainocate is inspired from the term “Training Advocate” which resonates the feeling of continuous learning, something that each member of the Trainocate team carries with them. We are in the business of empowering work forces in the Asia-Pacific region by maximizing their capabilities through training and certification. This not only helps with improving work performance but also, explores untapped potential within each individual.

Located in KL Eco City and just next to Mid Valley City, Trainocate Malaysia is a HRD Corp Registered Training Provider and Authorized Training Partner for big tech companies such as AWS, Alibaba Cloud, Cisco, Dell EMC, Fortinet, Google Cloud, IBM, Microsoft, NetApp, Nutanix, Oracle, Splunk, Red Hat, Trend Micro, and VMware. We also provide a broad range of human capital development and people skills training to individuals and organizations under American Management Association (AMA).

Years of experience in IT Training Provider Industry equates to bettering ourselves to ensure we deliver only the best training programs to our loyal clients, both in technology and people skills.

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