Provided by: Serebra Learning Corporation

OS 390 Designing DB2 Data Warehouse

Click here for more information or to take this course

home : Computer : Databases and SQL : DB2

Get More Information

Search for Training

Find Your Genius!

Training Provided by Serebra Learning Corporation

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 Dat 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.

Training Avaliability and Delivery

This is primarily online training
	This is an online eLearning or CBT training program
	Contact Serebra Learning Corporation for more information

Schedule:	5 hours
Training Presented in:	English

Related Keywords: mainframe ibm db2 warehouse os 390 designing data

Training Program Details

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.

Topics

Unit 1- Data Warehouse

What is a Warehouse?
Types of Warehouse
Warehousing Systems

Unit 2- Planning and Implementation

Implementing a Data Warehouse
Planning
Architecture

Unit 3- Data Models

Logical Data Models
Warehouse Data
The Physical Model

Unit 4- Data Acquisition

Data Extraction
Data Conversion <

Objectives

About Serebra Learning Corporation - Training Provider

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...

More IBM Training from Serebra Learning Corporation

Click here for more information or to take this course

Training Directory \| New Training Seminars \| New Training Providers \| Search \| Site Map \| Promote Training \| Login \| Links

	Training-Classes.com by Skillbox® 07/18/08 Copyright 1998-2008 skillbox, inc. All rights reserved

Are you a Mainframe training provider?

You could be on this page today - for FREE!