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
Course Number : ORCL-7-0101
Duration : 40 hours
Real testimonials from our Students!
I just want to say “Thank You” to Global Information Technology for getting me to where I am now. My place of work, Raytech, was permanently closed and all employees including myself were laid off in the beginning of 2005. I was introduced to Global Information Technology by the Southfield Unemployment office to take e-commerce [...] Read more
Ebenezer Aniapam
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
Greetings! I am a currently a student taking courses at Global Information Technology, a company that offers a complete suite of modern, relevant computer software, network and personal computer hardware training. Class sizes are small with extensive hands-on instruction. The company provides instruction in the most up-to-date software and information technologies and teaches using the [...] Read more
Zsombor Zoltan
Thank you for changing my life. Before I started Global Information Technology (GIT), I felt like I’d be selling shoes for $7.50 an hour for the rest of my life. My lack of self esteem made me miss out on great opportunities. Your wonderful Network Engineering Professional program and extremely helpful staff helped me to [...] Read more
Adeel Irfan
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