Data Warehousing Courses and Certifications

Amazon Web Services;  Amazon

Digital Classroom - Data Warehousing on AWS

Master Amazon Redshift's capabilities for cloud data warehousing, from ingestion to transformation, while implementing best practices for security, performance tuning, and integration with AWS services.

• AWS Skill Builder
• 1 day
• Self-Paced
• Paid Course

CodeWithYu

Building Realtime Data Warehouses from Scratch - End-to-End Data Engineering Project

Design and implement a real-time data warehouse with Apache Airflow, Kafka, and Pinot. Create custom hooks, ingest batch and streaming data, and visualize evolving data using Apache Superset.

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

CMU Database Group

Row vs. Column Storage and Compression in Database Systems - Lecture 5

Explore row vs. column storage, compression techniques, and real-world database applications with insights from CMU's Andy Pavlo and StarTree's Xiang Fu.

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

CMU Database Group

Yellowbrick Data Warehouse System - Lecture 21

Explore Yellowbrick's innovative data warehouse system, its architecture, and performance optimizations for analytical workloads in this advanced database systems lecture.

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

CMU Database Group

Modern Data Warehouse Systems: BigQuery, Snowflake, Redshift, Databricks, and DuckDB - Lecture 25

Explore modern data warehouse architectures and cloud-native databases, comparing BigQuery, Snowflake, Redshift, Databricks, and DuckDB's unique features and use cases for data analytics.

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

Breaking Out of the Proprietary Cage - Real-time Data Warehouses in Open Source

Explore real-time data warehouses in open source, focusing on ClickHouse's architecture, performance optimization, and integration patterns for modern analytics applications.

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

Open Data Science

Spark, Cloud, DBT, Data Warehouses Etc. - Navdeep Kaur

Explore current trends in Data Engineering, including the shift towards new data stacks, tech used by companies, reasons for change, and the transition to data warehouses and delta lakes.

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

Databricks

What's New in Databricks SQL with Live Demos

Live demos showcase Databricks SQL's latest features for data warehousing, including AI assistants, streamlined interfaces, and performance optimizations, empowering users to efficiently create, transform, and analyze data.

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

SQLBits

Building Tomorrow's Warehouse Today - Modern Data Warehouse Modelling Insights

Explore fundamental shifts in data warehousing architecture and processing design principles for modern, efficient data management and analysis.

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

SQLBits

The Metadata-Driven Data Warehouse

Streamline data warehouse development using metadata-driven approaches. Learn efficient techniques for Insert/Update/Delete operations and pipeline management.

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

Conf42

Enterprise Data Warehouses for Nonprofits

Discover how enterprise data warehousing can transform nonprofit operations through improved data integration, quality modeling, and visualization, with practical case studies and implementation strategies.

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

Data Council

NAO: AI Code Editor for Streamlining Data Team Workflows

Discover NAO, an AI code editor built for data teams that unifies fragmented analytics engineering workflows across multiple tools, reducing context switching and enhancing productivity for data professionals.

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

Conf42

Building Predictive Analytics Data Warehouses in Healthcare

Discover how to architect scalable data warehouses for healthcare predictive analytics, covering real-time processing, ML models, and performance optimization strategies.

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

The MODERN Modern Data Stack - Building an Open Distributed Data Warehouse Beyond Data Lakes

Discover how to build distributed data warehouses using open-source Bacalhau, bringing compute to data locations to reduce costs and enable real-time edge analytics.

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

Career Certificate

Data Engineering with AWS

7 ratings

Learn to design data models, build warehouses and lakes, automate pipelines, and work with massive datasets using AWS. Gain practical skills in ETL, PostgreSQL, Cassandra, Spark, and Airflow.

• Udacity
• 39 hours
• Self-Paced
• Paid Course