OLAP Courses and Certifications

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

Database Design

57 ratings at DataCamp

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

• DataCamp
• 4 hours
• On-Demand
• Free Trial Available

Designing Data Systems

1 rating at Udacity

Learn to architect enterprise data systems by designing staging areas, operational data stores, and data warehouses. Gain hands-on experience with Snowflake, data transformation, and OLAP reporting using real-world datasets.

• Udacity
• 18 hours
• On-Demand
• Paid Course

Data Warehousing Concepts

29 ratings at DataCamp

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

• DataCamp
• 4 hours
• On-Demand
• 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
• On-Demand
• Conference Talk

EuroPython Conference

Cubes Light Weight OLAP FW Server

Explore lightweight OLAP framework server for efficient data analysis and reporting, focusing on Cubes implementation and benefits.

• YouTube
• 40 minutes
• On-Demand
• Conference Talk

CMU Database Group

Distributed Data Warehouse OLAP Databases - Lecture 23

Explore distributed data warehouse OLAP databases, covering architecture, query processing, and optimization techniques for large-scale analytical systems.

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

USENIX

Bridging the Gap between Relational OLTP and Graph-based OLAP

Explore GART, an innovative system bridging relational OLTP and graph-based OLAP, offering real-time graph analytics with superior performance and data freshness for dynamic applications.

• YouTube
• 20 minutes
• On-Demand
• Conference Talk

OLAP on Cassandra Data with Arrow, Flight SQL, ADBC, and DuckDB

Explore modern OLAP techniques for Cassandra data using Arrow, Flight SQL, ADBC, and DuckDB. Learn to convert sstable snapshots to Parquet, enable real-time analytics, and leverage Flight SQL for efficient querying.

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

USENIX

Data Caching for Enterprise-Grade Petabyte-Scale OLAP

Explores Alluxio local cache for petabyte-scale OLAP, optimizing data transfer efficiency in decoupled compute-storage models. Shares insights from Uber and Meta deployments.

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

The ASF

Apache Paimon - A Unified Data Lake for Stream, Batch, and OLAP Processing

Explore Apache Paimon's capabilities as a unified data lake system, integrating stream processing, batch operations, and OLAP functionalities for modern data architecture.

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

OSACon

Analytics and Real-time Database Workloads: Combining OLTP and OLAP Systems

Explore strategies for optimizing concurrent OLAP and OLTP workloads, focusing on ScyllaDB's workload prioritization features to achieve harmonious performance in distributed systems.

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

The ASF

OLAP Practice Based on Apache Doris at Xiaomi

Explore Apache Doris' implementation at Xiaomi for OLAP, covering historical context, data dashboards, user behavior analysis, and future developments in big data analytics.

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

The ASF

The Practices of Apache Doris in OLAP and Data Analysis at Caitong Securities

Discover how Apache Doris optimizes data analysis and OLAP operations in securities trading through real-world implementation examples and architectural insights.

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

The ASF

File Runtime Statistics for Spark Optimization in OLAP and Data Analysis

Discover how to leverage file runtime statistics for optimizing Spark performance and enhancing data processing efficiency in OLAP systems.

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