Oracle Database 11g: Administer a Data Warehouse

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)