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 Database 10g: Implement and Administer a Data Warehouse
 
 
 
 
oracle certified training  
 
code. 10gDB-ADM-DW   length. 4 days
type. Instructor-Led   partner. Oracle
price.
$2,400  
 
 
This course is intended for database administrators, system administrators, and database application developers who design, maintain, and use data warehouses. Before attending this course, you should be familiar with relational database concepts, basic data warehouse theory, Oracle server concepts including application and server tuning, and the operating system environment under which you are running the Oracle Database Server.
 
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
Database Designers


 
prerequisites
  
 
Required Prerequisites:

Knowledge of Database Administration
Oracle Database 10g: Administration Workshop I Release 2
Oracle Database 10g: SQL Tuning Workshop
Oracle Database 10g: Administration Workshop II Release 2
Oracle Database 10g: 2 Day DBA Release 2


 
skills gained
  
 

Understand and describe the features inherent in an Oracle 10g Data Warehouse
Demonstrate how to implement parallel operations
Demonstrate extraction, transformation, and loading processes
Describe and demonstrate effective usage of Materialized Views in a data warehouse
Describe star, snowflake and 3NF schemas
Implement an effective partitioning schema for your data warehouse tables
Develop an effective backup and recovery strategy
Describe security challenges in a data warehouse


 
suggested prerequisites:
  
 

Oracle Database 10g: New Features for Administrators Release 2




 
course content details  
 


  Data Warehouse Design

Logical Versus Physical Design in Data Warehouses
Data Warehousing Schemas
Data Warehousing Objects
Physical Design in Data Warehouses
Hardware and I/O Considerations




  Data Warehousing Schemas

Star Schema Model
Snowflake Schema Model
Tuning Star Queries
Star Transformation Hints
Star Transformation Hints
Static Partition Pruning And Star Query
Dynamic Partition Pruning And Star Query
Dynamic Partition Pruning Determination




  Partitioning Basics

Supported partition types
Rolling window operations
Partition pruning
Partitioning Using a Template




  Extraction, Transportation, and Loading (Extraction and Transportation)

ETL Tools
Extraction Methods
Logical Extraction Methods
Physical Extraction Methods
Change Data Capture
Transportation Using Transportable Tablespaces
Loading Mechanisms




  ETL-Loading

Load a formatted flat file into an existing table with SQL*Loader
Performing basic transformations while loading with SQL*Loader
External tables using oracle_loader driver
External tables using oracle_datapump driver
Loading data with OCI and Direct-path APIs




  ETL-Transformation

Transformation Using SQL
Transformation Using PL/SQL
Transformation Using Table Functions
Error Logging and Handling Mechanisms




  Parallelism Concepts

Parallel Operations
Degree Of Parallelism
Parallel Execution Plan
Operations That Can Be Parallelized
The PARALLEL Clause
Parallel Query
Parallel DDL
Performance Benefits of Parallel DML




  Parallel Operations in Data Warehouses

Automated Parallel Query Tuning
Data Distribution And V$PQ_TQSTAT
Object Statistics And V$PQ_TQSTAT




  Materialized Views

Materialized Views Overview
Types Of Materialized Views
Nested Materialized Views
Partitioned Materialized Views
Refresh Methods and Modes
Altering/Dropping Materialized Views
Dimensions and Hierarchies
Dimensions and the Data Dictionary




  Dimensions

Creating dimensions
Validate dimensions data
View dimension definition information
Distinguish between dimensions and constraints




  Materialized Views Refresh

Refresh Methods and Modes
Identifying Dependent MVs
Conditions For Complete/Fast Refreshes
Materialized View Logs
Parallel Refreshes




  Query Rewrite

What Can Be Rewritten?
Enabling Query Rewrite
Join Compatibility Checks
Common Joins
PCT and Query Rewrite
Query Rewrite using Multiple MVs
Index Materialized Views




  SQL Access Advisor

DBMS_OLAP Advisory Procedures
Workload Management and Sources
Recommendations
Workload Filters and Attribute Types
Tuning of Manually Created Materialized Views
Fast-Refreshable Materialized Views
RECOMMEND_MVIEW_STRATEGY procedure




  Data Warehousing System Management

Statistics Collection
Resumable Sessions
Backup and Recovery
Table Compression
Security





 
Refresh your IT training.


ExitCertified - Oracle 100% Student Satisfaction


find a course
 
phone us
 
view course schedule





Rock solid authorized training. Search all courses now...

 
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