OLAP Courses and Certifications

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

OSACon

OLAP in Your App - Integrating Realtime and Agentic Analytics into Your App

Discover how to build conversation-fast analytics backends using open-source tools like ClickHouse, Postgres, and RedPanda for real-time AI chat systems and data visualizations.

• YouTube
• 22 minutes
• On-Demand
• Free Video

Databases: OLAP and Recursion

Explore advanced database concepts: OLAP for data analysis and recursive queries for hierarchical data. Enhance your SQL skills and deepen your understanding of complex database operations.

• edX
• 2 weeks, 8-10 hours a week
• On-Demand
• Free Online Course (Audit)

Herramientas de la Inteligencia de Negocios

246 reviews

Aprende el proceso de extraer y transformar data para generar insumos y tomar decisiones. Usa software, herramientas y sistemas de apoyo.

• edX
• 5 weeks, 5-6 hours a week
• On-Demand
• Free Online Course (Audit)

• Best of All Time

Learn ClickHouse® - A Fast Open-Source OLAP DBMS

602 ratings at Udemy

Learn ClickHouse® SQL, MergeTree and other table engines, Data replication, Sharding, and basic DBA tasks in ClickHouse®

• Udemy
• 5 hours 44 minutes
• On-Demand
• Paid Course

Data Engineering on AWS Vol 1 - OLAP & Data Warehouse

48 ratings at Udemy

Detailed training (Level 350) on AWS Data Engineering Services Redshift, S3, Athena, Hive, Glue Catalog, Lakeformation

• Udemy
• 1 day 22 hours 27 minutes
• On-Demand
• Paid Course

System Design-Data modeling for datawarehouses/OLAP DBs

32 ratings at Udemy

Data modeling in a data warehouse like RedShift/BigQuery/Snowflake

• Udemy
• 2 hours 16 minutes
• On-Demand
• Paid Course

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

CMU Database Group

Query Vectorization vs. Compilation in Advanced Database Systems - Lecture 10

Explore query vectorization and compilation techniques in advanced database systems, comparing their performance and implications for system design.

• YouTube
• 1 hour 6 minutes
• On-Demand
• Free Video

CMU Database Group

Analytical Database Indexes - Lecture 4

Explore advanced analytical database indexing techniques for optimizing query performance in OLAP systems. Learn about bitmap, zone maps, and other specialized indexes.

• YouTube
• 1 hour 22 minutes
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• Free Video