Menu

You searched for: ""

  • Analytics and Data Training and Certification

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

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

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

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

Company

Customer Service

Principals

2025 Top 20 IT Training Company
HRD Corp Training Provider 2
2025 Top 20 IT Training Company
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 2026. All rights reserved. HRDC IT Training Provider Malaysia
Go to Top