Oracle Database 11g: Administer a Data Warehouse

Online

2.708 € inkl. MwSt.
  • Tipologie

    Seminar

  • Methodologie

    Online

  • Beginn

    nach Wahl

Beschreibung

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 YouExpert 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.

Einrichtungen

Lage

Beginn

Online

Beginn

nach WahlAnmeldung möglich

Zu berücksichtigen

Data Warehouse-AdministratorTechnischer BeraterDatenbankadministratoren

Erforderliche Vorkenntnisse:Good working knowledge of SQL and in data warehouse design and implementationData Warehouse design, implementation, and maintenance experienceAbility to read and understand execution plans

Fragen & Antworten

Teilen Sie Ihre Fragen und andere User können Ihnen antworten

Wer möchten Sie Ihre Frage beantworten?

Es wird nur sowohol Ihren Name als auch Ihre Frage veröffentlichen

Erfolge des Zentrums

Dieses Bildungszentrum hat Qualität bei Emagister bewiesen
12 Jahre bei Emagister

Was lernen Sie in diesem Kurs?

  • Access
  • SQL
  • OLAP
  • Business

Inhalte

IntroductionData Warehouse Design: OverviewData Warehouse Tuning ConsiderationsPartitioning BasicsParallelism ConceptsParallel Operations in Data WarehousesETL: Extraction and TransportationETL: LoadingETL: TransformationMaterialized ViewsRefreshing Materialized ViewsWorking With DimensionsQuery RewriteUsing the SQL Access Advisor, Compression, and Resumable Sessions
Förderung durch z.B. Bildungsprämie und NRW-Bildungsscheck möglichEmpfehlenswerte verwandte Kurse:Oracle Database 11g: OLAP EssentialsOracle 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.Implement Oracle Data Warehousing Best PracticesThis 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. Verwendete Datenbank Version:Oracle Database 11g Release 2 (11.2.0.2) Patch Set 1URL zur Kursbeschreibung als PDF:http://education.oracle.com/pls/web_prod-plq-dad/view_pdf?c_org_id=34&c_lang=D&c_id=D70064GC20Seminarzeiten dieses Online-Trainings:3:00 Uhr bis 11:00 Uhr (Mitteleuropäischer Zeit)
2.708 € inkl. MwSt.

Rufen Sie das Bildungszentrum an

und erhalten Sie zusätzliche Informationen

0221/4854-0