Trang chủ > Chương trình đào tạo Oracle > Oracle DBA 11g: Data Warehousing Fundamentals

NHẬP MÔN DATA WAREHOUSE CỦA ORACLE

 (Oracle DBA 11g: Data Warehousing Fundamentals)

 

 

WHAT YOU WILL LEARN


This Oracle Database 11g: Data Warehousing Fundamentals course 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.
Students are able 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.

 

AUDIENCE

 

  • Application Developers
  • Support Engineer
  • Data Warehouse Developer
  • Functional Implementer
  • Data Warehouse Administrator
  • Data Warehouse Analyst
  • Developer
  • Project Manager

 

COURSE OBJECTIVES

 

  • 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


CERTIFICATION


Upon completion of this course, students will receive the Certificate of Completion from SmartPro.


PREREQUISITES


Before attending this course, students must have:

  • Knowledge of general data warehousing concepts
  • Knowledge of client-server technology
  • Knowledge of relational server technology

 

COURSE DETAILS

 

  • Introduction
  • Data Warehousing, Business Intelligence, OLAP, and Data Mining
  • Defining Data Warehouse Concepts and Terminology
  • Business, Logical, Dimensional, and Physical Modeling
  • Database Sizing, Storage, Performance, and Security Considerations
  • The ETL Process: Extracting Data
  • The ETL Process: Transforming Data
  • The ETL Process: Loading Data
  • Refreshing the Warehouse Data
  • Materialized Views
  • Leaving a Metadata Trail
  • Data Warehouse Implementation Considerations  
EpI Oracle Corp HEAT PMI IT Service Management ICS 2 Microsoft Inc Cisco Corp

Địa chỉ: Lầu 6, toà nhà Thiên Sơn, 5-7-9 Nguyễn Gia Thiều, P.6, Quận 3, TP.HCM

Tel: (028) 39 333 376 - Fax: (028) 39 30 6767

Email: tuvan@smartpro.vn, sales@smartpro.vn

Chi nhánh: 8/12 Liễu Giai, Ba Đình, Hà Nội

Tel: (024) 37620196

Email: tuvan@smartpro.vn, sales@smartpro.vn

web counters