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 hired into Global I.T. late May, coming from three separate jobs that I had been working simultaneously. Manish gave me the chance to start with Global IT to pursue Office Assistant and also suggested that I take the MS Office Suites class that they offered. I was constantly surrounded by people that encouraged [...] Read more
Mieh Khatib
I’d like to take my time to thank you and GIT for your wonderful assistance with getting me into a successful IT Career. You and your staff demonstrated great care in ensuring that I was able to be placed in a great job after completing my classes at the school, offering help with resume creation [...] Read more
Christopher Leimback
My name is Cedric Porties, and I am currently employed as a systems administrator for Electronic data Systems. I was made aware of Global Information Technology from a local computer magazine. After much speculation due to a situation from another private school I previously attended, I decided to go in and speak with a representative. [...] Read more
Cedric Porties
I’d just like to thank you and Global Information Technology for getting my career back on the right track. I had been unemployed for nearly 2 years after being laid off from ACCESS and I have been trying to find the right job. Couple months after applying to the unemployment, Michigan Works office approved me [...] Read more
Racha Ramdan
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
866-GO-GIT-GO