Oracle Database: Data Warehousing Techniques Ed 1

Cost $3,600

Course Code
D101878GC10

Duration
3 days

Format
Live Virtual Class

What you will learn

In this course, students learn about the following:

  • Extraction, transformation, and loading techniques in a typical data warehouse. 
  • Gain knowledge about improving performance or manageability in a data warehouse using various Oracle Database features. 
  • Identify the basics of Oracle’s Database partitioning architecture and identify the benefits of partitioning. 
  • Review the benefits of parallel operations to reduce response time for data-intensive operations. 
  • Understand the benefits of using Oracle’s materialized views to improve data warehouse performance. 
  • Understand how data warehousing is a compelling decision support solution in a typical business environment. 

Prerequisites

Required Prerequisite Courses: Data Warehousing Concepts Ed 1 Required Prerequisite Skills: Basic knowledge of data warehouse concepts and related terminology. Relational database concepts and Oracle server concepts including application and server tuning, and the operating system environment under which you are running the Oracle Database Server. Good working knowledge of the SQL language.

Audience

  • Data warehouse developers
  • Data warehouse engineers
  • Data warehouse analysts
  • Data warehouses builders and administrators
  • Data warehouse implementation team members
  • Data warehouse developers

Objectives

  • Upon completion of this course, the student should be able to:
    • Describe methods and tools for extracting, transforming, and loading data.
    • Describe the benefits of partitioning in a data warehouse.
    • Use parallel operations to reduce response time for data-intensive operations.
    • Create, use, and refresh materialized views to improve data warehouse performance.
    • Explain the implementation and organizational issues surrounding a data warehouse project.

Topics

  • Introduction
  • Data Warehousing Concepts
  • Data Extraction Techniques
  • Introduction to Data Transformation
  • Data Transformation Techniques
  • Data Loading Techniques
  • Database Sizing, Storage, and Security Considerations
  • Data Refresh Techniques
  • Summary Management
  • Leaving a Metadata Trail
  • Data Warehouse Implementation Considerations

Enroll for Oracle Database: Data Warehousing Techniques Ed 1

Oracle Database: Data Warehousing Techniques Ed 1

$3,600.00

SKU: D101878GC10 Categories: ,

Additional information

Schedules

Jun 21 2021 – Jun 23 2021 (3 days) 9:00 AM – 5:00 PM US-Pacific

Format

Live Virtual Class

Reviews

There are no reviews yet.

Be the first to review “Oracle Database: Data Warehousing Techniques Ed 1”

Your email address will not be published. Required fields are marked *

No products were found matching your selection.

Follow-on Courses

Browse the suggested follow-on courses below and continue your training journey. We offer training in various learning formats, from instructor-led to virtual, so you can choose what works best for you. Get started by selecting a course to learn more.

No products were found matching your selection.

TOP
0