Search for a training course using the search box above, or the quick links below. Once you have found the course you are looking for, click the course name. If you are not sure, select a course which you think closely matches your requirement and we can advise you later.
Once you are satisified this course meets your requirement - find a suitable date and location from the list on the right had side. Remember you can always change your mind later on - and if none are completely suitable, select the closest one. We will call you to discuss your requirement and you can tell us of your exact need then.
3SEND ENQUIRY
Fill out the enquiry form below and click Submit. This is not a commitment to buy. We check the details and get back to you regarding availability. You can discuss the requirements further, otherwise we will send you a quotation.
Oracle Database 11g: Administer a Data Warehouse
Course Code: D70064GC10 Days: 4
Overview
Online Training
Time stretched?
If you would prefer something more flexible, we can now offer Online Training related to this topic.
Students learn about Oracle's Database partitioning architecture and identify the benefits of partitioning. Students also use parallel operations to reduce response time for data-intensive operations. Participants extract, transform, and load data into an Oracle database warehouse. Students also use materialized views to improve the data warehouse performance. Students also learn how query rewrite can improve a query's performance. Students use the SQL Access Advisor to optimize the entire workload. Finally, students learn how to tune materialized views for fast refresh and query rewrite and how to use the compression and resumable sessions features
