IBM Data and Analytics Certification Training - Page 2 of 5 - IT Training and Certification

J4258G: IBM Cognos Analytics: Author Reports Fundamentals v11.1.x

RM3,150.00

3 Days SPVC

This course provides authors with an introduction to build reports using Cognos Analytics. Techniques to enhance, customize, and manage reports will be explored. Activities will illustrate and reinforce key concepts during this learning opportunity.

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.

J4255G: IBM Cognos Analytics: Enterprise Administration v11.1.x

RM2,646.00

2 Days SPVC

This offering covers the fundamental concepts of installing and configuring IBM Cognos Analytics, and administering servers and content, in a distributed environment. In the course, participants will identify requirements for the installation and configuration of a distributed IBM Cognos Analytics software environment, implement security in the environment, and manage the server components. Students will also monitor and schedule tasks, create data sources, and manage and deploy content in the portal and IBM Cognos Administration.

J4252G: IBM Cognos Framework Manager: Design Metadata Models v11.1.x

RM4,200.00

4 Days SPVC

This offering provides participants with introductory to advanced knowledge of metadata modeling concepts, and how to model metadata for predictable reporting and analysis results using IBM Cognos Framework Manager. Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing of metadata to the web, enabling end users to easily author reports and analyze data.

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.

J4159G: IBM Cognos Analytics: Author Reports Advanced v11.0.x

RM2,100.00

2 Days SPVC

This offering teaches Professional Report Authors about advanced report building techniques using relational data models, dimensional data, and ways of enhancing, customizing, managing, and distributing professional reports. The course builds on topics presented in the Fundamentals course. Activities will illustrate and reinforce key concepts during this learning activity.

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.

J4158G: IBM Cognos Analytics: Author Reports Fundamentals v11.0.x

RM3,150.00

3 Days SPVC

This offering provides Business and Professional Authors with an introduction to report building techniques using relational data models. Techniques to enhance, customize, and manage professional reports will be explored. Activities will illustrate and reinforce key concepts during this learning opportunity.

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

J4152G: IBM Cognos Framework Manager: Design Metadata Models v11.0.x

RM4,200.00

4 Days SPVC

This offering provides participants with introductory to advanced knowledge of metadata modeling concepts, and how to model metadata for predictable reporting and analysis results using Framework Manager. Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing of metadata to the web, enabling end users to easily author reports and analyze data.

Contains PDF course guide, as well as a lab environment where students can work through demonstrations and exercises at their own pace.

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.

J4098G: IBM Cognos Analytics – Author Active Reports v11.0

RM1,470.00

1 Day SPVC

This J4098G: IBM Cognos Analytics – Author Active Reports v11.0 course provides participants with an understanding of Active Report content and functionality within IBM Cognos Analytics – Reporting. Through lecture, demonstrations, and exercises, participants increase their IBM Cognos Analytics experience by building highly interactive reports using Active Report controls, which can then be distributed to and consumed by users in a disconnected environment, including on mobile devices.

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

J4063G: IBM Cognos Cube Designer – Design Dynamic Cubes v11.0

2 Days SPVC

This course provides participants with introductory to advanced knowledge of how to model metadata for predictable reporting and analysis results using IBM Cognos Cube Designer. Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing a dynamic cube, and enabling end users to easily author reports and analyze data.

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. http://www.ibm.com/training/terms

J4061G: IBM Cognos Analytics – Author Reports with Multidimensional Data v11.0

RM1,680.00

2 Days SPVC

This course is designed to guide report authors in building on their expertise with IBM Cognos Analytics by applying dimensional techniques to reports. Through interactive demonstrations and exercises, participants will learn how to author reports that navigate and manipulate dimensional data structures using the specific dimensional functions and features available in IBM Cognos Analytics.

Out of stock

J4019G: IBM Cognos Analytics: Architecture and Logging v11.0

2 Days SPVC

This course is designed to teach participants how to identify components and sub-components of the IBM Cognos Analytics architecture and how to use tools and techniques to provide a foundation to troubleshoot issues. Through lecture and interactive exercises participants will identify IBM Cognos Analytics components, examine how these components interact with Java, and will explore logging to assist when troubleshooting issues.

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. http://www.ibm.com/training/terms

Out of stock

J4008G: Overview of IBM Cognos Analytics v11.0

1 Day SPVC

This course provides participants with a high level overview of the IBM Cognos Analytics suite of products and their underlying architecture. They will examine each component as it relates to an Analytics solution. Participants will be shown a range of resources to provide additional information on each product.

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. http://www.ibm.com/training/terms

J1362G: IBM Planning Analytics: Design and Develop Models in Planning Analytics Workspace v2.x

RM5,250.00

5 Days SPVC

This J1362G: IBM Planning Analytics: Design and Develop Models in Planning Analytics Workspace v2.x course is designed to teach modelers how to build a complete model in IBM Planning Analytics using Planning Analytics Workspace. Through a series of lectures and hands-on exercises, students will learn how to set up dimensions and cubes, manually enter data into these structures, and define the data that users can see.

Students will also learn how to transfer data into the IBM Planning Analytics model, including the use of TurboIntegrator scripts to perform data transfer. In addition, the course outlines how to customize drill paths, convert currencies, and model for different fiscal requirements.

J1357G: IBM Planning Analytics: Analyze Data and Create Reports v2.0.x

RM2,100.00

2 Days SPVC

This J1357G: IBM Planning Analytics: Analyze Data and Create Reports course is designed to teach analysts how to use IBM Planning Analytics to analyze data to discover trends and exceptions, create and customize reports and templates, and contribute data to plans. Through a series of lectures and hands-on activities, you will learn how use Planning Analytics Workspace and Planning Analytics for Microsoft Excel to create analyses, enter data, create custom views and dashboards, and build formatted reports and forms.

J1222G: IBM Cognos Controller: Author Reports v10.2/v10.3

RM1,260.00

1 Day SPVC

This J1222G: IBM Cognos Controller: Author Reports course teaches authors, with basic knowledge of group accounting and Microsoft Excel, how to design and generate financial reports using IBM Cognos Controller. Students will learn how to create ad hoc and standard reports to analyze data. They will also develop custom reports using the Report Generator utility and the Excel Link. In addition, students will learn how to run multiple reports at the same time with report books.

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.

J1221G: IBM Cognos Controller: Develop Application B161v10.2/v10.3

RM3,570.00

5 Days SPVC

This course teaches application developers how to set up a Controller application and effectively use Controller in their organization’s consolidation process. Students will also design and generate financial reports using Controller. Through a series of lectures and hands-on exercises, students will set up a Controller application by creating the necessary structures (such as accounts and companies), and then test the application to ensure that it works properly. Students will also learn how to work with currency translation, allocations, intercompany transactions, investments in subsidiaries, advanced formula calculations, and user-defined business rules, as well as define configuration settings and user access to the application.

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

CV964G: Db2 12 for z/OS SQL Performance and Tuning

RM5,440.00

3 Days ILT, VILT

This CV964G: Db2 12 for z/OS SQL Performance and Tuning course is designed to teach the students how to prevent SQL performance problems and how to improve the performance of existing SQL.

CV963G: DB2 11 for z/OS Application Performance and Tuning

RM8,630.00

5 Days ILT, VILT

This Application Performance and Tuning course is designed to teach the students how to prevent application performance problems and to improve the performance of existing applications. Students will learn about indexes, table design, locking, and other issues relevant to application performance. This course includes paper exercises and machine exercises designed to reinforce the lecture content.

CV880G: Db2 12 for zOS Advanced Database Administration

RM3,845.00

2 Days ILT, VILT

This course will introduce the student to advanced database administration skills, including program preparation and the use of packages, online schema changes, partition management, and stored procedures; as well as performance and availability features of utilities (including LOAD, REBUILD INDEX, REORG, and UNLOAD). This course does not cover distributed data processing, nor does it cover data sharing.

CV871G: DB2 10 for z/OS Utilities for Database Administrators

RM5,440.00

3 Days ILT, VILT

This CV871G: DB2 10 for z/OS Utilities for Database Administrators course is designed to teach you advanced topics about DB2 for z/OS utilities. It is assumed that you attended course DB2 10 for z/OS Database Administration Workshop Part 1 (CV831) so that you already have basic skills about the main utilities. Recovery-oriented topics are not part of this course, so such utility functions are not presented.

CV862G: DB2 11 for zOS Implementation Workshop

RM8,630.00

5 Days ILT, VILT

This course is for installers of DB2 10 z/OS and/or migration to DB2 11 for z/OS using the Install CLIST. The participants are involved in lectures that explain DB2 11 components and pointers, and the processes used to install or migrate from DB2 10 for z/OS. To reinforce the lectures, a series of labs are provided to give each participant hands-on experience installing DB2 10 for z/OS and migrating to DB2 11 for z/OS.

CV853G: Db2 12 for z/OS Introduction to System Administration

RM5,440.00

3 Days ILT, VILT

This CV853G: Db2 12 for z/OS Introduction to System Administration course provides students with an introduction to the skills and knowledge needed to administer a Db2 12 for z/OS system.

CV852G: DB2 11 for zOS System Administration

RM12,000.00

5 Days ILT, VILT

Administrators of DB2 11 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 11 for z/OS subsystem. Engage in lectures and hands-on labs to gain experience to:

Relate the z/OS IPL process to a DB2 subsystem
Explain effects of stopping and starting DB2
Explain how DB2 sets and use Integrated Catalog Facility (ICF) catalog names
The use of DSN command processor running in batch and foreground
Use views to minimize users’ ability to see into the DB2 catalog
See how the catalog (through grant activity) controls access to data
Search the catalog for problem situations
Use the catalog and DB2 utilities to determine data recovery requirements
Describe Internal Resource Lock Manager (IRLM) in a DB2 environment
Implement DB2 and Resource Access Control Facility (RACF) security
Describe DB2 program flow for all environments
Display normal and problem threads and database status
See how the SQL Processor Using File Input (SPUFI) AUTOCOMMIT option defers the COMMIT/ROLLBACK decision
Interpret lock displays
Identify and cancel particular threads
Describe available DB2 utilities to manage system and user page sets

CV851G: IBM DB2 10 for z/OS System Administration

RM8,630.00

5 Days ILT, VILT

The course is updated for DB2 10 for z/OS. This course is the classroom delivered version of the Instructor led Online course

DB2 10 for z/OS System Administration – ILO (3V851).

Administrators of DB2 10 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 10 for z/OS subsystem. Engage in lectures and hands-on labs to gain experience to:

Relate the z/OS IPL process to a DB2 subsystem
Explain effects of stopping and starting DB2
Explain how DB2 sets and use Integrated Catalog Facility (ICF) catalog names
The use of DSN command processor running in batch and foreground
Use views to minimize your ability to see into the DB2 catalog
See how the catalog (through grant activity) controls access to data
Search the catalog for problem situations
Use the catalog and DB2 utilities to determine data recovery requirements
Describe Internal Resource Lock Manager (IRLM) in a DB2 environment
Implement DB2 and Resource Access Control Facility (RACF) security
Describe DB2 program flow for all environments
Display normal and problem threads and database status
See how the SQL Processor Using File Input (SPUFI) AUTOCOMMIT option defers the COMMIT/ROLLBACK decision
Interpret lock displays
Identify and cancel particular threads
Describe available DB2 utilities to manage system and user page sets

CV844G: Db2 12 for z/OS Basic Database Administration

RM5,440.00

3 Days ILT, VILT

This course will expose the beginning z/OS DBAs (Database Administrators) to fundamentals of Database Administration for a Db2 12 for z/OS. This course will teach the students how to physically implement a logical database design using DDL, and teaches considerations of referentially related tables. This course discusses the use of basic utilities, program preparation, serialization, and basic database security. This course does not cover distributed data processing, nor does it cover data sharing.

CV843G: DB2 11 for zOS Database Administration Workshop Part 2

RM5,440.00

3 Days ILT, VILT

This course teaches database administrators various features they must be familiar with as DB2 11 for z/OS Database Administrators. These include program preparation, online schema changes, user defined functions, archive-enabled and temporal tables, partition management, stored procedures, and triggers. The course includes many hands-on demonstrations which give the students experience with the included topics. Additionally, there is information on other features in the course appendices, including schemas and user defined data types, clone tables, materialized query tables, large objects, global variables, and row permissions and column masks. This course is a follow-on course to CV832 IBM DB2 11 for z/OS Database Administration Workshop Part 1. Note: This course is 3 days in length. If the instructor has time, he can cover the optional appendices as desired.

CV842G: IBM DB2 10 for z/OS Database Administration Part 2

RM5,440.00

3 Days ILT, VILT

This course is a continuation of course DB2 10 for z/OS Database Administration Workshop Part 1 (CV831) and is designed to teach you how to perform additional database administration tasks.

This course replaces DB2 for z/OS Database Administration Workshop Part 2 (CV841). This is the Classroom version of Instructor-led online course DB2 10 for z/OS Database Administration Part 2 – ILO (3V842).

CV832G: DB2 11 for z/OS Database Administration Workshop Part 1

RM8,630.00

5 Days ILT, VILT

This CV832G: DB2 11 for z/OS Database Administration Workshop Part 1 course provides you with instruction on how to physically implement a logical database design in DB2. The course includes instruction on DB2 data management, DB2 catalog tables, the bind process, database utilities such as LOAD and REORG, and security considerations.

Note: This course material is at the DB2 11 for z/OS level.

Cloud Computing Training & Certification

CV722G: DB2 11 for z/OS Application Programming Workshop

RM5,440.00

3 Days ILT, VILT

This course enables you to acquire the skills necessary to produce application programs that manipulate DB2 databases. Emphasis is on embedding Structured Query Language (SQL) statements and preparing programs for execution.

CV320G: New Functions and Features in DB2 11 for z/OS

RM3,960.00

3 Days ILT, VILT

Learn about the new features and enhancements of DB2 11 for z/OS, including the technical detail of the functional enhancements of this significant new version of DB2 for z/OS.

Note: This course shall be made available a unit at a time. If you wish to receive training on this new version of DB2 11 for z/OS, contact your training provider to request a class containing the latest content.

CV041G: z/OS and DB2 Basics for DB2 for z/OS DBA Beginners

RM8,630.00

5 Days ILT, VILT

DB2 11 for z/OS beginning DBAs can develop fundamental skills or recognition through lectures and hands-on exercises of:

TSO/E and ISPF
Data sets
DB2 Objects
Structured Query Language
DB2 Commands
JCL and SDSF
DB2 Utilities
DB2 Logging
DB2 Program Preparation

The course materials cover DB2 11 for z/OS.

CV021G: Introduction to DB2 for z/OS for Systems and Operations Personnel

RM5,440.00

3 Days ILT, VILT

DB2 11 for z/OS beginning DBAs can develop fundamental skills or recognition through lectures and hands-on exercises of:

DB2 Objects
Structured Query Language
DB2 Commands
DB2 Utilities
DB2 Logging
DB2 Program Preparation

The course materials cover DB2 11 for z/OS.

Out of stock

CL810G: Db2 11.1 HADR Workshop

1 Day ILT, VILT

This course teaches database administrators how to plan, implement and manage Db2 11.1 databases using the High Availability Disaster Recovery HADR) feature. The lectures cover the processing performed for a Db2 Primary and Standby Db2 database. The Db2 database configuration options that define and control the HADR function are covered. The option to define and operate multiple HADR standby databases will be explained. The course also covers the special considerations for allowing read only access by applications to a HADR Standby database. Students will learn the Db2 commands like TAKEOVER, START HADR and STOP HADR that are used to control HADR primary and standby database activity. The monitoring for HADR status of the primary and standby databases using the db2pd commands will be presented. The course also presents usage of HADR with Db2 pureScale databases.

Out of stock

CL801G: DB2 10.5 pureScale Implementation and Management for DB2 LUW Administrators

3 Days ILT, VILT

This course is designed to prepare DB2 Linux, UNIX and Windows database administrators for planning, installing, managing and monitoring a DB2 pureScale database system. This course covers the features and functions of the DB2 pureScale feature for DB2 10.5, including fixpack levels 4 and 5. This is a lecture-only course.

CL487G: Db2 11.1 Quickstart for Experienced Relational DBAs

RM6,240.00

4 Days ILT, VILT

This CL487G: Db2 11.1 Quickstart for Experienced Relational DBAs 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.

Out of stock

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

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.

Unlock the value of your data in new ways and accelerate your journey with IBM Data and Analytics.

Unlock the value of your data in new ways and accelerate your journey with IBM Data and Analytics.

IBM Data & Analytics Training and Certification.

Unify access to all data across your organization

Rethink workflows and improve outcomes with IBM Watson.

Scale AI to accelerate digital transformation

IBM Data & Analytics: The Key to Harnessing the Power of AI

Frequently Asked Questions

Stay connected. Be the first to know.

Company

Customer Service

Principals

Stay connected. Be the first to know.

Trainocate: A Global Leader in Technology, Business, and People Development