咨詢郵箱:tata@tatait.com 咨詢電話：0755-29152000 新浪微博：@塔塔IT 微信：添加公眾賬號(hào)“tatait”加關(guān)注
訪問統(tǒng)計(jì)：
OCM - Oracle數(shù)據(jù)倉(cāng)庫(kù)技術(shù) Data Warehouse
In this course, students learn the basic concepts of a data warehouse and study the issues involved in planning, designing, building, populating, and maintaining a successful data warehouse. Students learn to improve performance or manageability in a data warehouse using various Oracle Database features.
Students also learn the basics about Oracle’s Database partitioning architecture and identify the benefits of partitioning. Students review the benefits of parallel operations to reduce response time for data-intensive operations. Students learn about the extract, transform, and load of data phase (ETL) into an Oracle database warehouse. Students learn the basics about the benefits of using Oracle’s materialized views to improve the data warehouse performance. Students also learn at a high level how query rewrite can improve a query’s performance. Students review OLAP and Data Mining and identify some data warehouse implementations considerations.
Students briefly use some of the available data warehousing tools such as Oracle Warehouse Builder, Analytic Workspace Manager, and Oracle Application Express.
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
課程對(duì)象：
Application Developers
Data Warehouse Administrator
Data Warehouse Analyst
Data Warehouse Developer
Developer
Functional Implementer
Project Manager
Support Engineer
課程目標(biāo)：
Define the terminology and explain the basic concepts of data warehousing
Describe methods and tools for extracting, transforming, and loading data
Identify some of the tools for accessing and analyzing warehouse data
Identify the technology and some of the tools from Oracle to implement a successful data warehouse
Define the decision support purpose and end goal of a data warehouse
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
Use materialized views and query rewrite to improve the data warehouse performance
Develop familiarity with some of the technologies required to implement a data warehouse
課程時(shí)間：3天
課程內(nèi)容：
Introduction
Course Objectives
Course Schedule
Course Pre-requisites and Suggested Pre-requisites
The sh and dm Sample Schemas and Appendices Used in the Course
Class Account Information
SQL Environments and Data Warehousing Tools Used in this Course
Oracle 11g Data Warehousing and SQL Documentation and Oracle By Examples
Continuing Your Education: Recommended Follow-Up Classes
Data Warehousing, Business Intelligence, OLAP, and Data Mining
Data Warehouse Definition and Properties
Data Warehouses, Business Intelligence, Data Marts, and OLTP
Typical Data Warehouse Components
Warehouse Development Approaches
Extraction, Transformation, and Loading (ETL)
The Dimensional Model and Oracle OLAP
Oracle Data Mining
Defining Data Warehouse Concepts and Terminology
Data Warehouse Definition and Properties
Data Warehouse Versus OLTP
Data Warehouses Versus Data Marts
Typical Data Warehouse Components
Warehouse Development Approaches
Data Warehousing Process Components
Strategy Phase Deliverables
Introducing the Case Study: Roy Independent School District (RISD)
Business, Logical, Dimensional, and Physical Modeling
Data Warehouse Modeling Issues
Defining the Business Model
Defining the Logical Model
Defining the Dimensional Model
Defining the Physical Model: Star, Snowflake, and Third Normal Form
Fact and Dimension Tables Characteristics
Translating Business Dimensions into Dimension Tables
Translating Dimensional Model to Physical Model
Database Sizing, Storage, Performance, and Security Considerations
Database Sizing and Estimating and Validating the Database Size
Oracle Database Architectural Advantages
Data Partitioning
Indexing
Optimizing Star Queries: Tuning Star Queries
Parallelism
Security in Data Warehouses
Oracle’s Strategy for Data Warehouse Security
The ETL Process: Extracting Data
Extraction, Transformation, and Loading (ETL) Process
ETL: Tasks, Importance, and Cost
Extracting Data and Examining Data Sources
Mapping Data
Logical and Physical Extraction Methods
Extraction Techniques and Maintaining Extraction Metadata
Possible ETL Failures and Maintaining ETL Quality
Oracle’s ETL Tools: Oracle Warehouse Builder, SQL*Loader, and Data Pump
The ETL Process: Transforming Data
Transformation
Remote and Onsite Staging Models
Data Anomalies
Transformation Routines
Transforming Data: Problems and Solutions
Quality Data: Importance and Benefits
Transformation Techniques and Tools
Maintaining Transformation Metadata
The ETL Process: Loading Data
Loading Data into the Warehouse
Transportation Using Flat Files, Distributed Systems, and Transportable Tablespaces
Data Refresh Models: Extract Processing Environment
Building the Loading Process
Data Granularity
Loading Techniques Provided by Oracle
Postprocessing of Loaded Data
Indexing and Sorting Data and Verifying Data Integrity
Refreshing the Warehouse Data
Developing a Refresh Strategy for Capturing Changed Data
User Requirements and Assistance
Load Window Requirements
Planning and Scheduling the Load Window
Capturing Changed Data for Refresh
Time- and Date-Stamping, Database triggers, and Database Logs
Applying the Changes to Data
Final Tasks
Materialized Views
Using Summaries to Improve Performance
Using Materialized Views for Summary Management
Types of Materialized Views
Build Modes and Refresh Modes
Query Rewrite: Overview
Cost-Based Query Rewrite Process
Working With Dimensions and Hierarchies
Leaving a Metadata Trail
Defining Warehouse Metadata
Metadata Users and Types
Examining Metadata: ETL Metadata
Extraction, Transformation, and Loading Metadata
Defining Metadata Goals and Intended Usage
Identifying Target Metadata Users and Choosing Metadata Tools and Techniques
Integrating Multiple Sets of Metadata
Managing Changes to Metadata
Data Warehouse Implementation Considerations
Project Management
Requirements Specification or Definition
Logical, Dimensional, and Physical Data Models
Data Warehouse Architecture
ETL, Reporting, and Security Considerations
Metadata Management
Testing the Implementation and Post Implementation Change Management
Some Useful Resources and White Papers
特色服務(wù)
公開課不限時(shí)間免費(fèi)復(fù)聽，打消您因時(shí)間不便帶來的后顧之憂。
上課期間人手一臺(tái)計(jì)算機(jī)，強(qiáng)調(diào)動(dòng)手能力，實(shí)戰(zhàn)能力，重視理論聯(lián)系實(shí)際。
課余時(shí)間標(biāo)準(zhǔn)實(shí)驗(yàn)室長(zhǎng)期免費(fèi)開放，并有講師專門輔導(dǎo)。
學(xué)員可免費(fèi)參加塔塔組織的技術(shù)、產(chǎn)品講座及研討會(huì)。
免費(fèi)向?qū)W員提供相關(guān)方面的最新技術(shù)動(dòng)態(tài)。
免費(fèi)為學(xué)員推薦工作。
培訓(xùn)結(jié)束后提供12個(gè)月的免費(fèi)電話及郵件咨詢服務(wù)。
如需了解更多課程詳情或開班信息，請(qǐng)聯(lián)系塔塔課程顧問：0755-29152000.
?優(yōu)惠活動(dòng)
08-21 IT服務(wù)管理--- ITIL? 2011 Foundation 認(rèn)證培訓(xùn)優(yōu)惠季（培訓(xùn)考試套餐）
08-14 塔塔思科8月優(yōu)惠活動(dòng)：學(xué)NA零費(fèi)用，學(xué)CCNP送CCSP，學(xué)CCIE報(bào)銷考試費(fèi)
08-12 塔塔IT 8月 CCNA優(yōu)惠活動(dòng) 報(bào)考試送培訓(xùn)
07-22 參加塔塔IT CCNP培訓(xùn)贈(zèng)送 CCSP 思科認(rèn)證資深安全工程師培訓(xùn)
07-22 8月報(bào)名VMware原廠認(rèn)證培訓(xùn)贈(zèng)送價(jià)值5600元16天 Cisco CCNP認(rèn)證培訓(xùn)
06-03 加關(guān)注塔塔微信或微博，尊享課程95折優(yōu)惠.
Copyright? 2012-2013 TATAIT.COM All Rights Reserved 深圳塔塔咨詢服務(wù)有限公司 版權(quán)所有 深圳網(wǎng)站建設(shè)：沙漠風(fēng)
塔塔—中高端IT培訓(xùn)專家，專注于IT前沿技術(shù)的傳播與應(yīng)用。專業(yè)創(chuàng)造價(jià)值，服務(wù)贏得口碑！
粵ICP備13034854號(hào)
