The Oracle Database 11g: Administer a Data Warehouse training course helps participants in understanding the basic functionalities and features of administering a data warehouse. This training will also familiarize participants to deploy the various features of Oracle Database to improve performance and manageability in a data warehouse.
Completion of this training course will enable candidates in:
Using parallel operations to reduce response time.
Extracting, transforming and loading data.
Creating, using and refreshing materialized views.
Using query rewrite to quickly answer business queries using materialized views.
Using SQL access advisor and PL/SQL procedures to tune materialized views.
Identifying the benefits of partitioning, to reduce response time for data-intensive operations.
Training of this course will help individuals to extract, transform and load data into an Oracle database warehouse. This course will also engage participants in using materialized views in order to improve data warehouse performance and also learn how query rewrites can improve performance.
Data Warehouse: Architectures, Design, Object & Schemas
3. Data Warehouse Tuning Considerations
Optimize Star Queries
Introduction to Bitmap Join Indexes
Bitmap Joined Index Optimization
Star Query Optimization
4. Partitioning Basics
Partitioned Tables and Indexes
Partition Pruning and Star queries
5. Parallelism Concepts
Operations That Can Be Parallelized
Parallel Execution Working
Degree of Parallelism
Parallel execution plan
6. Parallel Operations in Data Warehouses
Balancing the Workload
Parallel DDL & Parallel DML
Tuning Parameters for Parallel Execution
7. ETL: Extraction and Transportation
Capture Data with Change Data Capture
Sources and Modes of Change Data Capture
Publish and Subscribe Model
Synchronous and Asynchronous CDC
Asynchronous AutoLog Mode and HotLog Mode
Transportation in a Data Warehouse
8. ETL: Loading
Applications of External Tables
Define external tables with SQL*Loader
Populating external tables with Data Pump
9. ETL: Transformation
Transformation Using SQL
DML error logging
10. Materialized Views
Need for Summary Management
Types of Materialized Views
Materialized View Dictionary views
Use Materialized Views for Summary Management
11. Refreshing Materialized Views
Refresh Options & Refresh Modes
Conditions That Effect Possibility of Fast Refresh
Materialized View Logs
Partition Change Tracking (PCT) Refresh
Refresh Performance Improvements
12. Working with Dimensions
Create Dimensions and Hierarchies
Dimensions and Privileges
Verify Relationships in a Dimension
13. Query Rewrite
Overview of Query Rewrite
What Can Be Rewritten?
Conditions Required for Oracle to Rewrite a Query
Guidelines for Query Rewrite
Set Initialization Parameters for Query Rewrite
Query Rewrite Methods
Partition Change Tracking (PCT) and Query Rewrite
14. Using the SQL Access Advisor, Compression, and Resumable Sessions
Usage Model of SQL Access Advisor
Set Initial Options
Specify the Workload Source
Schedule and Review
PL/SQL Procedure Flow
Table Compression and Resumable Sessions
Tune Materialized Views for Fast Refresh and Query Rewrite
The Oracle Database 11g Administer a Data Warehouse Course is ideal for:
Data Warehouse Administrator
Data Warehouse Developer
Working knowledge of SQL and in data warehouse design and implementation
Knowledge & experience of Data Warehouse designing, implementation, and maintenance
Ability to read and understand execution plans
What Our Trainees Say
I want to express the extent of my admiration and appreciation for the organization and the effort you had made for the sake to success the training I did particularly and the success to the Institute generally. What I have seen during the past few days will be an opportunity to return again and recommend the Institute among colleagues. Interacting with many tools and share information with the students. Moreover, to that the instructor provides activities and demonstrates the process for running tools in live mode.
I like Mercury Solutions, they provided me with what they promised. All communication with the staff was good. All the tactics used to impart training was good. The trainer was an awesome person. He has a vast knowledge and knows how to train a student, he taught me with all the possibilities in the security field. He knows his subject very well. I highly recommend the trainer for all the security related trainings. The company guest house and the staff was very good. The overall transportation was also good and the drivers are helpful. They also sent me for city tours which were awesome.
I am really delighted about the SQL Training course: Querying Microsoft SQL Server with Mercury Solutions. Every session was great and very valuable. Practical application made the course significantly more valuable. The thing most impressive was the way the entire programme was structured. Instructor is having great experience and diverse knowledge in SQL Server. I am looking for learning Administering Microsoft SQL Server 2014 Databases with same trainer.
I came to make resolution to learn Cisco Security, so I chose Mercury Solutions. I learnt a lot and gained a lot. Presently, I became CCNA certified and EC-Council Penetration Tester. I learnt a lot from good lectures and from trainers, and also I enjoyed a lot and I would advise all to come down and learn."
Fill & Avail
10% OFF / more discount offers
On All Courses
Request For Price
Mercury Solutions Ltd. is rated
4.6 stars by www.facebook.com/mercurysol