| OS/390 Managing DB2 Data
Warehouse
This course presents an overview of issues involved in managing
a data warehouse. It discusses inflowing data from a variety of
sources, converting and storing data, synchronizing data in a distributed
environment, and accessing data for decision-support.
Managing DB2 Data Warehouse training covers such topics as:
People
Monitoring the Data Warehouse
Populating the Data Warehouse
Managing the Data
Data Access
The course is designed for managers and technical professionals who are considering
implementing a data warehouse using DB2. Technical professionals will find
hints for designing and tuning DB2 for maximum performance in a data warehouse
environment. Managers will be interested in the presentation of issues and
strategies involved in managing a data warehouse.
OS/390 Managing DB2 Data Warehouse Everything OS/390
Description
This course presents an overview of issues involved in managing a data warehouse.
Included are discussions of inflowing data from a variety of sources, converting
and storing data, synchronizing data in a distributed environment, and accessing
data for decision-support.
Audience
The course is designed for managers and technical professionals who are considering
implementing a data warehouse using DB2. Technical professionals will find
hints for designing and tuning DB2 for maximum performance in a data warehouse
environment. Managers will be interested in the presentation of issues and
strategies involved in managing a data warehouse.
Prerequisites
As data warehousing is a multi-disciplinary undertaking, students will bring
varied backgrounds to the course, including database administration and systems
programming. A basic knowledge of DB2, SQL, and the OS/390 operating system
is assumed. This knowledge can be acquired through work experience, or through
the Course Technologies course OS/390 Introduction and OS/390 Designing the
DB2 Data Warehouse.
Course Duration
» 5 hours
Topics Include
Unit 1: People
» Data Warehousing
» The Development Team
» The Administration Team
» Users Unit 2: Monitoring the Data Warehouse
» Activity Monitor
» Data Monitor Unit 3: Populating the Data Warehouse
» Data Acquisition
» Managing Redundancy Everything Courseware OS/390 Managing DB2 Data Warehouse
Unit 4: Managing the Data
» Security
» Data Operations
» Performance Unit 5: Data Access
» Online Analytical Processing
» Data Mining
» Client Access |