Building The Data WareHouse Curriculum



Building The Data Warehouse Course Description

 

 

Course Introduction

Data Warehouse - the modern way to build systems is to separate the operational from the informational or analytical processing and data. Today we know with certainty the following:
·         Data warehouses are built under a different development methodology than applications. Not keeping this in mind is a recipe for disaster.
·         Data warehouses are fundamentally different from data marts. The two do not mix—they are like oil and water.
·         Data warehouses deliver on their promise, unlike many overhyped technologies that simply faded away.
·         Data warehouses attract huge amounts of data, to the point that entirely new approaches to the management of large amounts of data are required.

This course is discussions of specific technologies, about the analytical (the decision support systems (DSS)) environment and the structuring of data in that environment, and issues to a guideline for the designer and the developer.

Course Objectives

At the end of the course, students will be able to:
  • Explain the basic concepts underlying data warehouse
  • Design, develop and deploy data warehouse

Audience:

The course is appropriate for technical management, project advisors, technologists, designers, testers, and developers.

Prerequisites:

Participants should have a basic understanding of the Web, exposure to the software development process. 



Course Contents:

Chapter 1 Evolution of Decision Support Systems
Chapter 2 The Data Warehouse Environment
Chapter 3 The Data Warehouse and Design
Chapter 4 Granularity in the Data Warehouse
Chapter 5 The Data Warehouse and Technology
Chapter 6 The Distributed Data Warehouse
Chapter 7 Executive Information Systems and theData Warehouse
Chapter 8 External Data and the Data Warehouse
Chapter 9 Migration to the Architected Environment
Chapter 10 The Data Warehouse and the Web
Chapter 11 Unstructured Data and the Data Warehouse
Chapter 12 The Really Large Data Warehouse
Chapter 13 The Relational and the Multidimensional Models as a Basis for Database Design
Chapter 14 Data Warehouse Advanced Topics
Chapter 15 Cost-Justification and Return on Investment for a Data Warehouse
Chapter 16 The Data Warehouse and the ODS
Chapter 17 Corporate Information Compliance and Data Warehousing
Chapter 18 The End-User Community
Chapter 19 Data Warehouse Design Review Checklist
 

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

0 nhận xét:

Đăng nhận xét