IBM DB2 V7.1 Transition Curriculum CBT Training CDs

Rating:
Summary: IBM DB2 V7.1 Transition Curriculum CBT Training CDs
Review: Course Overview
In this curriculum the following topics will be covered, OLAP functionality, SQL and AD Enhancements, Federated Databases and Extenders. Additionally, learners will be introduced to the concept of business intelligence, administrative enhancements, and DB2 family enhancements. This curriculum consists of two courses: Course 13434 IBM DB2 Universal Database V7.1 Transition Part 1: Core Components Course 13435 IBM DB2 Universal Database V7.1 Transition Part 2: Business Intelligence and DB2 Enhancements

Learn To
See individual course descriptions for specific course objectives and scope.

Audience
The audience for this curriculum 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.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits Per Course
CEU credits: 1.60 CEUs

Language Options
US English

Total Learning Time
16 hours


IBM DB2 Universal Database V7.1 Transition Part 1: Core Components
Course Overview
This is the first course in a two part series that students will learn about OLAP functionality, SQL and AD Enhancements. Additionally, this course covers Federated Databases and Extenders and what has been added in these areas.

Learn To
# Identify the enhancements that emerged with each version of DB2.
# Identify the six main product editions of the DB2 family.
# Identify the optional tools of the DB2 family.
# Identify the techniques of multidimensional data analysis.
# Identify the functions of the star schema model.
# Identify the new OLAP SQL functions in DB2 version 7.1.
# Identify the features of declared temporary tables.
# Identify the factors to consider when using declared temporary tables.
# Identify the way in which savepoints control the outcome of transactions.
# Identify the new features of federated databases.
# Identify the new features of the SQL Explain utility.
# Identify changes in the Control Center, db2look, and Database System Monitor utilities.


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.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.80 CEUs

Language Options
US English

Total Learning Time
8 hours

Objectives
Unit 1: New Core Components and Enhancements 2 hours
# Identify the enhancements that emerged with each version of DB2.
# Identify the six main product editions of the DB2 family.
# Identify the optional tools of the DB2 family.
# Identify the DB2 packages that support application development.
# Identify the DB2 packages that support client connectivity.
# Identify the DB2 enhancements used to leverage information.
# Identify the elements of data management.


Unit 2: OLAP Functionality 2 hours
# Identify the techniques of multidimensional data analysis.
# Identify the functions of the star schema model.
# Identify the new OLAP SQL functions in DB2 version 7.1.
# Sequence the stages in creating a star schema by using the Warehouse Schema Modeler tool.
# Identify features of the OLAP Server.
# Identify the features of DB2 OLAP Integration Server.


Unit 3: SQL and AD Enhancements 2 hours
# Identify the features of declared temporary tables.
# Identify the factors to consider when using declared temporary tables.
# Identify the way in which savepoints control the outcome of transactions.
# Identify the factors to consider when using savepoints.
# Identify column definitions supported in DB2.
# Identify the characteristics of identity columns.
# Identify the factors to consider when using identity columns.
# Identify the guidelines for using generated columns.
# Identify the features of structured type columns.
# Identify functions of the user-defined extended index type.
# Identify the enhancements to summary tables and native object linking and embedding (OLE) database support in DB2 version 7.1.
# Identify the features of a CREATE PROCEDURE statement for an SQL procedure.
# Identify the functions of SQL procedure body statements that existed prior to DB2 version 7.1.
# Identify the functions of SQL procedure body statements that are new to DB2 version 7.1.
# Sequence the steps to create SQL procedure steps.
# Identify the characteristics of the DB2 productivity tools.
# Identify the guidelines for migrating stored procedure language.
# Identify the rules for creating SQL user-defined functions (UDF's).
# Identify the characteristics of the xa-open string.


Unit 4: Federated Databases and Extenders 2 hours
# Identify the new features of federated databases.
# Identify the new features of the SQL Explain utility.
# Identify changes in the Control Center, DB2look, and Database System Monitor utilities.
# Identify the benefits of DB2 DataJoiner.
# Identify the characteristics of XML.
# Identify the features of XML Extender.
# Identify the features of DB2 Net Search Extender.
# Identify the administrative tasks accomplished by DB2 Net Search Extender.
# Identify the features of DB2 Spatial Extender.


IBM DB2 Universal Database V7.1 Transition Part 2: Business Intelligence and DB2 Enhancements
Course Overview
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.

Learn To
# 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.


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.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.80 CEUs

Language Options
US English

Total Learning Time
8 hours

Objectives
Unit 1: Business Intelligence 3 hours
# 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 3 hours
# 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 2 hours
# 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.