D56261 - Oracle Database 11g: Data Warehousing Fundamentals

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.

Duration: 3.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training

Objectives

Upon completing this course, the learner will be able to meet these overall objectives:

  • 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
  • Define the terminology and explain the basic concepts of data warehousing
  • Develop familiarity with some of the technologies required to implement a data warehouse

Content

  • Module 1: Introduction
  • Module 2: Data Warehousing, Business Intelligence, OLAP, and Data Mining
  • Module 3: Defining Data Warehouse Concepts and Terminology
  • Module 4: Business, Logical, Dimensional, and Physical Modeling
  • Module 5: Database Sizing, Storage, Performance, and Security Considerations
  • Module 6: The ETL Process: Extracting Data
  • Module 7: The ETL Process: Transforming Data
  • Module 8: The ETL Process: Loading Data
  • Module 9: Refreshing the Warehouse Data
  • Module 10: Materialized Views
  • Module 11: Leaving a Metadata Trail
  • Module 12: Data Warehouse Implementation Considerations

Audience

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

Prerequisites

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

Certification

product-certification

This course is not associated with any Certification.

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Oracle Popular Courses

d90871

This training is the first step in mastering MySQL, the world’s most popular open source database.

p10380

P10380 - Oracle Database 18c: Administration Workshop

d79995

Learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code.

d83527

D83527 - Java SE 8 Fundamentals
Enquire Now
 
 
 
 
KYoh57
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy