Data Warehousing Courses and Certifications

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
• On-Demand
• Free Video

Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics

434 ratings at LinkedIn Learning

Supercharge your Snowflake skills with this deep dive into architecture and advanced settings.

• LinkedIn Learning
• 2 hours 9 minutes
• On-Demand
• Free Trial Available

Databricks

Slowly Changing Dimensions Type 2 in Data Lakes - Tech Chat

Explore Slowly Changing Dimensions Type 2 in data lakes using Delta Lake, focusing on market segmentation for a climbing eCommerce site. Learn to track historical and current data effectively.

• YouTube
• 1 hour 1 minute
• On-Demand
• Free Video

Bryan Cafferky

Understand Slowly Changing Dimensions

Learn to handle Slowly Changing Dimensions in data warehousing, including SCD types, their implementation, and impact on star schema design. Gain expertise for interviews and practical applications.

• YouTube
• 23 minutes
• On-Demand
• 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
• On-Demand
• Free Video

NITTTR

Data Sciences: Data Warehousing and Data Mining

Master data warehousing architectures, OLAP operations, and mining techniques including classification, clustering, and association rules for data-driven decision-making.

• Swayam
• 12 weeks
• On-Demand
• Free Online Course

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
• On-Demand
• Paid Course

Master SAP HANA's SQL-based data warehousing methodology, from architecture design to production deployment, including tables, flowgraphs, and virtual layers development.

• SAP Learning
• 3 hours 39 minutes
• On-Demand
• Free Online Course

BigQuery for Data Warehousing

Master data warehousing with BigQuery: optimize ETL, analyze terabytes of data, and learn best practices for creating, querying, and troubleshooting large-scale datasets on Google Cloud.

• Google Skills
• 6 hours
• On-Demand
• Paid Course

Amazon Web Services;  Amazon

Amazon Redshift - Best Practices for Data Warehousing on AWS

Master data warehousing optimization techniques for Amazon Redshift, covering table design, query performance, workload management, and data modeling best practices to enhance database efficiency and performance.

• AWS Skill Builder
• 30 minutes
• On-Demand
• Free Certificate

Learn to design and implement cloud-based data warehousing solutions using Amazon Redshift. Explore data collection, storage, preparation, and analysis techniques with various AWS services and BI tools.

• Independent
• 5-6 hours
• On-Demand
• Free Online Course

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
• On-Demand
• 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
• On-Demand
• Free Video

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
• On-Demand
• 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
• On-Demand
• Free Video