Oracle Database 11g: Data Warehousing & Oracle Warehouse Builder Courses and other IT courses from TEKsystems Education Services

Note: All fields are required

First Name:

Last Name:

Company:

Title:

Email Address:

Phone Number:

Address:

City:

State:

Zip Code:

Which Topic(s) Currently Interests Your Organization:

Tell Us More:

I have an immediate training or educational service need and I wish to be contacted today

I am a current TEKsystems Education Services client and wish to speak to someone

I have a training budget approved and I am ready to talk to someone about the details of my organization’s training need

I do not have an approved training budget, but I have a need and would like to talk to TEKsystems Education Services about their solutions

Unfortunately, I do not have a group training request

At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.

My Delivery Method Needed Is:

Instructor-Led Classroom Training

Instructor-Led Virtual Training

Self-Paced Online Training

Code Number:

We Value Your Privacy!

Course Code:	RT 513
Course Abstract:	This course highlights the features within the Oracle database specifically intended to support data warehouses and data mining operations. It is presented as a two-volume set. The first volume considers data warehousing concepts and the requirements to initially configure a data warehouse installation. The second volume discusses how the Oracle Warehouse Builder (OWB) product may be used to implement and maintain both transactional and warehouse databases, and the movement of data between those two different types of installations.
Audience:	This course is designed for individuals who are database administrators, data warehouse administrators and application developers who will be responsible for implementing applications using data warehouse technology.
Duration:	5 days
Learning Outcomes:	Upon completion of this course, the participant will be able to: > Recognize star and snowflake schemas and other data warehouse physical and logical database objects. > Recognize and encouraging 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. > Configuration of the Oracle Warehouse Builder (OWB) repository and consideration of OWB capabilities. > Implement data quality assurance using data rules and the OWB Data Profiler to evaluate data quality within transactional source databases and warehouse target databases. > Using mappings and process flows for data correction and augmentation, as well as building Extraction, Transformation and Transformation (ETT) or Loading (ETL) processes within OWB.
Course Topics:	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 OMBPlus 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
Prerequisites:	A mandatory prerequisite to this course is the Course Oracle Database 11g: Implement Parallel SQL & Partitioning for Data Warehouses. Additionally, it is recommended that one have attended one of the following advanced courses provided for either database developers or database administrators: Oracle Database 11g: New & Advanced Features for Developers Oracle Database 11g: New Features for Administrators

Oracle Database 11g: Data Warehousing & Oracle Warehouse Builder Course

Hot Courses

Top Skills

Testimonials

Agile
AJAX and Web 2.0
Business Analysis
Business Practices
Cisco
Communications
Customer Service/Communications
Data Warehousing
Database Developer
End User
Enterprise Architecture
Internet Application Developer
Lotus
Mainframe
Messaging Infrastructure
Networking
Operating Systems
Programming Languages
Programming Methodologies
Project Management
Project Management
Quality Assurance
Relational Databases
Reporting Tools
SAP
Scrum Master
Security
Server Applications
SQL & PL/SQL Programming
Testing
Testing and Quality Assurance
Virtualization
Web Technologies
Wireless Technology