Oracle Data Warehouse Schulung:
The benefits of partitioning
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.The usage of SQL Access Advisor to optimize the entire workload, tuning materialized views for fast refresh and query rewrite and also how to use the compression and resumable sessions features arediscussed.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 Use SQL Access Advisor and PL/SQL procedures to tune materialized views for fast refresh and query rewrite A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.