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!
My name is Willie M. Williams, I became unemployed after nine years of service to one of the big three companies in April 2009. The majority of my department (ISS) was terminated indefinitely. I thought to myself, ok, I’ll just find another job in the IT field because I knew I had a Master’s degree [...] Read more
Willie M. Williams
Dear Manish: I wanted to also take this opportunity to thank you, and the Staff at Global IT. You and your staff all really changed my life. I know you all know my story and where I came from and where I am now. If it were not for how you conduct classes, and the [...] Read more
Bradley Freeland
I worked 17 yrs in manufacturing as a Hilo driver, a material processor and 9 yrs as a Quality assurance technician and was let go due to the economy in February 2007. During that time I’d always had a passion for the computing arena so after weighing my options and overcoming the fear that can [...] Read more
Ralph Cook
My name is Ruth Byrd. I would like to take this opportunity to convey the meaningful connections between my professional past and the skills that I acquired from the Global IT training experience. Too often we progress through the ‘ropes of life’ and do not invest the time to express our gratitude and authentic value [...] Read more
Ruth Byrd
“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