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

CMU Database Group

Storage Models and Database Compression - Lecture 5

Explore storage models and database compression techniques for efficient data management and improved system performance.

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

CMU Database Group

Data Formats and Encoding for Advanced Database Systems - Part 2

Explore advanced data formats and encoding techniques for database systems, focusing on efficient storage and retrieval methods.

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

Coursera

Transform, Analyze, and Optimize Your Data

Master systematic data transformation, workload optimization, and performance evaluation to convert enterprise data chaos into high-performance analytics systems.

• Coursera
• 3 hours 3 minutes
• On-Demand
• Paid Course

Data Council

Building InfluxDB 3 Core: Real-Time Columnar DB and Data Processor on Object Storage

Discover how InfluxDB 3 Core reimagines time series databases through a Rust rewrite using Apache Arrow, DataFusion, and Parquet, creating a diskless architecture with object storage and embedded Python capabilities.

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

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

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

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

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

CMU Database Group

Database Storage Part 2 - Lecture 4

Explore advanced database storage concepts, including page layouts, tuple storage, and system catalogs in this comprehensive lecture on DBMS internals.

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

CMU Database Group

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

Explore Databricks Photon and Spark SQL's advanced features for efficient data processing and analysis in modern database systems.

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

Amazon Redshift Data Warehouse System - Lecture 22

1 review

Explore Amazon Redshift's architecture, design principles, and performance optimizations for large-scale data warehousing in this advanced database systems lecture.

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