Columnar Storage Courses and Certifications

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

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

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

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

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.

• openSAP
• 10 hours 50 minutes
• On-Demand
• Free Online Course

CMU Database Group

Amazon Redshift Data Warehouse System - Lecture 22

Explora el sistema de almacenamiento de datos Amazon Redshift, sus características clave y arquitectura. Aprende sobre su diseño, optimizaciones y comparaciones con otros sistemas de bases de datos.

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

CMU Database Group

Yellowbrick Data Warehouse System - Lecture 21

Explore Yellowbrick Data Warehouse System in this advanced database systems lecture. Learn about its architecture, design principles, and innovative features for high-performance data analytics.

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

CMU Database Group

Snowflake Data Warehouse Internals - Lecture 19

Explore Snowflake Data Warehouse internals with Andy Pavlo. Learn about architecture, query processing, and optimization techniques in this advanced database systems lecture from CMU.

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

CMU Database Group

Databricks Photon and Spark SQL in Advanced Database Systems - Lecture 18

Explore Databricks Photon and Spark SQL in this advanced database systems lecture. Learn about cutting-edge technologies for big data processing and analytics.

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

CMU Database Group

Google BigQuery and Dremel - Advanced Database Systems - Lecture 17

Explore Google BigQuery and Dremel architectures, their query processing techniques, and performance optimizations in this advanced database systems lecture from Carnegie Mellon University.

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

CMU Database Group

Databricks Photon and Spark SQL in Advanced Database Systems - Lecture 20

Explora Databricks Photon y Spark SQL: arquitectura, optimización y rendimiento en sistemas de bases de datos avanzados. Análisis detallado de tecnologías clave en procesamiento de datos a gran escala.

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

CMU Database Group

Google BigQuery and Dremel - Lecture 19

Explora el sistema de análisis de datos distribuido BigQuery de Google y su motor Dremel, abordando su arquitectura, diseño y capacidades para consultas a gran escala.

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