The Oracle Database - Administer a Data Warehouse training course will help you understand the basic concepts of administering a data warehouse. You will learn to use various Oracle Database features to improve performance and manageability in a data warehouse. In this course you will learn to extract, transform and load data into an Oracle database warehouse. Discover how to use SQL Access Advisor to optimize the entire workload. Use materialized views to improve data warehouse performance and learn how query rewrites can improve performance.
By attending Oracle Database - Administer a Data Warehouse workshop, delegates will learn to:
- Use parallel operations to reduce response time for data-intensive operations
- Extract, Transform, and Load data in the data warehouse
- 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
- Use the features of compression and resumable sessions
- Review the basic Oracle data warehousing concepts
- Good working knowledge of SQL and in data warehouse design and implementation
- Data Warehouse design, implementation, and maintenance experience
- Ability to read and understand execution plans
This Oracle Database - Administer a Data Warehouse class is ideal for:
- Administrators
- Database Administrators
- Developers
- Implementers