| OS/390 Designing DB2 Data Warehouse
This course is an overview of IBM's DB2 mainframe relational database
management system. It explains basic functions, features and elements
of DB2 for OS/390 within the MVS environment. Become familiar with
the basic elements of the DB2 database management system from both
a conceptual and physical perspective and learn about relational
databases, DB2 database objects, and common SQL. Learn to set up
and maintain a database, and access DB2 data interactively and
through applications. The course also covers the fundamentals of
database management, including security, data control and recovery,
and monitoring of the system.
Designing DB2 Data Warehouse training covers such topics as:
Data Warehouse
Planning and Implementation
Data Models
Data Acquisition
Metadata
OS/390 Designing DB2 Data Warehouse Everything OS/390
Description
This course is an overview of IBM's DB2 mainframe relational database management
system. It explains basic functions, features and elements of DB2 for OS/390
(known simply as DB2) and its interactions with the MVS environment. The course
briefly reviews the development of DB2, including enhancements to Version 6,
DB2 Universal Database for OS/390. It then familiarizes the student with the
basic elements of the DB2 database management system, from both a conceptual
and physical perspective. The discussion includes significant characteristics
of relational databases, DB2 database objects, and common SQL that is run in
a relational database management environment. The course walks the student through
basic functions: setting up and maintaining a database, and accessing DB2 data
interactively and through applications. Finally, it covers the fundamentals of
database management, including security, data control and recovery, and monitoring
the system. This course is written to OS/390 2.x and DB2 Universal Database for
OS/390 version 6.
Audience
Designed for managers and technical professionals who are implementing a data
warehouse using DB2. Technical professionals will find hints for designing and
tuning DB2 in a data warehouse environment. Managers will be interested in the
presentation of issues, choices and strategies that are available when implementing
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 and SQL is assumed. This knowledge can
be acquired through work experience.
Course Duration
»
5 hours
Topics Include
Unit 1: Data Warehouse
»
What is a Warehouse?
»
Types of Warehouse
»
Warehousing Systems Unit 2: Planning and Implementation
»
Implementing a Data Warehouse
»
Planning
»
Architecture Everything Courseware OS/390 Designing DB2 Data Warehouse Unit
3: Data Models
»
Logical Data Models
»
Warehouse Data
»
The Physical Model Unit 4: Data Acquisition
»
Data Extraction
»
Data Conversion
»
Data Loading Unit 5- Metadata
»
Getting Metadata
»
Improving Metadata
|