Have any questions?
+254 20 202 6318 / +254 728 459 152
info@datainfinity.net
5th Floor, Suite 47, Vision Plaza, Msa Road

Oracle Database 11g: Administer a Data Warehouse

11g

Oracle Database 11g: Administer a Data Warehouse

This course will help you understand the basic concepts of administering a data warehouse. You’ll learn to use various Oracle Database features to improve performance and manageability in a data warehouse.

Learn To:

  • Implement partitioning.
  • Use parallel operations to reduce response time.
  • Extract, transform and load data.
  • Create, use and refresh materialized views to improve 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 rewrites.
  • Identify the benefits of partitioning, in addition to using parallel operations to reduce response time for data-intensive operations.

Course Duration – Full Time: The course lasts 5 days.

Course Duration – Part Time: The course lasts 1 month.

A Leader in IT Solutions, & Training
FOR VARIOUS VENDOR TECHNOLOGIES, WITH A FOCUS ON ORACLE TECHNOLOGIES.