Audience
People who have a fairly good knowledge of the concepts of database systems, relational database management systems, and their architecture.
Topics
Introduction to Data Warehousing
- Existing Information Systems
- Data Warehousing Basics
- Quiz
Data Warehouse Structure
- Data Warehouse Components
- Types of Data Warehouses
- Data Models
- Quiz
Data Warehouse Environment
- Managing the Data Warehouse Environment
- Accessing a Data Warehouse
- Quiz
Objectives
Upon completion of this course, the student will be able to:
- Describe the existing information systems
- Describe the need for new information systems
- Define a data warehouse in terms of the characteristics that differentiate it from other information systems
- Describe the benefits of data warehousing
- Describe the structure of a data warehouse
- List the features of different types of warehouse data
- List the different types of data warehouses
- Describe the planning issues in using the different types of data warehouses
- Describe the different warehouse topologies
- Define types of data models in data warehouses
- Identify ways to synchronize data models in warehouse design
- Describe the four levels of the architected data warehouse environment
- Describe the operations in the architected data warehouse environment
- Choose an access tool
- Analyze user query requiremen