Oracle Database 11g: Data Warehousing Fundamentals
Seminar
Online
Beschreibung
-
Kursart
Seminar
-
Methodik
Online
-
Beginn
auf Anfrage
This Oracle Database 11g: Data Warehousing Fundamentals training will teach you about the basic concepts of a data warehouse. Explore the issues involved in planning, designing, building, populating and maintaining a successful data warehouse.Learn To:Define the terminology and explain basic concepts of data warehousing.Identify the technology and some of the tools from Oracle to implement a successful data warehouse.Describe methods and tools for extracting, transforming and loading data.Identify some of the tools for accessing and analyzing warehouse data.Describe the benefits of partitioning, parallel operations, materialized views and query rewrite in a data warehouse.Explain the implementation and organizational issues surrounding a data warehouse project.Improve performance or manageability in a data warehouse using various Oracle Database features.Oracle’s Database Partitioning ArchitectureYou’ll also explore the basics of Oracle’s Database partitioning architecture, identifying the benefits of partitioning. Review the benefits of parallel operations to reduce response time for data-intensive operations. Learn how to extract, transform and load data (ETL) into an Oracle database warehouse.Improve Data Warehouse PerformanceLearn the benefits of using Oracle’s materialized views to improve the data warehouse performance. Instructors will give a high-level overview of how query rewrites can improve a query’s performance. Explore OLAP and Data Mining and identify some data warehouse implementations considerations.Use Data Warehousing ToolsDuring this training, you’ll briefly use some of the available data warehousing tools. These tools include Oracle Warehouse Builder, Analytic Workspace Manager and Oracle Application Express.
Standorte und Zeitplan
Lage
Beginn
Beginn
Hinweise zu diesem Kurs
ProjektmanagerData Warehouse-AdministratorData Warehouse-AnalytikerEntwickler
Empfohlene Vorkenntnisse:Knowledge of general data warehousing conceptsKnowledge of client-server technologyKnowledge of relational server technology
Meinungen
Erfolge dieses Bildungszentrums
Sämtlich Kurse sind auf dem neuesten Stand
Die Durchschnittsbewertung liegt über 3,7
Mehr als 50 Meinungen in den letzten 12 Monaten
Dieses Bildungszentrum ist seit 15 Mitglied auf Emagister
Themen
- Basic
- OLAP
Inhalte
Zusätzliche Informationen
Oracle Database 11g: Data Warehousing Fundamentals