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 in the legal field for over 20 years (Secretary promoted to Paralegal). After being laid off from my last position, I decided I needed a change. I had used databases as a front end user during my legal field and was really interested in learning more. My passion for computers and database interest [...] Read more
Donna Zarzycki
This is just a note of thanks to you and your staff to express how pleased I am with the education I am receiving from Global Information Technology. In March, 2007 I was without employment for the second time within four months. Even though I had a Master of Arts Degree in Education, the lack [...] Read more
Debbie Leveski
June 2, 2020. Before Global Information Technology I found myself in a “great job market” with no callbacks on the dozens of applications I submitted to companies all over metro Detroit. I was in a particular bind because I had work experience AND a graduate degree, but all of the offers I received were well [...] Read more
Stephanie Holley
I wish to thank GIobal Information Technology for helping me restart my career after taking a break of almost 8-9 years. During my career break, I had not kept my skills updated and before getting back into my career search, I decided to get re-trained. While researching the training institutions, in late 2009, I came [...] Read more
Nalini Sanku
This letter is recognition of Global Information Technology for their outstanding computer training courses. I have been attending courses at GIobal IT and have recently completed my course work for Microsoft Office Professional. I found the experience to be both enriching and gratifying. The instruction was easy to follow and very thorough. I highly recommend [...] Read more
David Taylor
866-GO-GIT-GO