Oracle11g数据仓库课程


利用Oracle提供的数据仓库系统,企业可建立统一的数据信息平台,经过数据挖掘和决策分析,能有效地为市场营销和客户服务工作提供有力的支撑。


Oracle11g数据库仓库课程包含有基础课程和管理课程两个部分。


基础要求:有Oracle数据库使用经验,能熟练使用SQL语言。

学习实验环境:Linux虚拟化云环境。


 
Oracle11g数据仓库基础课程模块说明:

序号 模块说明
1 数据仓库(DW)和商业智能(BI)的地位
2 数据仓库的术语和基本概念
3 定义决策支持的目的与数据库仓库的目标
4 实施数据库仓库时所用的各种成熟的开发技术
5 确定在实施一个成功数据仓库时Oracle所使用的技术和工具
6 确定数据仓库建模概念
7 描述提取、转换和加载数据的方法和工具
8 确定Oracle11g数据库中对实施数据仓库所提供的功能
9 确定在实施一个成功数据仓库时Oracle所使用的技术和工具
10 描述联机分析处理(OLAP)和数据挖掘技术及工具
11 解释数据仓库项目中的实施和组织的问题
12 数据仓库案例研究


 
Oracle11g数据仓库管理课程模块说明:

序号 模块说明
1 数据库仓库基本概念的回顾
2 使用Oracle数据库的内置功能来改善数据仓库的性能及其可管理性
3 在数据库仓库中使用并行操作来减少数据密集型操作的响应时间
4 提取,转换和加载数据到Oracle数据库仓库
5 使用Oracle的汇总管理功能来提高数据仓库的性能


 
数据仓库基础课程内容介绍

  1. Introduction

序号 授课内容
1) Discuss the goals of the course
2) Identify the appendixes in this course
3) environments, database schemas, and tables that are used in the course
4) Identify some of the Oracle 11g data warehousing documentation and resources

  2. Data Warehousing, Business Intelligence, OLAP, and Data Mining

序号 授课内容
5) Describe the evolution of data warehouses from MIS
6) Describe how extract processing for decision-support querying led to data warehouse solutions
7) Identify the BI, OLAP, and data mining tools from Oracle
8) Identify the business drivers for data warehouses
8) Define OLAP and the Oracle Database 11g OLAP option
9) Compare Relational OLAP (ROLAP) and Multidimensional OLAP (MOLAP)
11) Describe the data mining concepts

  3. Defining Data Warehouse Concepts and Terminology

序号 授课内容
12) Identify a common, broadly accepted definition of a data warehouse
13) Describe the differences of dependent and independent data marts
14) Identify some of the main warehouse development approaches
15) Define some of the operational properties and common terminology of a data warehouse

  4. Business, Logical, Dimensional, and Physical Modeling

序号 授课内容
16) Discuss data warehouse environment data structures
17) Discuss data warehouse database design phases

  5. Database Sizing, Storage, Performance, and Security Considerations

序号 授课内容
18) Explain sizing techniques and test load sampling at a high level
19) Describe data warehouse partitioning methods
20) Describe indexing types and strategies
21) Explain parallelism in data warehouse operations
22) Explain the importance of security in data warehouses
23) Identify the tools and technologies provided by Oracle

  6. The ETL Process: Extracting Data

序号 授课内容
24) Outline the extraction, transformation, and loading (ETL) processes for building a data warehouse
25) Identify the ETL tasks, importance, and cost
26) Explain how to examine data sources
27) Identify extraction techniques and methods
28 Identify analysis issues and design options for extraction processes
29) List the selection criteria for the ETL tools
30) Identify Oracle's solution for the ETL process

  7. The ETL Process: Transforming Data

序号 授课内容
31) Define transformation
32) Identify possible staging models
33) Identify data anomalies and eliminate them
34) Explain the importance of quality data
35) Describe techniques for transforming data
36) Design the transformation process
37) List Oracle’s enhanced features and tools that can be used to transform data

  8. The ETL Process: Loading Data

序号 授课内容
38) Explain key concepts in loading warehouse data
39) Outline how to build the loading process for the initial load
40) Identify loading techniques
41) Describe the loading techniques provided by Oracle
35) Identify the tasks that take place after data is loaded
36) Explain the issues involved in designing the transportation, loading, and scheduling processes

  9. Refreshing the Warehouse Data

序号 授课内容
37) Describe methods for capturing changed data
38) Explain techniques for applying the changes
39) Describe refresh mechanisms supported in Oracle Database 11g
40) Describe techniques for purging and archiving data and outline the techniques supported by Oracle
41) Outline final tasks, such as publishing the data and automating processes

  10. Materialized Views

序号 授课内容
42) Discuss summary management and Oracle implementation of summaries
43) Describe materialized views(MV)
44) Identify the types, build modes, and refresh methods for materialized views
45) Explain the query rewrite mechanism in Oracle
46) Describe the significance of Oracle dimensions

  11. Leaving a Metadata Trail

序号 授课内容
47) Define warehouse metadata, its types, and its role in a warehouse environment
48) Examine each type of warehouse metadata
49) Develop a metadata strategy
50) Outline the Common Warehouse Metamodel(CWM)
51) Describe Oracle Warehouse Builder's compliance with Object Management Group’s Common Warehouse Metamodel(OMG-CWM)

  12. Data Warehouse Implementation Considerations

序号 授课内容
52) Describe the project management plan(PMP)
53) Specify the requirements for the implementation
54) Describe the metadata repository, technical architecture, and other considerations
55) Describe post-implementation change management considerations


 
数据仓库管理课程内容介绍

  1. Introduction

序号 授课内容
1) Discuss the goals of the course
2) Identify the appendixes in this course
3) Identify the environments, database schemas, and tables that are used in the course
4) Identify some of the Oracle 11g data warehousing documentation and resources

  2. Data Warehouse Design: Overview

序号 授课内容
5) Explain the basic concepts of a data warehouse
6) Explain the data warehouse logical and physical designs
7) Identify the data warehousing objects
8) List the available data warehousing schemas
9) Access additional information on data warehouse design and Oracle data warehouse technology

  3. Data Warehouse Tuning Considerations

序号 授课内容
10) Describe how to optimize a star query using star transformation
11) Describe the benefits of Bitmap Join Indexes

  4. Partitioning Concepts

序号 授课内容
12) Outline the Oracle Database partitioning architecture
13) List the available partitioning strategies
14) Describe the benefits of partitioning
15) Create partitioned tables and partitioned indexes
16) Describe partition enhancements to star query optimization

  5. Parallelism Concepts

序号 授课内容
17) Explain the benefit of using parallel operations
18) List operations that can be parallelized and how they work
19) Describe parallel execution terminology
20) Control the parallel execution server pool
21) Enable parallel execution
22) Interpret a parallel execution plan
23) Leverage 11gR2 enhancements for parallel execution

  6. Parallel Operations in Data Warehouses

序号 授课内容
24) Apply parallel query to tables and indexes
25) Describe parallel join types
26) Perform parallel DDL and DML operations
27) Set initialization parameters relating to parallel operations tuning
28) Query dynamic performance views related to parallel operations tuning

  7. Extraction, Transformation, and Loading (ETL): Extraction and Transportation

序号 授课内容
29) Describe ETL framework inside the database and its integration advantage
30) Explain data warehousing extraction methods
31) Identify transportation methods: Flat file, Distributed operations, Transportable tablespaces
32) Describe the transformation flow

  8. Extraction, Transformation, and Loading (ETL): Loading

序号 授课内容
33) Load a data warehouse using SQL*Loader
34) Load a data warehouse using external tables
35) List other methods for loading a data warehouse

  9. Extraction, Transformation, and Loading (ETL): Transformation

序号 授课内容
36) Compare multistage and pipeline transformation
37) Explain transformation using SQL
38) Describe transformation using table functions and PL/SQL
39) Implement data manipulation language (DML) Error Logging

  10. Materialized Views

序号 授课内容
40) Describe how summaries can be used to improve performance
41) Differentiate materialized view types
35) Explain materialized view integrity
36) Create a materialized view
37) Maintain materialized views
38) List globalization implications for materialized views

  11. Refreshing Materialized Views

序号 授课内容
39) Describe the various refresh methods and modes
40) Create materialized view logs
41) Refresh and explain materialized views by using the DBMS_MVIEW package
42) Discuss summary management and Oracle implementation of summaries
43) Use Partition Change Tracking (PCT) and fast refreshes
44) Analyze materialized views by using the EXPLAIN_MVIEW package
45) Describe general tips for refreshing materialized views

  12. Working with Dimensions

序号 授课内容
46) Describe the need for dimensions
47) Create dimensions
48) View dimension definition information
49) Validate dimension data and maintain dimensions
50) Outline the Common Warehouse Metamodel(CWM)
51) Describe Oracle Warehouse Builder's compliance with Object Management Group’s Common Warehouse Metamodel(OMG-CWM)
52) Describe the project management plan(PMP)
53) Specify the requirements for the implementation
54) Describe the metadata repository, technical architecture, and other considerations
55) Describe post-implementation change management considerations

  13. Query Rewrite

序号 授课内容
56) Use query rewrite
57) Identify the available query rewrite methods
58) Partition Change Tracking (PCT) and query rewrite
59) Use the query rewrite enhancement to support queries with inline views

  14. Using the SQL Access Advisor, Compression, and Resumable Sessions

序号 授课内容
60) Use the Enterprise Manager SQL Access Advisor graphical interface to optimize your entire workload
61) Use the SQL Access Advisor PL/SQL procedures
62) Tune materialized views for fast refresh and query rewrite
63) Use the features of compression and resumable sessions

关于我们 | 新闻中心 | 合作伙伴 | 联系我们 |
西安优盛信息技术有限公司  版权所有©2007-2018  陕ICP备07501629号
在线客服系统