Data Warehouse Database Design
Currently, no providers in North America have scheduled a date for this course. We can schedule a class at one of our regional offices or on-site at your location.
- Vendor:
- Oracle Corporation
- Course:
- D70541GC10
- Start Date:
- Unscheduled
- Length:
- 2 Days
- Location:
- Expired Class Date
- Tuition:
- $1,300
No Dates
Scheduled
Course Description
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.A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.
Skills Gained
- 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
Who Can Benefit
- Data Warehouse Administrator
- Database Administrators
Prerequisites
- In-depth understanding of data warehousing concepts
- Familiarity with data modeling and relational database design
Syllabus
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
