IBM DB2 Universal Database V7.1 Transition Part 1: Core Components

Rating:
Summary: IBM DB2 Universal Database V7.1 Transition Part 1: Core Comp
Review: 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.