Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Data Warehousing and ETL Processing for Beginners
Rating: 4.5 out of 5(1 rating)
6 students

Data Warehousing and ETL Processing for Beginners

A Step by Step Guide to Understand Data Warehousing
Created byDavid Castanedo Varela
Last updated 10/2025
English

What you'll learn

  • Data Warehouse
  • How a Business Works From the Perspective of the Data
  • Architecture of a Data Warehouse
  • Different Types of Data Modelings and their Differences.
  • Different Types of Tables that are present in a Data Warehouse and their Differences.
  • Surrugate Keys
  • Slowly Changin Dimensions
  • ETL Process Exemplified in Every Section of the Course.
  • Data Lake vs Data Warehouse
  • At the end of the course you will understand how data is moved to a Data Warehouse, this will let you be more comfortable in the Data World

Course content

9 sections • 55 lectures • 2h 17m total length

  • Presentation2:00
  • Who am I?1:59
  • Read me1:05
  • Resources0:05

Requirements

  • Internet Access
  • Willing to Learn

Description

Introduction into Professional Data Warehousing and ETL Process Course

Do you want to learn how information is generated within a business, how it moves, and how it's stored for later analysis?

This course, under 3 hours long, is all you need to confidently master the theoretical foundations of the Data Warehousing world.

Data Warehousing is one of the most important topics in the ETL space, and you'd be surprised how many people I’ve worked with—despite having a senior-level background—still lack clarity on the topics we’ll cover in this course.

I will teach you EVERYTHING you need to know to stand out from the crowd.


Why choose this course:

  • The most comprehensive course under 3 hours, covering everything you need to know with zero filler content.

  • Understand all concepts step by step with ETL examples for better clarity.

  • After this course, you’ll be able to navigate the world of Data Warehousing, ETL, and Data Engineering with ease.

  • Learn from a professional with simple yet effective communication.

What you will learn:

  • Operational Side vs Analytical Side of a Business

  • Data Warehouse

  • Data Warehouse Architecture (Landing Zone, Core Data Layer, and Report Data Layer)

  • ETL Process

  • Relational Databases

  • Dimensional Modeling (Normalization and Denormalization)

  • Types of Tables in a Data Warehouse and their uses (Dimensions and Facts)

  • Surrogate Keys and their process within a Data Warehouse

  • Slowly Changing Dimensions (Types 0, 1, 2, and 3) explained through ETL processes

  • ETL Tools

  • ETL Process Components and Types (Tools, Load Types like Delta, Bulk, Batch, Workflows, Mappings, etc.)

  • ETL vs ELT and their differences

Each concept is applied in ETL examples for better understanding.

By the end of this course, you’ll be able to understand how data flows and how it is stored. You’ll gain the knowledge and the confidence to work in a Data Warehouse environment.

Join now and get instant, lifetime access with a no-questions-asked 30-day money-back guarantee!

Who this course is for:

  • People that wants to be introduced to the Data Engineering Space
  • Developers or People that support ETL systems.
  • Data Analysts that want to understand how Data Warehousing, Data Modeling and ETL process works.
  • People in the Data World that wants to have a clearer view of how data moves from its creation to its consumption.

Report abuse