Canada IT Courses
ExitCertified US




ExitCertified - Excellence in IT Certified Education
 
IT education classes
IT training feature sheet
 
   
 
start > courses and registration > training feature sheet
 
 
oracle certified training  
 
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.
 
course schedule  
 
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.
   
Request course date Request on site training
 
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


  after related training and products


 
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





 
Sun Microsystems Training Special


ExitCertified - Oracle 100% Student Satisfaction


find a course
 
phone us
 
view course schedule





Sun Microsystems Training Special

 
go to top
Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education
© 2008 ExitCertified. All rights reserved.
terms of use and disclaimer :: privacy policy :: webmaster :: link to us
   
Sacramento Training :: 916.669.3970 | Las Vegas Training :: 1.800.803.EXIT (3948) | San Francisco Training :: 415.975.3948 | San Jose Training :: 408.288.EXIT (3948)
Phoenix, Arizona Training | Los Angeles, California Training | San Diego, California Training | Broomfield, Colorado Training | Fort Lauderdale, Florida Training
Tampa, Florida Training | Atlanta, Georgia | Downers Grove, Illinois | Kansas City, Kansas Training | Portland, Maine Training | Baltimore, Maryland Training | Burlington, Massachusetts Training
Troy, Detroit, Michigan Training | Minneapolis, Minesota Training | St. Louis, Missouri Training | Omaha, Nebraska Training | Edison, New Jersey Training | New York City, New York Training
Raleigh, North Carolina Training | Columbus, Ohio Training | Philadelphia, Pennsylvania Training | Nashville, Tennessee Training | Dallas, Texas Training
Houston, Texas Training | Hampton, Virginia Training | Madison, Wisconsin Training | Seattle, Washington Training

ExitCertified is a global provider of authorized technology training. Some of our popular course topic searches include:

Java Training | J2EE Training | JSP Training | Java Courses | Servlets Training | EJB Training | Struts Training | Networking Courses | Solaris Training
Red Hat Training | SUSE Training | XML Training | Oracle SQL | Oracle PL/SQL | DBA Training | DBA Certification | Oracle Certification
RedHat Training | Solaris Certification | Java Certification | Veritas Certification | PeopleSoft Training | 11g Training | 11g Certification
RedHat Courses | SQL Training | 10g Training | 9i Training | Application Development Training | Certified Training | Corporate Training
Government Training | Course Catalogue | Training Schedule | Certification Training | Project Management Training | Linux Training
Solaris 10 Training | Unix Training | NetBackup Training | Virus Protection Courses | Education Technology Newsletter | zSeries Training
s/390 Training | iSeries Training | DB2 Training | OS/400 Training | AIX Training | Rational Courses | PMI Training | Project Management Training
SeeBeyond Training | Java Composite Application Platform (JCAPS) Training | MySQL Training | MySQL Database Course | Hyperion Training | Fusion Middleware