You will learn to implement partitioning, use parallel operations to reduce response time, extract, Transform, and Load data, create, use, and refresh materialized views to improve the data warehouse performance, use Query rewrite to quickly answer business queries using materialized views and use SQL Access Advisor and PL/SQL procedures to tune materialized views for fast refresh and query rewrite.
Participants learn about Oracle’s Database partitioning architecture and how to identify the benefits of partitioning in addition to using parallel operations to reduce response time for data-intensive operations. Participants extract, transform, and load data into an Oracle database warehouse. Participants also use materialized views to improve the data warehouse performance and learn how query rewrites can improve performance.
Introduction
Data Warehouse Design: Overview
Data Warehouse Tuning Considerations
Partitioning Basics
Parallelism Concepts
Parallel Operations in Data Warehouses
ETL: Extraction and Transportation
ETL: Loading
ETL: Transformation
Materialized Views
Refreshing Materialized Views
Working With Dimensions
Query Rewrite
Using the SQL Access Advisor, Compression, and Resumable Sessions
Real testimonials from our Students!
I just wanted to express my feelings about Global Information Technology and their staff. First let me say I have never encountered an organization that cares about the students as much as GIT. After working many years for an automotive supplier in the auto industry I found myself unemployed, without a degree or any certifications [...] Read more
Aubrey Carvine
My name is Lesley Goodwin and I work in financial services industry as a Marketing and Communication Manager. Over the past two years, I have exchanged emails with GIT while researching several training options. GIT continued to keep me informed of their class outline and when I learned they could coordinate a class around my [...] Read more
Lesley Goodwin
I am writing to thank all of the hardworking individuals at Global IT. Without your support, it would not have been possible for me to make such a smooth career transition. After being laid off from the tool making industry, I had the opportunity to enroll in the program at GIT. With a family to [...] Read more
Stewart Sykes
I began taking the Windows 2000 MCSE track in June of 2001. I decided to check out GIT after hearing an ad on the radio, and after viewing the facilities I signed up immediately. I attended classes on Tuesdays and Thursdays until the class ended in February 2002. I chose the MCSE course because I [...] Read more
David Warner
I am writing you this letting in praise of GIT, its wonderful staff and the learning experience I had in my time there. I have been an IT professional for 10+ years but never took the time to obtain any credentials or certifications along the way. When I finally decided it was time to do [...] Read more
De McCadney