Menu

Learn. Earn. Succeed with IBM Education.

IBM Training and certifications by Trainocate Malaysia offers you the ability to earn credentials to demonstrate your expertise. It is designed to validate your skills and capability to perform role-related tasks and activities at a specified level of competence.

The IBM Professional Certification Program offers you the ability to earn credentials to demonstrate your expertise. The achievement of an IBM Professional Certification demonstrates to your colleagues and employers your expertise in the related IBM technologies and solutions.

Whether its to gain greater insights and innovate faster with IBM Analytics, or build the foundation for cognitive business with IBM Systems Infrastructure courses or innovating with IBM cloud, we’ve got you covered.

Whether you need to gain new skills, earn credentials, or change careers, building skills is an investment in your future. Get started today.

Learn. Earn. Succeed with IBM Education.

IBM Training and certifications by Trainocate Malaysia offers you the ability to earn credentials to demonstrate your expertise. It is designed to validate your skills and capability to perform role-related tasks and activities at a specified level of competence.

The IBM Professional Certification Program offers you the ability to earn credentials to demonstrate your expertise. The achievement of an IBM Professional Certification demonstrates to your colleagues and employers your expertise in the related IBM technologies and solutions.

Whether its to gain greater insights and innovate faster with IBM Analytics, or build the foundation for cognitive business with IBM Systems Infrastructure courses or innovating with IBM cloud, we’ve got you covered.

Whether you need to gain new skills, earn credentials, or change careers, building skills is an investment in your future. Get started today.

  • Out of stock
    Analytics and Data Training and Certification

    CL464G: Db2 11.1 Advanced Database Administration

    2 Days ILT, VILT

    This course is designed to teach you how to: 

    • Perform advanced monitoring using the Db2 administrative views and routines in SQL queries.
    • Manage the disk space assigned in Database Managed Storage (DMS) and Automatic Storage table spaces, including the activities of the rebalancer.
    • Use SQL queries and Db2 commands to check the high water mark on table spaces and to monitor the rebalance operation.
    • Utilize the REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces using database or tablespace backup images.
    • Plan and execute the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases.
    • Create incremental database or tablespace level backups to reduce backup processing and backup image storage requirements.
    • Implement automatic storage management for table spaces and storage groups or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity.
    • Describe the various types of database memory including buffer pools, sort memory, lock memory and utility processing memory.
    • Adjust database or Db2 instance configuration options to improve application performance or processing efficiency.
    • Implement Db2 Self Tuning Memory management for specific database memory areas.
  • Out of stock
    Analytics and Data Training and Certification

    CL463G: DB2 10.5 for LUW Advanced Database Administration with DB2 BLU Acceleration

    5 Days ILT, VILT

    This course is designed to teach you how to:

    • Fully use the advanced technical functions and features of DB2 LUW 10.1 and 10.5.
    • Implement DB2 BLU Acceleration, column-organized table support, for a new or existing DB2 database.
    • Describe how the column dictionaries used for DB2 BLU Acceleration are built and utilized to provide extreme compression for column-organized tables.
    • Explain the default workload management used for DB2 BLU Acceleration processing and how you can tailor the WLM objects to efficiently use system resources.
    • Monitor a DB2 database or application that uses column-organized tables using SQL monitor functions.
    • Implement Shadow tables for selected row-organized tables to improve analytics query performance
    • Configure a DB2 database that supports a mixture of application processing, including OLTP and Analytics query processing with Shadow tables
    • Create the Infosphere CDC Datastore, Subscription and Table mappings required to support Shadow tables
    • Implement a User Maintained MQT for a column-organized table
    • Create optimization profiles that allow applications to control specific operations included in the access plans selected by the DB2 Optimizer, like which index is used to access a table or which join method to utilize for joining tables.
    • Perform advanced monitoring using the DB2 administrative views and routines in SQL queries.
    • Configure and manage the implementation of DB2 instance or database level auditing, including using the db2audit command and creation of audit policies which can be assigned to specific tables, users or database roles to perform selective collection of audit records.
    • Explore DB2 management of disk space usage in Database Managed Storage (DMS) table spaces, including the activities of the rebalancer. Use SQL queries and utilities to check the high water mark on table spaces and to monitor the rebalance operation.
    • Move data from one table to another or from one database to another using utilities like db2move.
    • Utilize the ADMIN_MOVE_TABLE procedure to implement table changes with a minimal impact to data availability for applications.
    • Implement automatic storage management for table spaces and storage groups or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity.
    • Exploit and monitor the REORG utility processing for offline and online table, and index reorganization This includes planning for the disk space and database log space necessary for reorganization.
    • Utilize the REORG Utility to implement row compression for large tables, to reduce disk utilization and improve I/O performance for a DB2 database and understand the automatic creation of compression dictionaries.
    • For Multidimensional Clustering (MDC) tables, determine how to select the dimension columns and table space extent size for efficient implementation of MDC tables. Compare the block indexes used with MDC tables with rows based indexes. Select the MDC rollout option that best matches application needs and achieves the best performance results.
    • Plan and implement range based table partitioning for large DB2 tables. Utilize the ALTER TABLE ATTACH and DETACH options to support roll-in and roll-out operations for range-partitioned tables. Compare the advantages of selecting or combining range partitioning with the hash-based partitioning used in DB2 partitioned databases or the multiple dimensions provided by MDC tables.
  • Out of stock
    Analytics and Data Training and Certification

    CL451G: DB2 11 BLU Acceleration Implementation and Use

    2 Days ILT, VILT

    The course is intended for Data Administrators that need to prepare for using the DB2 BLU Acceleration facilities of DB2 11.1 for Linux, UNIX and Windows systems.

    The concepts and facilities of the BLU Acceleration feature of DB2 11 are presented including loading data into column-organized tables and monitoring the processing of SQL statements that access the tables.

    The DB2 10.5 Fix Pack 4, referred to as Cancun, added support for Shadow tables, a new type of Materialized Query Table, and also Column-organized User Maintained MQT tables. One lecture unit describes these features. A demonstration allows students to implement and experiment with these functions.

    With DB2 11.1, BLU Acceleration can be used in a clustered multiple database partition DB2 environment. This course includes a lecture and demonstration that allows students to create a set of column-organized tables from an existing set of row-organized tables and execute and analyze the performance of BLU Acceleration in a MPP database.

    The lab demonstrations are performed using DB2 LUW 11.1 for Linux.

  • Analytics and Data Training and Certification

    CL413G: DB2 for LUW Performance Tuning and Monitoring Workshop

    RM5,180.00
    4 Days ILT, VILT

    Learn how to tune for optimum performance the IBM DB2 10 for Linux, UNIX, and Windows relational database management system and associated applications written for this environment. Learn about DB2 10 for Linux, UNIX, and Windows in a single partition database environment. Explore performance issues affecting the design of the database and applications using the database, the major database performance parameters, and the different tools that assist in performance monitoring and tuning.

    Use tools in class that are common across the Linux, UNIX, and Windows environments. During labs running on DB2 10.1, develop your ability to use monitoring tools. Explain tools and DB2 utilities like RUNSTATS, REORG and db2batch to tune a database running on your local LINUX workstation.

  • Analytics and Data Training and Certification

    CL213G: DB2 10 for LUW: Basic Administration for AIX

    RM6,240.00
    4 Days ILT, VILT

    This course teaches you to perform, basic database administrative tasks using DB2 10.1 for Linux, UNIX, and Windows. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. The access strategies selected by the DB2 Optimizer will be examined using the DB2 Explain tools.

    Various diagnostic methods will be presented, including using the db2diag.log file messages to direct your investigation of problems, as well as using the db2pd commands.

  • Analytics and Data Training and Certification

    CL207G: Db2 11.1 Administration Workshop for Linux

    Price range: RM3,360.00 through RM6,240.00
    4 Days ILT, VILT

    This course teaches database administrators to perform basic database administrative tasks using Db2 11.1. These tasks include creating database objects like tables, indexes and views, and loading data into the database with Db2 utilities like LOAD and INGEST. Various diagnostic methods will be presented, including using db2pd command options, and monitoring with SQL statements that reference Db2 monitor functions. Students will learn how to implement automatic archival for database logs and how to recover a database to a specific point in time using the archived logs.

    The course covers using EXPLAIN tools to review the access plans for SQL statements and adding indexes to improve SQL performance. We will cover the locking performed by Db2 and the effect the application isolation level has on locking and lock wait conditions. Students will learn how to implement database security, including adding a security administrator, SECADM user, and implement database roles to simplify security management. We will also describe implementing Db2 native encryption for a database.

  • Placeholder

    CE131G: IBM DB2 SQL Workshop for Experienced Users

    RM6,440.00
    3 Days ILT, VILT

    The CE131G: IBM DB2 SQL Workshop for Experienced Users course teaches you how to make use of advanced SQL techniques to access DB2 databases in different environments. This course is appropriate for customers working in all DB2 environments, specifically for z/OS, Linux, UNIX, and Windows.

  • Placeholder

    CE121G: IBM DB2 SQL Workshop

    RM4,850.00
    2 Days ILT, VILT

    This CE121G: IBM DB2 SQL Workshop course provides an introduction to the SQL language.

    This course is appropriate for customers working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for customers working in an Informix environment.

  • Analytics and Data Training and Certification

    CE031G: IBM DB2 Family Fundamentals

    Price range: RM504.00 through RM2,860.00
    2 Days ILT, VILT

    This course provides you with information about the functions of IBM’s DB2, a relational database manager which may be installed under a variety of operating systems on many hardware platforms.

    DB2 runs under the z/OS, VM, Linux, UNIX, and Windows operating systems, to name a few.

    The course includes discussion of how the DB2 products provide services. The focus is on the services DB2 provides and how we work with DB2, not on its internal workings.

  • Cybersecurity Training & Certification

    BQ203G: IBM QRadar SIEM Advanced Topics

    RM6,780.00
    2 Days ILT, VILT

    IBM QRadar SIEM provides deep visibility into network, user, and application activity. It provides collection, normalization, correlation, and secure storage of events, flows, assets, and vulnerabilities. Suspected attacks and policy breaches are highlighted as offenses.

    This 2-days BQ203G: IBM QRadar SIEM Advanced Topics course walks you through various advanced topics about QRadar such as custom log sources, reference data collections and custom rules, X-Force data and the Threat Intelligence app, UBA and QRadar Advisor, tuning and custom action scripts.

    The course also discusses integration with IBM SOAR. Hands-on exercises reinforce the skills learned.

  • Cybersecurity Training & Certification

    BQ104G: IBM QRadar SIEM Foundations

    RM3,969.00
    3 Days ILT, VILT

    IBM Security QRadar enables deep visibility into network, endpoint, user, and application activity. It provides collection, normalization, correlation, and secure storage of events, flows, assets, and vulnerabilities. Suspected attacks and policy breaches are highlighted as offenses. In this course, you learn about the solution architecture, how to navigate the user interface, and how to investigate offenses. You search and analyze the information from which QRadar concluded a suspicious activity. Hands-on exercises reinforce the skills learned.

    In this 3-day instructor-led course, you learn how to perform the following tasks:

    • Describe how QRadar SIEM collects data to detect suspicious activities
    • Describe the QRadar SIEM component architecture and data flows
    • Navigate the user interface
    • Investigate suspected attacks and policy breaches
    • Search, filter, group, and analyze security data
    • Investigate the vulnerabilities and services of assets
    • Use network hierarchies
    • Locate custom rules and inspect actions and responses of rules
    • Analyze offenses created by QRadar SIEM
    • Use index management
    • Navigate and customize the QRadar SIEM dashboard
    • Use QRadar SIEM to create customized reports
    • Use charts and filters
    • Use AQL for advanced searches
    • Analyze a real world scenario

    Extensive lab exercises are provided to allow students an insight into the routine work of an IT Security Analyst operating the IBM QRadar SIEM platform. The exercises cover the following topics:

    • Using the QRadar SIEM user interface
    • Investigating an Offense triggered by events
    • Investigating the events of an offense
    • Investigating an offense that is triggered by flows
    • Using rules
    • Using the Network Hierarchy
    • Index and Aggregated Data Management
    • Using the QRadar SIEM dashboard
    • Creating QRadar SIEM reports
    • Using AQL for advanced searches
    • Analyze a real-world large-scale attack

    The lab environment for this course uses the IBM QRadar SIEM 7.3 platform.

  • Placeholder

    B6290G: IBM Cognos Analytics: Modeling with Data Modules v11.1.x

    RM462.00
    1 Day ILT, VILT

    This training teaches data modelers how to model data using data modules in IBM Cognos Analytics. Users will learn how to create data modules from different sources, such as uploaded files. They will also identify how to customize their data modules by adding joins, calculations, and filters. In addition, they will examine how to group their data (for example, by using navigation paths), how to share their data modules with others, and how to make use of some advanced modeling techniques, such as relative date analysis.

    If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.

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