EIEIOTECHNOVATION
← Training programmes

EIEIO / DATA SCIENCE

InfoSphere Change Data Capture Essentials

Course outline

KM0003 days

Duration

3 days

Course Description

This is the Classroom version of Instructor-Led Online course InfoSphere Change Data Capture Essentials - Instructor-Led Online (3M000), Self-Paced Virtual course IBM InfoSphere Change Data Capture Essentials V6.3 - SPVC (2I550) and Web-Based course IBM InfoSphere Change Data Capture Essentials V6.3 - Web Based (1I550).

This replaces course Change Data Capture (CDC) Essentials (DX550)

This course is designed to explain the basic concepts of data replication in InfoSphere Change Data Capture, discuss its features, teach how it is setup. It also intends to teach how to troubleshoot InfoSphere Change Data Capture and how to use it for everyday business use.

Audience

This basic course is for InfoSphere Change Data Capture Administrators, Database Administrators that uses InfoSphere Change Data Capture to replicate data to and from the databases they are responsible for. Database Analysts, System Administrators and Operators using InfoSphere Change Data Capture. Data Warehouse managers/designers.

Prerequisites

Before attending this course, students should have experience:

  • Basic use of a Microsoft Windows XP environment.
  • Basic database knowledge like designing a table, querying a database using SQL.

At Course Completion

After completing this course, you will be able to:

  • Be familiar with the features and concepts of Change Data Capture (CDC)
  • Be able to create subscriptions and utilize Source and subscriber-specific functionality
  • Know how to housekeep and monitor
  • Experience an introduction to problem solving and troubleshooting
  • Examine ways in which InfoSphere Change Data Capture can be used to address common business needs requiring data replication.

Course Outline

  • Introduction to InfoSphere Change Data Capture
  • InfoSphere CDC Features
  • Setting Up the ISCDC Environment
  • Looking at the ISCDC Replication Environment
  • The InfoSphere CDC Replication Types
  • InfoSphere CDC in Different Platforms
  • InfoSphere CDC Utilities
  • Troubleshooting ISCDC
  • InfoSphere CDC in the Real World
  • From Theory to Practice

Programme scope, delivery arrangements and suitability are confirmed during enquiry.