INFORMIT logo
InformIT Home About InformIT Oracle Workforce Development Program Cisco Networking Academy Program Microsoft IT Training & Certification Other Intensive Training International IT Certifications
ABOUT
 
 ORACLE 10g
 
  10g DBA Track  
  10g iDS Track  
  10g Java Develop. Track  
  10g App. Server Track  
 
ORACLE 9i
 
  9i DBA Track  
  9i iDS Track  
  9i J2EE Java Develop. Track  
  9i AS Web Adm. Track  
 
Oracle Data Warehouse
 
   
   
     
  ORACLE CERTIFICATION  
  ORACLE UNIVERSITY  
     
   
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 
 

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.

 

Course schedule

Duration: 12 hours
To view the schedule for this class, click here.

Who should attend

Database Administrators and Data Warehouse Administrator

Prerequisites

•  Oracle Data Warehousing Fundamentals
. or equivalent knowledge of data warehousing concepts

Course Outline

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

 

 
 


INFORMIT - Skill Development Center
Jl. Purnawarman 9c, Bandung 40117- Phone (022) 4224 168 / 4223 168
Fax. (022) 4231 168 - E-mail: info@informit.tc

 
  Home | About Us | Oracle | Cisco | Microsoft | Other Training | Certification | Training Calendar  
© 2006, InformIT Ganesa Pratama. All Right Reserved