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

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

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

Learn ClickHouse® - A Fast Open-Source OLAP DBMS

627 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
• Self-Paced
• Paid Course

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

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
• Self-Paced
• 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
• 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

ByteGrad

The Ultimate Next.js Dashboard Stack - Shadcn, WebSocket/SSE, OLTP/OLAP Database

Master building powerful analytics dashboards with Next.js using Shadcn UI, WebSocket/SSE for real-time updates, and OLTP/OLAP databases including DuckDB and Hydra integration.

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

Database Design

Learn to design databases in SQL to process, store, and organize data in a more efficient way.

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

Data Warehousing Concepts

1 rating

This introductory and conceptual course will help you understand the fundamentals of data warehousing.

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

EuroPython Conference

Slicing and Dicing with Cubes - Light-weight OLAP Framework and Server

Explore lightweight OLAP framework for efficient data analysis, slicing, and dicing using Cubes. Learn server implementation and advanced techniques for multidimensional data processing.

• YouTube
• 2 hours 3 minutes
• Self-Paced
• Conference Talk