Go BackData Warehousing: Management

Synopsis
Data Warehousing: Management provides an introduction to designing, building, and maintaining a data warehouse.

Audience
This course is for anyone who is interested in learning more about the use and administration of data warehouses.

Time
4 hours

Product Code: DWHC02
After completing Data Warehousing: Management, the user should be able to:

Identify warehouse requirements
Plan and create a data warehouse
Maintain a data warehouse
Choose warehouse features based on requirements
Provide the proper hardware and software support for a data warehouse
Match business requirements to warehouse features

Identifying Requirements
The end-user role
The designer role
The developer role

Designing and Implementing the Warehouse
Designing a data warehouse
Implementing a data warehouse
Deploying a data warehouse
Modifying the data warehouse
Refreshing the data warehouse

Maintaining a Data Warehouse
Managing size
Ensuring security
Monitoring performance

Matching Warehouses to Requirements
Corporate warehouses and data marts
Centralized and distributed data warehouses
The client/server model
Choosing a database

Supporting Warehouse Needs
Granularity levels
Partitioning of data
Storing data
Indexing and monitoring data

Business Management of Data Warehouses
Development issues
Resource and delivery issues
Training issues

This course has the following features:

A course index
A glossary
A Skill Assessment


 

Go Back