Menu

You searched for: ""

  • Placeholder

    2L487G: Db2 11.1 Quickstart for Experienced Relational DBAs

    RM3,360.00
    4 Days SPVC

    This course teaches you to perform, basic and advanced, database administrative tasks using Db2 11.1. 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 various db2pd command options. Students will learn how to implement automatic archival for database logs and how to plan a redirected database restore to relocate either selected table spaces or an entire database. The REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces, will be discussed. We will also cover using the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. The selection of indexes to improve application performance and the use of SQL statements to track database performance and health will be covered. This course provides a quick start to Db2 database administration skills for experienced relational Database Administrators (DBA).

    The lab demonstrations are performed using DB2 LUW 11.1 for Linux. For some lab tasks, students will have the option to complete the task using a DB2 command line processor, or using the graphical interface provided by IBM Data Server Manager.

    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.

  • Placeholder

    2L464G: Db2 11.1 Advanced Database Administration

    RM1,680.00
    2 Days SPVC

    This 2L464G: Db2 11.1 Advanced Database Administration 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.

    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.

  • Placeholder

    2L451G: DB2 11 BLU Acceleration Implementation and Use

    RM1,680.00
    2 Days SPVC

    The 2L451G: DB2 11 BLU Acceleration Implementation and Use 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.

    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.

  • Placeholder

    2E121G: SQL Workshop

    RM1,428.00
    2 Days SPVC

    This 2E121G: SQL Workshop course provides an introduction to the SQL language. This course is appropriate for those working in all DB2 environments, but particularly for, z/OS, Linux, UNIX, and Windows.

    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.

  • Placeholder

    1Z802G: IBM InfoSphere Master Data Management Fundamentals v11.6

    RM462.00
    1 Day VILT

    This course will build a foundation for students interested in what master data is and how it is managed. The student will learn about master data management (MDM), MDM implementation styles, and a variety of MDM use cases. The student will then be introduced to multiple IBM MDM solutions and will gain an understanding of the capabilities of each solution.

    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.

  • Out of stock
    Placeholder

    1X101G: Introduction to Informix Terminology and Data Types v12.10

    1 Day WBT

    This coure is a prerequisite for the IX224 Database Administration course.  It introduces students to basic Informix terminology, system access, and data types.

    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.

  • Analytics and Data Training and Certification

    1W730G: IBM Integrated Analytics System (IIAS) for Administrators v1.0

    RM462.00
    1 Day SPVC

    This 1W730G: IBM Integrated Analytics System (IIAS) for Administrators v1.0 course provides participants with advanced administration skills for IBM Integrated Analytics System.

    This course is designed to give participants an overview of the IIAS system, show how to administer the system using the console and command line interface, and extend the appliance. Participants will also monitor the system and performance in addition to managing users and security.

    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.

  • Analytics and Data Training and Certification

    1W720G: IBM Integrated Analytics System (IIAS) for Data Engineers v1.0

    RM462.00
    1 Day SPVC

    This course teaches data engineers how to build a robust, fault-tolerant data pipeline that cleans, transforms, and aggregates unorganized and messy data into databases or datasources for IBM Integrated Analytics System. This course is designed to give the participant an overview of the IBM Integrated Analytics System architecture and provide a working knowledge and understanding of the SQL and data engineering best practices.

  • Analytics and Data Training and Certification

    1W710G: IBM Integrated Analytics System (IIAS) for Data Scientists v1.0

    RM462.00
    1 Day SPVC

    This course teaches data scientists how to use the data science capabilities of IBM Integrated Analytics System, using Watson Studio, RStudio, Spark, and in-database analytics.

  • Placeholder

    1V500G: Introduction into the IBM DB2 Analytics Accelerator – Handling Table

    RM462.00
    1 Day SPVC

    This official web-based IBM DB2 Analytics Accelerator course provides training in the basics of the IBM DB2 Analytics Accelerator. The course introduces the student to the product layout and functionality and describes the various ways of storing DB2 data in IBM DB2 Analytics Accelerator. In addition to IBM DB2 Analytics Accelerator, it will also teach the student how to set up and work with the IBM Data Studio Accelerator Suite. The demonstrations will explore how tables can be loaded into IBM DB2 Analytics Accelerator, how to predict if tables could run on the accelerator using special register settings, why queries may not be candidates for the accelerator, how to disable or remove tables from the Accelerator, and finally, demonstrate the monitoring feature that is built-into the accelerator studio view.

    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.

  • Placeholder

    1M424G: IBM InfoSphere DataStage v11.5 Data Masking

    RM462.00
    0.5 Days SPVC

    Students will describe how the Data Masking Pack works; understand how to apply policies for different data types, understand how hash lookup policies work; create a data masking job.

    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

  • Out of stock
    Placeholder

    1E031G: DB2 Family Fundamentals

    2 Days WBT

    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.

    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.

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 2024. All rights reserved. IT Training Provider Malaysia
Go to Top