This course teaches how to build QualityStage parallel jobs that investigate, standardize, match, and consolidate data records. Students will gain experience by building an application that combines customer data from three source systems into a single master customer record.
-
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.
-
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.
-
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).
-
In this course students learn how the Information Governance Catalog is used to govern information assets through the development of a governance catalog of categories and terms. This catalog documents information assets and governance policies and rules that implement the high-level strategy and objectives of a governance program.
-
The ZZ981G: InfoSphere MDM Physical Module Algorithms v11 course prepares you to work with and customize the algorithm configurations deployed to the InfoShere MDM Probabilistic Matching Engine (PME) for the Physical MDM implementation.
Learn about
- Information Management
- InfoSphere Master Data Management (MDM)
- InfoSphere Master Data Management
-
Out of stock
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.
-
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.
-
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.
-
Clustering and Association Modeling Using IBM SPSS Modeler (v18.1.1) introduces modelers to two specific classes of modeling that are available in IBM SPSS Modeler: clustering and associations. Participants will explore various clustering techniques that are often employed in market segmentation studies. Participants will also explore how to create association models to find rules describing the relationships among a set of items, and how to create sequence models to find rules describing the relationships over time among a set of items.
-
This ZZ820G: InfoSphere MDM Architecture v11 course is designed for anyone who wants to get an understanding of the InfoSphere MDM Architecture (including the Virtual and Physical Hubs). This course walks you through the major components of the InfoSphere MDM and how each component interacts. You will learn how InfoSphere MDM responds once a service is invoked and the various configuration and extension points of a service. The course is used as an introduction to various components that make up the MDM Architecture and prepares you to identify how MDM will fit into their organization and what pieces may be customized to fit their business requirements.
The next courses that may be of interest to you include:
- Data Model and Service Mapping for the InfoSphere MDM Advanced Edition V10 (ZZ610)
- Customizing the InfoSphere MDM Advanced Edition V10 (ZZ640)
- IBM InfoSphere MDM Server Service Customization for MDM Server 9 (ZZ340)
- InfoSphere MDM Server User Interface Generator (DC560)
-
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.
