Database and Reporting Training     
USACanada UK Ireland International
1 877 849 1850   0808 234 2132   1 800 550 311   +1 678 648 3113
  Home   Contact Us
Crystal Reports Training * MySQL Training * Oracle Training * SQL Server Training * Live Online Training


* Introduction to Oracle 11g SQL training
* Beginning and Advanced Oracle 11g PL/SQL training
* Oracle 11g Administration I training
* Oracle 11g Administration II training
* Oracle Data Warehousing and Warehouse Builder training
* Oracle 11g Backup & Recovery training
* Oracle 11g Features for Administrators



Please contact us
for GSA pricing.

GSA

Contract #
GS-35F-0307T



Complimentary Database & Reporting Training Seminar

Organizations in the Atlanta, Georgia area are encouraged to contact Accelebrate® about having a complimentary, one-hour database or reporting training seminar. For more details, please contact us today.



Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

  • Huntsville, Alabama
  • Montgomery / Birmingham, Alabama
  • Anchorage, Alaska
  • Calgary, Alberta
  • Phoenix, Arizona
  • Fayetteville / Little Rock, Arkansas
  • Oakland / San Jose / San Francisco, California
  • Sacramento, California
  • Oceanside / San Diego, California
  • Pasadena / Orange County / Los Angeles, California
  • San Bernardino / Riverside, California
  • Boulder / Colorado Springs / Denver, Colorado
  • Washington, DC
  • Wilmington, Delaware
  • Manchester / London, England
  • DeLand / Orlando, Florida
  • Fort Lauderdale / Miami, Florida
  • Gainesville / Jacksonville, Florida
  • Saint Petersburg / Tampa, Florida
  • Titusville & Melbourne, Florida
  • Alpharetta & Atlanta, Georgia
  • Augusta & Savannah, Georgia
  • Macon & Columbus, Georgia
  • Boise, Idaho
  • Bloomington, Illinois
  • Chicago, Illinois
  • Indianapolis, Indiana
  • Cedar Rapids / Des Moines, Iowa
  • Dublin, Ireland
  • Kingston, Jamaica
  • Wichita, Kansas
  • Paducah / Lexington / Louisville, Kentucky
  • Baton Rouge, Louisiana
  • Valletta, Malta
  • Hagerstown & Frederick, Maryland
  • Greenbelt / Silver Spring / Baltimore, Maryland
  • Boston / Cambridge, Massachusetts
  • Hartford, Connecticut / Springfield, Massachusetts
  • Taunton, Massachusetts / Providence, Rhode Island
  • Ann Arbor / Farmington Hills / Detroit, Michigan
  • Grand Rapids, Michigan
  • Lansing, Michigan
  • Saginaw / Flint / Bay City / Midland, Michigan
  • Saint Paul / Minneapolis, Minnesota
  • Jackson, Mississippi
  • Gulfport / Biloxi, Mississippi
  • St. Louis, Missouri
  • Whiteman Air Force Base / Kansas City, Missouri
  • Lincoln / Omaha, Nebraska
  • Reno and Las Vegas, Nevada
  • Santa Fe / Albuquerque, New Mexico
  • Newark, New Jersey
  • Princeton, New Jersey & Philadelphia, Pennsylvania
  • White Plains / New York City, New York
  • Charlotte, North Carolina
  • Durham / Raleigh, North Carolina
  • Bowling Green / Toledo, Ohio
  • Canton / Akron, Ohio
  • Cincinnati, Ohio
  • Cleveland & Columbus, Ohio
  • Dayton, Ohio
  • Tulsa / Oklahoma City, Oklahoma
  • Toronto, Ontario
  • Portland, Oregon
  • Pittsburgh, Pennsylvania
  • Providence, Rhode Island
  • Edinburgh / Glasgow, Scotland
  • Columbia & Charleston, South Carolina
  • Chattanooga / Knoxville, Tennessee
  • Memphis / Jackson / Nashville, Tennessee
  • College Station and Houston, Texas
  • El Paso, Texas / Ciudad Juarez, Mexico
  • San Antonio / Austin, Texas
  • Wichita Falls & Dallas, Texas
  • Ogden / Salt Lake City, Utah
  • Burlington, Vermont
  • Fairfax / Dulles / McLean / Herndon / Reston, Virginia
  • Richmond / Alexandria / Arlington, Virginia
  • Virginia Beach / Norfolk, Virginia
  • Tacoma / Seattle, Washington
  • Madison / Milwaukee, Wisconsin

 

 

Oracle Data Warehousing Training & Oracle Warehouse Builder Training
Print This Outline
E-mail This Outline
Get A Quote
Course Number: 576
Duration: 5 days
view class outline

Oracle Data Warehousing Training Overview

This Oracle 11g data warehousing training highlights the features within the Oracle database specifically intended to support data warehouses and data mining operations.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. To receive a customized proposal and price quote, please contact us.

In addition, some courses are available as live, online classes for individuals.  To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/database.htm.

Oracle Data Warehousing Training Prerequisites

All attendees must have real world experience administering Oracle 11g, as well as knowledge of fundamental data warehosing concepts.

Hands-on/Lecture Ratio

This course is 60% hands-on, 40% discussion, with the longest discussion segments lasting 20 minutes.

Oracle Data Warehousing Training Materials

All students receive comprehensive courseware and a related textbook.

Software Needed on Each Student PC

  • A complete installation of Oracle 11g

Please contact us for detailed setup instructions if you have purchased this class.

Oracle Data Warehousing Training Objectives

All attendees will learn how to:

  • Understand star and snowflake schemas and other data warehouse physical and logical database objects Understand and encourage optimization of star queries
  • Create and Maintain materialized views to enhance ad-hoc query performance against enormous volumes of transactional data
  • Manage materialized views to effectively and efficiently maintain their structure over the course of time
  • Create and maintain dimensions and hierarchies to enhance ad-hoc query performance and support sophisticated data mining
  • Perform dimensional analysis of data warehouse information and building cubes
  • Configure the Oracle Warehouse Builder (OWB) repository
  • Implement data quality assurance using data rules and the OWB Data Profiler to evaluate data quality within transactional source databases and warehouse target databases
  • Use mappings and process flows for data correction and augmentation, as well as build Extraction, Transformation and Transformation (ETT) or Loading (ETL) processes within OWB

Oracle Data Warehousing Training Outline

  • Data Warehouse Design & Schemas
    • Data Warehouse Concepts
    • ETT / ETL
    • Data Warehouse Schemas
    • The Equities Data Model
    • Equities Logical Data Model
    • Equities Physical Model
    • Physical Design Considerations
  • Creating Materialized Views
    • About Materialized Views
    • Create Materialized Views
    • Enable Query Rewrite
    • Storage & Tablespace Clauses
    • Parallel & Partition By Clauses
    • Build Clause
    • Nested Materialized Views
  • Maintaining Materialized Views
    • Alter Materialized View
    • Drop Materialized View
    • Data Dictionary Storage
    • Using EM
  • Materialized View Refresh
    • About Materialized View Refresh
    • Refresh Methods
    • Create Materialized View Log
    • Alter Materialized View Log
    • Drop Materialized View Log
    • Refresh Modes
    • On Commit Considerations
    • Performing Refresh Operations
    • Refreshing With Refresh_All_Mviews()
    • Refreshing With Refresh()
    • Refreshing With Refresh_Dependent()
    • Using Explain_Mview()
    • Data Dictionary Refresh Metadata
    • Using EM
  • Controlling The Query Rewrite Facility
    • Enabling Query Rewrite
    • Viewing Execution Plans
    • Create Plan_Table
    • Using Autotrace
    • Using EM
    • Controlling Query Rewrite
    • Norewrite
    • Rewrite
    • Utilizing Constraints With Query Rewrite
    • Enable Validate Constraint Option
    • Enable Novalidate Constraint Option
    • Disable Novalidate Constraint Option
    • Disable Validate Constraint Option
    • Rely Constraint Option
    • Enforced Level
    • Trusted Level
    • Stale_Tolerated Level
    • Query Rewrite Influences
    • Using EM For "What-If?" Scenarios
  • Dimensions
    • What Are Dimensions?
    • Creating & Maintaining Dimensions
    • Alter Dimension
    • Drop Dimension
    • Dimension Metadata & Validation
  • Dimensional Analysis Of Data
    • Data Sampling
    • Dimension Aggregation Techniques
    • The Grouping() Function
    • Using Cube()
    • Building The Data Warehouse Cube
    • The Equities Cube
    • Grouping_Id() Function
    • Cube() Vs. Grouping Sets()
  • Star Queries & The Optimizer
    • What Is A Star Query?
    • A Star Transformation Scenario
    • Encouraging Star Transformation
    • Star Transformation Hints
    • Star_Transformation Hint
  • ETL: Loading From External Tables
    • About The Extraction Options
    • Using External Tables
    • Oracle_Loader Access Parameters
    • Records Parameter
    • Badfile Parameter
    • Logfile Parameter
    • Discardfile Parameter
    • Load When Parameter
    • Skip Parameter
    • The Location Clause
    • Reject Limit Clause
    • Fields Terminated By Parameter
    • Missing Field Values Parameter
    • Oracle_Datapump Access Driver
    • Maintaining External Tables
    • User_External_Tables
    • User_External_Locations
    • Using Alter Table
  • ETL: Transformation With Table Functions
  • About Oracle Warehouse Builder
    • OWB & The Data Warehouse
    • OWB Capabilities
    • OWB Architecture
    • OWB Repository
    • Omb*Plus
  • Configure Oracle Warehouse Builder
    • Repository Database Configuration
    • Manage The Control Center Services
    • Configure The Repository & Workspace
  • Using The Design Center & Building The Infrastructure
    • Launch The Design Center
    • Defining The Infrastructure
    • Defining Locations
    • Defining Control Centers
    • Design Center Preferences
  • Define Modules & Import Metadata
    • Define A Project Container
    • Define Modules
    • Import Metadata
  • Maintaining The Relational Model
    • Navigating The Data Object Editor
    • Working With A Detail View
    • Defining A New Object
    • Deploying Objects To A Target Database
  • Data Quality Assurance & Management
    • About Data Analysis Principles
    • Create Data Profiles
    • Use The Data Profile Editor
  • Data Rules & Correction Mappings
    • Creating Data Rules
    • Applying Data Rules
    • Correction Mappings
    • Data Auditing Monitors
  • ETL Mappings
    • Using The Mapping Editor
    • About The Operators
    • Working With Staging Tables
  • Process Flows & Schedules
    • Using Process Flows
    • Using Schedules
  • Conclusion

© 2008 Sideris Courseware Corporation
 
Print This OutlineE-mail This OutlineGet A Quote

Java® and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.

MySQL™ and all MySQL-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the U.S. and other countries.

Accelebrate®
Comes to You!


Accelebrate's courses are taught exclusively on-site at your location for groups of 3 or more attendees, anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate come to your site and deliver exactly the training you want, for less than the cost of a public class.

For pricing and to learn more, please call us at +1 877 849 1850, fill out our information request form, or email us at info@accelebrate.com today.
 
Accelebrate E-Newsletter


Get the latest Web development news delivered to your email box once a month!

VB.NET, C#, ASP, & ASP.NET Training * Java Training * SQL Server Training
Adobe Training * PHP Training * XML Training * Perl Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.

Recent client sites: Birmingham, AL | Phoenix, AZ | Los Angeles, CA | Sacramento, CA | San Diego, CA | San Francisco, CA | San Jose, CA | Denver, CO | Washington, DC | Jacksonville, FL | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Chicago, IL | Indianapolis, IN | Boston, MA | Baltimore, MD | Detroit, MI | Minneapolis, MN | Kansas City, MO | Saint Louis, MO | Charlotte, NC | Raleigh, NC | Albuquerque, NM | Las Vegas, NV | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Dayton, OH | Oklahoma City, OK | Toronto, ON | Portland, OR | Philadelphia, PA | Pittsburgh, PA | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | San Antonio, TX | Salt Lake City, UT | Seattle, WA | Dublin, Ireland | London, UK
About Accelebrate IT Training VB.NET, C#, and ASP.NET Training Java, Struts, and JSP Training Adobe Training Microsoft SQL Server Training XML Training, PHP Training, Perl Training, and Other Courses Database and Reporting Training