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

Edureka

Columnar Storage and Query Optimization

Explore columnar storage, Parquet, ORC, and DuckDB to optimize SQL query performance using execution plans, partitioning, and filter pushdown techniques.

• Coursera
• 10 hours 38 minutes
• Self-Paced
• Paid Course

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

Packt

Real Time Analytics with SAP Hana

Unlock SAP HANA's in-memory computing power for high-speed data analysis, modeling, and real-time business intelligence with hands-on enterprise scenarios.

• Coursera
• 9 hours 58 minutes
• Self-Paced
• Paid Course

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

Coursera

Evaluate Storage for Data Warehousing Success

Master data warehouse storage decisions by evaluating columnar vs. row-oriented formats, benchmarking Parquet, ORC, and Avro, and optimizing compression for analytical performance and cost-effectiveness.

• Coursera
• 1 hour 44 minutes
• Self-Paced
• 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
• Self-Paced
• Free Video

CMU Database Group

Introduction to Database Systems - Fall 2024

Master database fundamentals from CMU covering SQL, storage, indexing, query optimization, concurrency control, recovery, and distributed systems with industry talks.

• YouTube
• 1 day 9 hours 54 minutes
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• Free Video