YoVDO

Data Warehouse - The Ultimate Guide

Offered By: Udemy

Tags

Data Warehousing Courses Business Intelligence Courses Data Analysis Courses Data Engineering Courses Dimensional Modeling Courses

Course Description

Overview

Master Data Warehousing, Dimensional Modeling & ETL process

What you'll learn:
  • Architect & implement a professional data warehouse end-to-end
  • You will learn the principles of Data Warehouse Design
  • You will master ETL process in both theory & practise
  • You will implement in a case study your own data warehouse & ETL process
  • You will learn the modern architecture of a Data Warehouse
  • Dimensional Modeling in a professional way

Master Data Warehousing, Dimensional Modeling & ETL process

Do you want to learn how to implement a data warehouse in a modern way?

This is the only course you need to master architecting and implementing a data warehouse end-to-end!


Data Modeling and data warehousing is one of the most important skills in Business Intelligence &Data Engineering!

This is the most comprehensive &most modern course you can find on data warehousing.


Here is why:

  • Most comprehenisve course with 9 hours video lectures

  • Learn from a real expert - crystal clear & straight-forward

  • Master theory &practice - hands-on demonstrations, assignments &quizzes

  • We will implement a complete data warehouse - end-to-end

  • Understand everything step by step from the absolute basics to the advanced topics

  • Learn the practical steps and the important theory to upskill your career

This course will take you all the way to being able to architect and implement a data warehouse in a company in a professional manner.


Here is what you'll learn:

  • Data Warehouse Basics

  • Data Warehouse architecture

  • Data Warehouse infrastructure

  • Data Modeling

  • Setting up an ETLprocess

  • Dimensional Modeling:Facts &Dimensions

  • Implementing a comeplete data warehouse hands-on

  • Slowly Changing Dimensions

  • Understanding ETLtools

  • ELTvs. ETL

  • Advanced topics like:Columnar storage, OLAPCubes, In-memory databases, massive parallel processing &cloud data warehouses

  • Optimizing a data warehouse using indexes (B-tree indexes &Bitmap indexes)

  • Practically using and connecting a data warehouse


By the end of this course you will be able to design &build a complete data warehouse from the ground up. You will have the knowledge, the practical skills and the confidence to implement a modern data warehouse professionally.

Everything you need to be a highly proficient data architect, data engineer, data analyst or Business Intelligence expert!


Join now to get instant & lifetime access - of course backed by the no-questions-asked 30 days money back guarantee!





Taught by

Nikolai Schuler

Related Courses

Building Your First ETL Pipeline Using Azure Databricks
Pluralsight
Dimensional Modeling on the Microsoft SQL Server Platform
Pluralsight
Implementing a Data Warehouse SQL Server 2019
LinkedIn Learning
Designing a Data Warehouse on the Microsoft SQL Server Platform
Pluralsight
Enterprise Data Modeling: Getting Started
Pluralsight