Data Warehouse Design Tips - Self-Study Course

Data Warehouse Design Tips - Self-Study Course

Oracle University
Logo Oracle University

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

Students are introduced to the data warehouse environment in the context of the enterprise architecture. Students learn to identify each component of the architecture and its role in the overall system. Students learn how specific business needs can influence the data warehouse design, and also learn how to translate business issues into subject areas.
Audience
  • Data Warehouse Administrator
  • Database Administrators
  • Data Warehouse Developer
  • Data Warehouse Analyst

Course Topics Introduction to Data Warehouse Design Data Design in the Warehouse Architecture Business Processes in Data Warehouse Design Review of Data Modeling Metadata Management Identifying the Data Physical Data Model …

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Students are introduced to the data warehouse environment in the context of the enterprise architecture. Students learn to identify each component of the architecture and its role in the overall system. Students learn how specific business needs can influence the data warehouse design, and also learn how to translate business issues into subject areas.
Audience
  • Data Warehouse Administrator
  • Database Administrators
  • Data Warehouse Developer
  • Data Warehouse Analyst

Course Topics Introduction to Data Warehouse Design Data Design in the Warehouse Architecture Business Processes in Data Warehouse Design Review of Data Modeling Metadata Management Identifying the Data Physical Data Model Elements Data Warehousing Models Considerations for Physical Models Summary Tables Designing for Performance Database Sizing
Course Objectives
  • Review and describe the characteristics of a data warehouse
  • Describe all of the components of an enterprise architecture
  • Examine different data warehouse architectures
  • List various types of data that may be considered for the warehouse
  • Identify the requirements of a decision support query environment
  • Outline the steps to building a data warehouse
  • Describe how to determine the first increment according to the value proposition and return on investment
  • Know the different modeling techniques, specifically entity relationship modeling
  • Identify the modeling conventions and terminology used, specifically in the Oracle environment
  • Define metadata and describe why it is important to the warehouse and users
  • Identify types of metadata for every aspect of warehouse operation, management, and access
  • Identify the organizational and technical uses of metadata
  • Evaluate sources for metadata currently in your enterprise
  • Conduct gap analysis and appreciate where this occurs in the Data Warehouse Method

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.