Data Warehousing Courses and Certifications

Data Warehousing & Pipeline Development in Microsoft Fabric

Build data warehouses and ETL/ELT pipelines in Microsoft Fabric: design star, snowflake, and data vault schemas, write T-SQL transformations, and set up Git-based CI/CD.

• Coursera
• 5 weeks, 5 hours a week
• Self-Paced
• Paid Course

Career Certificate

Data Warehouse Engineering

Design, deploy, and manage enterprise data warehouses: query with SQL, administer relational databases, automate tasks with Bash, and build ETL pipelines using Apache Airflow and Kafka.

• edX
• 34 weeks, 2-10 hours a week
• Self-Paced
• $649.00
• 8 courses

Creating a Data Warehouse Through Joins and Unions

This lab focuses on how to create new reporting tables using SQL JOINS and UNIONs.

• Google Skills
• 1 hour
• Self-Paced
• Paid Course

Bryan Cafferky

Dimensional Modeling

Learn Kimball dimensional modeling through facts, dimensions, star and snowflake schemas, surrogate keys, grain, bus matrices, and slowly changing dimensions.

• YouTube
• 54 minutes
• Self-Paced
• Free Video

CMU Database Group

CMU Advanced Database Systems - Spring 2024

Master advanced database system internals including OLAP architectures, query optimization, vectorized execution, and modern data warehouse implementations like BigQuery and Snowflake.

• YouTube
• 1 day 3 hours 12 minutes
• Self-Paced
• Free Video

The ASF

Apache Impala's Latest Practices in Visionary Data Warehousing

Explore Apache Impala's latest practices in visionary data warehousing, covering priority scheduling, elastic computing, and materialized views. Gain insights from real-world applications and future prospects.

• YouTube
• 39 minutes
• Self-Paced
• Free Video

Bryan Cafferky

Understand Slowly Changing Dimensions

Explains how data warehouse architectures handle changing dimension values through overwrite, full history, limited history, and hybrid approaches.

• YouTube
• 23 minutes
• Self-Paced
• Free Video

CMU Database Group

Modern OLAP Database Systems - Lecture 1

Explore modern OLAP database systems, their architectures, and optimizations for analytical workloads in this advanced lecture from Carnegie Mellon University.

• YouTube
• 1 hour 9 minutes
• Self-Paced
• Free Video

CMU Database Group

Modern Analytical Database Systems - Lecture 2

Explore modern analytical database systems, covering distributed architectures, query execution, and OLAP commoditization in this advanced CMU lecture.

• YouTube
• 53 minutes
• Self-Paced
• Free Video

CodeWithYu

Designing Data Warehouse from Scratch - End-to-End Data Engineering

Master end-to-end data warehouse design, from logical architecture to physical implementation. Learn AWS Redshift, data loading, and medallion architecture for efficient data engineering.

• YouTube
• 2 hours 41 minutes
• Self-Paced
• Free Video

Database Design

8115 ratings at DataCamp

A good database design is crucial for a high-performance application.

• DataCamp
• 4 hours
• Self-Paced
• Free Trial Available

Introduction to Snowflake SQL

5969 ratings at DataCamp

Dive into Snowflake's universe!This course will teach you the fundamentals of Snowflake SQL - the unique SQL flavor used to interact with Snowflake data warehouses.

• DataCamp
• 2 hours
• Self-Paced
• Free Trial Available

Introduction to Snowflake

4686 ratings at DataCamp

Introduction to Snowflake In Introduction to Snowflake, you will learn how to navigate and use Snowflake, a leading cloud-based data warehousing platform.

• DataCamp
• 2 hours
• Self-Paced
• Free Trial Available

Introduction to dbt

2686 ratings at DataCamp

dbt, or the data build tool, has taken the data world by storm.

• DataCamp
• 4 hours
• Self-Paced
• Free Trial Available

Introduction to Data Modeling in Snowflake

1595 ratings at DataCamp

Step right into the dynamic world of data modeling with Snowflake!

• DataCamp
• 4 hours
• Self-Paced
• Free Trial Available