You are here:Courses|Oracle|Data Warehouse|Oracle Database 11g: Administer a Data Warehouse New

Oracle Database 11g: Administer a Data Warehouse New

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 are discussed.

 

Schedule for Oracle Database 11g: Administer a Data Warehouse New Training Boot Camp
Course Contents Regular Track (days)
Oracle Database 11g: Administer a Data Warehouse New 4
Balance Days  for day of arrival, exam and practice 1
Total duration 5

Prerequisites :

  • Ability to read and understand execution plans
  • Good working knowledge of SQL and in data warehouse design and implementation
  • Data Warehouse design, implementation, and maintenance experience

 

Our Location

Get In Touch

1st Floor of CHABAH House,

Chabah Bus Stop on the Odokor-Mallam HighWay

Opposite Total Filling Station

P. O. Box DS 2022

Accra, Ghana

Phone: +233 303 393 1256 / +233 302 325 815

Cell: +233 244036 522

Email:[email protected]