|
Provided by: Serebra Learning Corporation IBM DB2 Universal Database V7.1 Transition Part 2: Business Intelligence and DB2 EnhancementsDB2 |
 |
Training
Provided by Serebra Learning Corporation
This is the second course in a two part series that students will be introduced to the concept of business intelligence. This course also covers administrative enhancements and it discusses DB2 family enhancements.
|
|
||||||||||
IBM DB2 Universal Database V7.1 Transition Part 2: Business Intelligence and DB2 Enhancements
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
Audience
The audience for this course includes database administrators application designers technical support and technical specialists who require information about the features and functions of DB2 UDB for Unix Windows and OS/2 V7.1.
Objective
- Identify the components of the data warehousing process.
- Identify the enhancements in Business Intelligence (BI) products available for DB2 version 7.1
- Identify the components of Visual Warehouse in DB2 version 6.1 and version 7.1.
- Identify the guidelines for enabling dynamic to static SQL conversion.
- Identify the modes of the conversion mechanism.
- Identify the features of the DB2 Capture Utility (DB2CAP).
- Identify the features of DB2 Everyplace.
- Identify the DB2 Connect enhancements.
- Identify the functions of DB2 connection concentration.
Topics Include
Unit 1: Business Intelligence
- Identify the components of the data warehousing process.
- Identify the enhancements in BI products available for DB2 version 7.1.
- Identify the components of Visual Warehouse in DB2 version 6.1 and version 7.1.
- Identify the main components of the process for populating the target database.
- Identify the data sources and target databases of data warehousing.
- Identify the characteristics of steps.
- Identify the characteristics of DB2 DataPropagator.
- Sequence the steps in DB2 replication integration.
- Identify the features of Control Databases in the warehouse environment.
- Identify benefits of the information catalog.
- Identify the features of the Data Warehouse Center.
- Identify the general and platform-specific features of DB2 version 7.1 Warehouse Manager.
- Identify the features of the Information Catalog Manager.
- Identify the features of the Query Management Facility (QMF).
- Identify features of the DB2 Query Patroller.
- Identify new features in warehousing.
Unit 2: Administrative Enhancements
- Identify the guidelines for enabling dynamic to static SQL conversion.
- Identify the functions of the DB2ckbkp utility.
- Identify the characteristics of a log flush.
- Identify the functions of filtered log recovery.
- Identify the new format extensions supported by the Import and Load utilities.
- Identify the features of identity column support.
- Identify the modes of the conversion mechanism.
- Identify the features of the DB2CAP.
- Identify the features of generated column support.
- Identify the factors to consider when using Load authority.
- Identify the features of the DB2batch command in parallel export.
- Identify the enhancements to replication.
- Identify the DB2 support features for Windows 2000.
- Identify the character lengths supported by DB2.
- Identify the consistency features of the DB2 family.
- Identify the performance and capacity enhancements for DB2 V7.1.
Unit 3: DB2 Family Enhancements
- Identify the features of DB2 Everyplace.
- Identify the DB2 Connect enhancements.
- Identify the functions of DB2 connection concentration.
- Identify the connection concentrator restrictions with DB2.
- Identify the additional DB2 Connect enhancements.
- Identify the DB2 for OS/390 functions incorporated into the Control Center.
- Identify the Data Links enhancements in DB2 version 7.1.
- Identify the additional Data Links enhancements to DB2 version 7.1.
- Identify the enhancements to satellite administration.
Duration
8
Minimum Requirements
The CDROM version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
- At least a double speed CDROM drive.
- An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM and 22MB available hard disk space or file server space.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
Media
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
