Columnar Storage Courses and Certifications

Devoxx

Columnar Storage: Redefining Data Management for the Modern Era

Discover how columnar storage optimizes data warehousing through Apache Arrow, Parquet, and Pandas, improving query performance and reducing costs while enhancing analytics workflows.

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

Scaling Postgres for Time Series Data with Citus

Scaling Postgres for time series data using Citus: partitioning, distribution, and automation techniques to handle high-volume, ever-growing data efficiently across a cluster.

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

Databricks

The Parquet Format and Performance Optimization Opportunities

Explore Parquet format intricacies, columnar storage basics, and optimization techniques for Spark workloads. Learn about encoding, compression, predicate pushdown, and Delta Lake to enhance analytical performance.

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

Zedstore - Compressed Columnar Storage for Postgres

Explore Zedstore, a compressed columnar storage solution enhancing Postgres performance and efficiency. Learn its architecture, benefits, and implementation from VMware experts.

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

PASS Data Community Summit

Inside the VertiPaq Engine

Explore VertiPaq engine internals, database architecture, and optimization techniques for improved performance and compression in SQL Server Analysis Services Tabular, Power BI, and Power Pivot.

• YouTube
• 1 hour 10 minutes
• On-Demand
• Conference Talk

CNCF [Cloud Native Computing Foundation]

TiFlash - Make TiKV 10x Faster and HTAP-able

Explore TiFlash: a columnar engine for TiKV that enables real-time analytics and HTAP scenarios, offering consistent replicas and significant performance improvements for analytical workloads.

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

CNCF [Cloud Native Computing Foundation]

TiFlash - Make TiKV 10x Faster and HTAP-able

Explore TiFlash, a novel component for TiKV that enables HTAP capabilities, offering 10x faster analytical processing and strong workload isolation through a Raft-based architecture and columnar storage.

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

Strange Loop Conference

Powering Interactive Data Applications at Scale

Explore Druid's architecture for powering interactive analytic applications with millisecond query latencies, comparing it to traditional databases and key/value stores for OLAP use cases.

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

Explore advanced enterprise cloud computing concepts, including databases, ERP systems, and low-code/no-code solutions. Gain insights into current trends and practical applications in the industry.

• SAP Learning
• 10 hours 50 minutes
• On-Demand
• Free Online Course

Data Council

Ten Years of Building Open Source Standards: From Parquet to Arrow to OpenLineage

Explore the journey of building open-source data standards, from Apache Parquet to Arrow to OpenLineage. Gain insights into successful project ideation, growth, and ecosystem impact in data management.

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

Conf42

Leveraging Apache Flight Python Client and InfluxDB for Time Series Data Management

Explore Apache Flight Python Client and InfluxDB integration for efficient time series data management. Learn about columnar storage, benchmarks, and real-world applications in data architecture.

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

CMU Database Group

Google BigQuery and Dremel - Lecture 19

Explore Google BigQuery and Dremel's architecture, query processing, and performance optimizations in this advanced database systems lecture.

• YouTube
• 1 hour 16 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

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

Distributed Analytical Database Systems - Lecture 23

Explore distributed analytical database systems, focusing on OLAP architectures, query execution, and optimization techniques for large-scale data processing and analysis.

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