Data Warehousing Courses and Certifications

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

Introduction to Databricks SQL

834 ratings at DataCamp

Every organization has a need for a data warehousing capability to run critical business intelligence analyses.

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

Career Certificate

IBM Data Engineering

62632 ratings at Coursera

Build ETL pipelines with Python and shell scripts, query relational and NoSQL databases with SQL, and process big data using Airflow, Kafka, and Spark.

• Coursera
• 24 weeks, 10 hours a week
• Self-Paced
• Paid Course
• 16 courses

Career Certificate

IBM Relational Database Administrator with GenAI

61962 ratings at Coursera

Learn to design, secure, and tune relational databases in MySQL, PostgreSQL, and IBM Db2, writing SQL queries, building data warehouses, and automating ETL with Airflow and Kafka.

• Coursera
• 24 weeks, 10 hours a week
• Self-Paced
• Paid Course
• 11 courses

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

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

Data Council

Embedding OLAP, Everywhere - Lessons from Okta

Discover Okta's journey from traditional data processing to embedded OLAP systems, exploring the shift to mini serverless databases and how databases are re-entering application engineering domains.

• YouTube
• 25 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

The ASF

Apache Doris - Separation of Storage and Compute Architecture

Discover how Apache Doris implements separation of storage and compute architecture, exploring key design principles and technical implementations for enhanced OLAP database performance.

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

The ASF

Dive into Vectorized Execution for Apache Cloudberry - Design, Challenges, and Performance Gains

Explore vectorized execution implementation in Apache Cloudberry, covering architectural design decisions, technical challenges, and significant performance improvements.

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

The ASF

Replicas as a Strength, Not a Burden - Scalable Consensus for OLAP Engines with LSM Storage

Discover how replicas enhance OLAP engines with LSM storage through scalable consensus mechanisms, transforming traditional burdens into performance strengths for IoT applications.

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

Data Types and Functions in Snowflake

559 ratings at DataCamp

Nail down the fundamentals of Snowflake, starting with data types.

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

Window Functions in Snowflake

554 ratings at DataCamp

Unlock a slew of new problem-solving tools with the power of Snowflake window functions!

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