What You Need to Know Before
You Start

Starts 7 June 2025 18:11

Ends 7 June 2025

00 days
00 hours
00 minutes
00 seconds
course image

Modern Data Warehouse Systems: BigQuery, Snowflake, Redshift, Databricks, and DuckDB - Lecture 25

Explore modern data warehouse architectures and cloud-native databases, comparing BigQuery, Snowflake, Redshift, Databricks, and DuckDB's unique features and use cases for data analytics.
CMU Database Group via YouTube

CMU Database Group

2544 Courses


1 hour 26 minutes

Optional upgrade avallable

Not Specified

Progress at your own speed

Free Video

Optional upgrade avallable

Overview

Explore modern data warehouse architectures and cloud-native databases, comparing BigQuery, Snowflake, Redshift, Databricks, and DuckDB's unique features and use cases for data analytics.

Syllabus

  • Introduction to Modern Data Warehouse Systems
  • Overview of Data Warehousing Concepts
    Importance in Data Analytics
  • BigQuery
  • Architecture and Key Features
    Use Cases and Best Practices
    Pricing and Performance Considerations
  • Snowflake
  • Architecture and Key Features
    Unique Data Sharing Capabilities
    Pricing and Performance Considerations
  • Redshift
  • Architecture and Key Features
    Integration with Amazon's Ecosystem
    Pricing and Performance Considerations
  • Databricks
  • Architecture and Key Features
    Strengths in Machine Learning and Data Science
    Pricing and Performance Considerations
  • DuckDB
  • Architecture and Key Features
    In-memory Analytics and Use Cases
    Integration with Jupyter Notebooks
  • Comparing Data Warehousing Solutions
  • Performance and Scalability
    Cost Analysis
    Security and Compliance Features
  • Use Cases and Case Studies
  • Industry-specific Applications
    Real-world Success Stories
  • Conclusion
  • Key Takeaways and Future Trends in Data Warehousing

Subjects

Business