Pre-Requisites: Ability to read and understand execution plans. Good working knowledge of SQL and in data warehouse design and implementation.
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 was a Computer Technician with a major Corporation for 33 years when organization downsizing impacted my career. After 33 years, it was hard to fathom unemployment not to mention what to do next. I was angry, frustrated, and upset! After a few calming days of contemplation and a few weeks of unsuccessful job searches, [...] Read more
David Gough
My name is Tiffanie Bradley; I was a Mainframe Programmer Analyst by profession and was laid off from Compuware Corporation in 2004. I have been in the Information Technology (IT) field for over 15 years and have experienced a successful career. Upon being laid off and seeking further employment, I recognized that my skills were [...] Read more
Tiffanie Bradley
I wish to express my thanks and gratitude for your expert teaching and support that have helped me transition into a career in information technology. When I began taking classes in August of 2009, I had been unemployed for over a year, and job prospects in the insurance industry were slim. Your staff took the [...] Read more
Marcus Thompson
This is an great day to say the educational experience has given me and my family an ultimate way knowing how lives can change through information as well as information technology. I don’t really have much to say on this matter because the challenges, the grinding work effort was a part of my personality since [...] Read more
Dell Williams
“This was, by far, the best class experience I have had since high school. I took the COMPTA+ and Networking+ classes at Global Information Technology, and within a few months of completing these classes, I had a Level II Technical support position. The instructors were fantastic and really cared about my learning. If I had [...] Read more
Jonathan Nimene
866-GO-GIT-GO