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

d83527

D83527 - Java SE 8 Fundamentals

d79995

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

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
Enquire Now
 
 
 
 
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy