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 study the issues involved in planning, designing, building, populating, and maintaining a successful data warehouse. Students learn the reasons why data warehousing is a compelling decision-support solution in today's business climate. During the course, students examine Oracle warehouse technology, and identify the technology available from Oracle Partners for designing, implementing, and running a data warehouse.

 

Course schedule

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

Who should attend

Database Administrators, Project Manager or Data Warehouse Administrator

Prerequisites

Introduction to Oracle9i: SQL or equivalent knowledge.

Course Outline

BUSINESS INTELLIGENCE & DATA WAREHOUSING
•  The road map to Business Intelligence (BI)
•  Data warehouses compared with Online Transaction Processing (OLTP)
•  Management information systems and decision support systems (DSS)
•  Business drivers for data warehouses
•  Typical uses of a data warehouse

DEFINING DATA WAREHOUSE CONCEPTS AND TERMINOLOGY
•  Common data warehouse definitions
•  Data warehouse properties and characteristics
•  Warehouse development approaches
•  Components of data warehouse design and implementation
•  Components of a data warehouse
•  Data warehouse compared with data mart
•  Dependent and independent data marts

PLANNING AND MANAGING THE DATA WAREHOUSE PROJECT
•  Managing financial issues
•  Obtaining business commitment
•  Gathering business and user requirements
•  Evaluating the warehouse project
•  Implementation processes and requirements

MODELING THE DATA WAREHOUSE
•  Data warehouse database design phases
•  Defining the business model
•  Choosing the architecture
•  Creating the dimensional model
•  Using time in the data warehouse
•  Using summary data
•  Query rewrite
•  Creating the physical model

BUILDING THE WAREHOUSE - EXTRACTING DATA
•  Extracting, transforming, and loading data
•  Examining data sources
•  Extracting data
•  Extraction techniques

BUILDING THE DATA WAREHOUSE - TRANSFORMING DATA
•  Transforming data: problems and solutions
•  Resolving quality data issues
•  Transformation techniques & tools

BUILDING THE DATA WAREHOUSE - LOADING WAREHOUSE DATA
•  Loading data into the warehouse
•  Building the loading process
•  Post-processing of loaded data
•  Verifying data integrity

REFRESHING WAREHOUSE DATA
•  Capturing and applying changed data
•  Batch load requirements
•  Limitations of methods in applying change
•  Purging and archiving data

LEAVING A METADATA TRAIL
•  Defining warehouse metadata
•  Developing a metadata strategy
•  Examining types of metadata
•  Metadata management tools
•  Common warehouse metadata

MANAGING THE DATA WAREHOUSE
•  Managing the transition to production
•  Managing growth
•  Managing backup and recovery
•  Identifying data warehouse performance issues

 

 
 


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