Data Warehouses

Fundamentals

• Data Warehouse Concepts - DWH fundamentals, ETL, SCD, fact/dimension tables, architectures

Major Platforms

Cloud-Native Data Warehouses

• Databricks - Lakehouse platform with Delta Lake, Unity Catalog
• Snowflake - Cloud data warehouse with separated compute/storage
• GCP BigQuery - Serverless data warehouse on Google Cloud
• Amazon Redshift - AWS columnar data warehouse

OLAP Databases

• ClickHouse - Fast columnar OLAP database
• StarRocks - Vectorized OLAP database
• Apache Druid - Real-time analytics database

Query Engines

• Amazon Athena - Serverless SQL query service
• Presto / Trino - Distributed SQL query engine

Big Data Platforms

• Apache Hadoop - Distributed big data framework
• Elasticsearch - Search and analytics engine

Other Platforms

• MemSQL (SingleStore) - Real-time distributed SQL
  • MemSQK Intro
• Others - Firebolt, Doris, and additional platforms

Comparisons & Migration

• Platform Comparisons - Compare platforms, migration guides