PROKODA Gmbh

Oracle Database 11g: Administer a Data Warehouse

PROKODA Gmbh
Online

2.708 
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
0221/... Mehr ansehen

Wichtige informationen

Tipologie Seminar
Methodologie Online
Beginn nach Wahl
  • Seminar
  • 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 (1)
Wo und wann
Beginn Lage
nach Wahl
Online
Beginn nach Wahl
Lage
Online

Zu berücksichtigen

· An wen richtet sich dieser Kurs?

Data Warehouse-AdministratorTechnischer BeraterDatenbankadministratoren

· Voraussetzungen

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

Was lernen Sie in diesem Kurs?

Access
SQL
OLAP
Business

Themenkreis

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)

User, die sich für diesen Kurs interessiert haben, interessierten sich auch für...
Mehr ansehen