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.

Database Administrators, Project Manager or Data Warehouse Administrator

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