Data Warehouse Database Design

Course Fees: $1984.00 excl. GST
Printed Manual: $0.00 excl. GST
Course Duration: 2 days
Course Manual

Sorry, no course dates found

In this course, students are presented with the basic concepts, fundamental issues, and techniques for the design of a data warehouse or data mart. Students examine all phases and tasks of the data warehouse design process, including business modeling, entity relationship diagramming, dimensional modeling, physical modeling, and warehouse meta data management. Participants use a case study to apply these concepts and methods. Group discussions and practices are included.
Data Warehouse Administrator
Database Administrators
In-depth understanding of data warehousing concepts and familiarity with data modeling and relational database design
  • Describe the role of meta data in data warehouse design and strategies to define and maintain meta data
  • Use entity relationship diagrams to transform the business model into a dimensional model
  • Define the process of designing a data warehouse database model
  • Transform the dimensional model into a physical data design
  • Understand multidimensional query concepts
  • Evaluate summaries and understand the value of materialized views
  • Explain the central concepts of dimensional data models
  • Analyze and transform business requirements into a business model

Reviewing Data Warehouse Basics
Describing the features and characteristics of a data warehouse
Identifying the components and functionality of an Oracle data warehouse environment using the Common Warehouse Model

Defining the Business & Logical Models

Describing the enterprise level strategic analysis tasks
Defining components of business modeling

Creating the Dimensional Model

Describing attributes of a star model
Identifying fact tables and their attributes from business measure entities

Creating the Physical Model
Translating the dimensional model into a physical model
Discussing the architectural requirements for the data warehouse

Storage Considerations for the Physical Model
Explaining data warehouse sizing techniques and test load sampling
Describing data warehousing indexing types and strategies

Strategies for Extracting, Transforming, and Transporting
Outlining the extraction, transformation, and transportation processes for building a data warehouse
Identifying extraction, transformation, and transportation issues

Summary Management

Discussing summary management and Oracle implementation of summaries
Describing materialized views

Analytical Capabilities
Defining Business Intelligence (BI)
Understanding the categories of BI and their use within the data warehouse