United Kingdom
France
Germany
Netherlands
Sweden
USA
Italy
Spain
More From Contributor
Oracle Database 11g: Administer A Data Warehouse
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
Product Description
Students learn about Oracle's Database partitioning architecture & identify the benefits of partitioning. Students also use parallel operations to reduce response time for data-intensive operations. Participants extract, transform, & 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 & query rewrite & how to use the compression & resumable sessions features.
Learn to:- Implement partitioning
- Use parallel operations to reduce response time
- Extract, Transform, & Load data
- Create, use, & refresh materialized views to improve the data warehouse performance
- Use Query rewrite to quickly answer business queries using materialized views
- Use SQL Access Advisor & PL/SQL procedures to tune materialized views for fast refresh & query rewrite
Reviews/Comments
Add New
Vouchers
Do you know a voucher code for this product or supplier? Add it to Insights for others to use.
Denmark