Scheda corso
NovaNext Training / Oracle / Data Warehousing / Oracle Database 11g: Administer a Data Warehouse

Oracle Database 11g: Administer a Data Warehouse

Codice
D70064GC20
Durata
4 Giorni
Prezzo
2.300,00 € (iva escl.)
Lingua
Italiano
Modalità
Virtual Classroom
Corso in aula
       

 

Schedulazione
Luogo Data Iscrizione
A Richiesta

 

Prerequisiti

Recommended Related Training Courses:

This Oracle Database 11g: Analytic SQL for Data Warehousing training teaches you how to use Analytic SQL to aggregate, analyze & report & model data. Learn to interpret the concept of a hierarchical query, create a tree-structured report & format hierarchical data. 

Oracle OLAP 11g, a fully-integrated component of Oracle Database 11g, provides a full featured multidimensional data model and calculation engine that is easily accessible to any SQL based business intelligence application or tool. In this course students learn to design and create a powerful, analytically rich OLAP data model, and create sophisticated analytic reports of OLAP data by using simple SQL queries.

This Oracle Database 11g Performance Tuning training is an advanced curriculum course. It builds on the Introduction to Performance Tuning in the Administration Workshop I and II courses, focusing on the tuning tasks expected of a DBA. 

This is an advanced course building on the introduction to Performance Tuning provided in the Administration Workshop I and II courses. Students learn how to use Oracle Database 11g automatic tuning features.

This Implement Oracle Data Warehousing Best Practices training teaches you the best practices for implementing an enterprise data warehouse. Learn how to build a balanced hardware configuration and review the two classic models: third normal form and star schema.

 

Obiettivi
  • 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

 

Destinatari

· Data warehouse administrator

· Application developers

· DBA

· Technical adviser

 

Contenuti

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.

Benefits To You

Expert instructors will also teach you how 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