Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle Database 10g Implement & Administer Data Warehouses I
Oracle Training Overview

This Oracle 10g courseware training guide book will consider how to build, implement, tune and utilize data warehouses with Oracle technology. Logical data warehouse concepts are considered such as dimension tables, fact tables and star schemas. Implementing such logical concepts using the Oracle database is then presented including defining dimensions, hierarchies, measures and other objects. Physical implementation techniques are considered such as bitmap indexes, materialized views, and others. Emphasis is placed on the parallel execution features of the database and how these can yield significant performance advantages.

Oracle Training Prerequisites

The course Oracle Database 10g: Implement Parallel SQL & Partitioning For Data Warehouses
  • The course Oracle Database 10g: SQL Tuning
Oracle Training Suggested Next Courses

Advanced data warehouse implementation and administration is considered within the course
  • The course Oracle Database 10g: Implement & Administer Data Warehouses II - OLAP & Warehouse Builder
Oracle Training Audience

Target audience for this course are database administrators, data warehouse administrators and application developers who will be responsible for implementing applications using data warehouse technology.

Oracle Training Objectives

This course highlights the features within the Oracle database specifically intended to support data warehouses and data mining operations. One must use these specialized features to initially implement the data warehouse and thereafter utilize yet other features to administer and manage this unique environment. Due to the enormous volume of data often contained within data warehouses, a proper understanding of these features is essential. Among the specific objectives of this course are:
  • Understanding star and snowflake schemas and other data warehouse physical and logical database objects.
  • Understanding and encouraging optimization of star queries.
  • Creating and maintaining 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.
  • Creating and maintaining dimensions and hierarchies to enhance ad-hoc query performance and support sophisticated data mining.
  • Performing dimensional analysis of data warehouse information and building cubes.
  • Discuss and demonstrate options for building Extraction, Transformation and Transformation (ETT) or Loading (ETL) processes.
Oracle Training Course duration

3 Days

Oracle Training Course outline

DATA WAREHOUSE DESIGN & SCHEMAS
  • DATA WAREHOUSE CONCEPTS
  • ETT / ETL
  • DATA WAREHOUSE SCHEMAS
  • The EQUITIES Data Model
  • PHYSICAL DESIGN CONSIDERATIONS
CREATING MATERIALIZED VIEWS
  • ABOUT MATERIALIZED VIEWS
  • CREATE MATERIALIZED VIEWS
  • STORAGE & TABLESPACE Clauses
  • PARALLEL & PARTITION BY Clauses
  • BUILD Clause
  • Specifying The SELECT Clause
  • Including The ORDER BY Clause
  • NESTED MATERIALIZED VIEWS
MAINTAINING MATERIALIZED VIEWS
  • ALTER MATERIALIZED VIEW
  • DROP MATERIALIZED VIEW
  • DATA DICTIONARY STORAGE
  • USER_MVIEWS Example
  • 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
  • DATA DICTIONARY REFRESH METADATA
  • USING EM
CONTROLLING THE QUERY REWRITE FACILITY
  • ENABLING QUERY REWRITE
  • VIEWING EXECUTION PLANS
  • Create PLAN_TABLE
  • 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
DIMENSIONS
  • WHAT ARE DIMENSIONS?
  • CREATING & MAINTAINING DIMENSIONS
  • ALTER DIMENSION
  • DROP DIMENSION
  • DIMENSION METADATA & VALIDATION
  • Using DBMS_DIMENSION()
  • Using EM
DIMENSIONAL ANALYSIS OF DATA
  • DATA SAMPLING
  • DIMENSION AGGREGATION TECHNIQUES
  • Using ROLLUP()
  • 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
  • FACT Hint
ETL: LOADING FROM EXTERNAL TABLES
  • ABOUT THE EXTRACTION OPTIONS
  • Offline Extraction Methods
  • 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 us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy