Learn Data Warehouse and ODI 11g - Step by Step Guide

Find out how to create and manage Data warehouse and ETL life cycle with ODI
3.4 (32 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
311 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 37
  • Length 4 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2015 English

Course Description

Would you like to be a data warehouse expert with Independent Concept Data Warehouse Training? In order to professionalize you at this topic, we gathered up all of the trainings and performed the application of the theorical informations to provide a better education.

After obtaining these informations, you’ll learn the Data Warehouse systems and its properties. In this training, all of the abilities that a Data Warehouse & Business intelligence specialist must have will be explained. In the end of the course, we’ll present a live sample of data warehouse. By using ODI (Oracle Data Integration) in the training’s content, you won’t need to do extra payment for the training of ETL tools. You’ll be able to have a wide range of informations over the topics listed bellow:

Data Warehouse

  • Data ,Entegration,Knowledge
  • Data Warehouse Definition
  • ETL/ELT Architecture
  • Incremental Load
  • Batch Load
  • Real Time Load
  • Change Data Capture
  • Real Time
  • Continuosly
  • Batch
  • Slowly Changing Dimension
  • Data Modelling
  • Conceptual Data Model
  • Logical Data Model
  • Physical Data Model
  • Fact Table
  • Dimension Table
  • Operational Database Properties and structure(OLTP)
  • Data Warehouse Schema Architecture
  • Stagingn Area Properties and structure(STG)
  • Operational Data Store Properties and structure(ODS)
  • Datawarehouse Properties and structure(DWH)
  • Datamart Properties and structure(DM)
  • Data Profiling
  • Data Quality
  • Data Cleaning
  • Metadata Management
  • End to End Data Warehouse Project Demo


ODI (Oracle Data Integrator)

  • Introduction to Oracle Data Integrator 11g
  • Introduction to oracle Data integrator
  • ODI Studio Components
  • ODI Repositories
  • Creating Master Repository
  • Creating work Repository
  • Overview of Topology Navigator
  • Creating Physical Architecture
  • Creating a Data Server
  • Testing a Data Server Connection
  • Creating a Physical Schema
  • Creating Logical Architecture
  • Overview of Logical Architecture and Context Views
  • Linking the Logical and Physical Architecture
  • Understanding Metadata in ODI
  • Understanding Reverse Engineering
  • Creating Models
  • Organizing Models
  • Creating Data stores
  • Overview of ODI Projects
  • Creating a New Project
  • Introduction to Knowledge Modules
  • Types of Knowledge modules
  • Creating a Basic Interface
  • Designing an Interface
  • Integration knowledge module (IKM) overview
  • Using Knowledge Modules (KM) with ODI Interface
  • Executing the interface
  • Operator Overview
  • Viewing the session log in operator
  • Exploring the code in operator
  • Creating simple mappings
  • Setting knowledge module option Truncate to True
  • Join Transformations
  • Set Operators Transformations
  • Implementing SCD Type-1 Transformations
  • Implementing SCD Type-2 Transformation
  • Creating Packages in ODI

Why you should have this course?

Because;

I’m not just talking about the concept, but with its installations, I’m moving on with examples over ODI suitable for data warehouse structure and heavily used in the sector.

Despite the course language is English, I’m providing English subtitles support in order not to miss important points.

With various documents and end-of-chapter quizes, I aim to reinforce the topics.

As being more than 10 years in the sector and being an instructor in companies that have big DWH structures, I provide this course.

You are choosing an instructor that can provide support for any type of questions about the training or about DWH structures that does not fall within the training.

What are the requirements?

  • Internet access

What am I going to get from this course?

  • In the end of the course, you’ll design a live sample of data warehouse
  • Step by Step Data Warehouse Components and Structures
  • Implementing SCD Type-1 and SCD Type-2 Transformations in ODI
  • Development Jobs with using ETL and ELT logic
  • Using Knowledge Modules (KM) with ODI Interface
  • Understanding Reverse Engineering
  • Creating Master and Work Repository
  • Creating a Physical and logical Schema
  • Creating Model,Interface

What is the target audience?

  • Students
  • Private company employees
  • Developers
  • Analysts
  • Those who wants to develop themselves in Data Warehouse and Business Intelligence subjects
  • Data Scientists
  • Database Managers
  • Those who wants to learn ODI product and develop themselves in this subject

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Section 1: Introduction
02:01

Course Description

Section 2: Section 2: Data Warehouse Fundamentals
Definition of a data warehouse and Properties
Preview
02:44
Top-Down and Bottom-up Approach
Preview
02:00
Defining Inmon Methodology
Preview
05:09
Defining Kimball Methodology
01:48
Overview of Extraction, Transformation, and Loading
02:47
Overview of Change Data Capture(CDC)
09:37
Understanding Slowly Changing Dimensions(SCD)
04:04
Data Modeling and Relational Database Design
08:01
OLTP(Online Transactional Processing)
02:27
Staging Area(STG)
06:11
Operational Data Store (ODS)
01:59
Data Warehouse Structure
02:25
Data Mart Concepts
03:29
Data Warehousing Logical Design and Schema Approches
05:14
Performing Data Profiling
01:10
Data Quality Guide
12:15
Describing Database Metadata
02:17
Section 3: Section 3: Installation And Examples of Oracle Data Integrator (ODI)
07:21

How to Install Oracle Data Integrator

Creating and Connecting to ODI Master Repository
04:41
Creating and Connecting to ODI Work Repository
02:50
Setting Up the Oracle Data Integrator Topology(Physical and Logical)
03:18
Creating and Using Data Models at ODI
Preview
01:39
Create a Project & Knowledge Module & Interface
07:45
Filter Interface
02:59
Join Transformation
04:31
Setting Up an ODI Agent
06:52
Section 4: Section 4 :Live Demo
Creating and Using Mappings
14:07
Mirror Modelling
19:19
Data Warehouse Modelling 1
17:25
Data Warehouse Modelling 2
17:06
Data Warehouse Modelling 3
19:23
Data Warehouse Modelling 4
19:23
Section 5: Section 5 :Documentation
ODI Questions and Answers
5 pages
DWH Questions and Answers
4 pages
10 Things that must be done while starting Datawarehouse Project
1 page
10 Mistakes that are commonly done in Datawarehouse Projects
1 page

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Yusuf Arslan, DWH/Business Intelligence & Big Data Architect

For 10 years of my work life, I’m continuing to work as an architect of Business Intelligence & Data Warehouse. I’ve realized projects over Data Warehouse and Business Intelligence in different technologies (Oracle, IBM, Teradata, Microsoft, SAP). Since 8 years, I’ve been giving trainings over Data Warehouse,SQL, Database and Business Intelligence.

Also I provide to training Companies, students and worker about BI, DWH, Reporting Tools etc.. in IT Sector.

Finally, My specialities are Modelling of DWH, ETL Development, Design of Reporting,Data Replication, Data Migration, Master Data Management, Metadata Management, Big Data.


Thanks - Good Luck!

Instructor Biography

Mustafa Aksoy, DWH Architect & Data Scientist

After graduation from university I started to work as a DWH-ETL Developer in the telecommunication company. I am a data warehousing and ETL specialist having over 5+ years of experience in telecommunication and banking Industry.

Now, I am here to share my Know-how, experience and advantages of working Data Warehouse and ETL projects with them who want to plan students' career in DWH-BI and for them who want to learn about these technologies and discover further.

good luck!

Ready to start learning?
Take This Course