Data Warehousing Fundamentals

start > courses and registration > training feature sheet

code.

DATA-WARE-FUND

length.

2 days

type.

Instructor-Led

partner.

Oracle

price.

$1,200 :: contact for GSA GOV.

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.

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

who can benefit

Data Warehouse Administrator
Database Administrators
Project Manager

prerequisites

Introduction to Oracle9i: SQL

skills gained

	Describe methods and tools for accessing and analyzing warehouse data
	Define the decision-support purpose and end goal of a data warehouse
	Explain the implementation and organizational issues surrounding a data warehouse project
	Describe the various technologies required to implement a data warehouse

suggested next courses:

	Oracle9iAS Release 2: Discoverer for End Users
	Oracle9i Database Administration Fundamentals I
	Data Warehouse Database Design
	Oracle9i Database: Program with OLAP DML

related courses:

Data Warehousing Fundamentals Self-Study CD Course

related courses, exams and materials

	before related training and products

Introduction to Oracle9i: SQL

	after related training and products

	Oracle9i Database Administration Fundamentals I
	Oracle9iAS Release 2: Discoverer for End Users

course content details

	Lesson One: Business Intelligence and 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

	Lesson Two: 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

	Lesson Three: 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

	Lesson Four: 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

	Lesson Five: Building the Warehouse - Extracting Data

	Extracting, transforming, and loading data
	Examining data sources
	Extracting data
	Extraction techniques

	Lesson Six: Building the Data Warehouse - Transforming Data

	Transformation
	Transforming data: problems and solutions
	Resolving quality data issues
	Transformation techniques
	Transformation tools

	Lesson Seven: Building the Data Warehouse - Loading Warehouse Data

	Loading data into the warehouse
	Building the loading process
	Loading the data
	Post-processing of loaded data
	Verifying data integrity

	Lesson Eight: Refreshing Warehouse Data

	Capturing and applying changed data
	Batch load requirements
	Limitations of methods in applying change
	Purging and archiving data

	Lesson Nine: Leaving a Metadata Trail

	Defining warehouse metadata
	Developing a metadata strategy
	Examining types of metadata
	Metadata management tools
	Common warehouse metadata

	Lesson Ten: Managing the Data Warehouse

	Managing the transition to production
	Managing growth
	Managing backup and recovery
	Identifying data warehouse performance issues