What you'll learn

Architect & Implement Analytics Solutions that use DuckDB as the database

You will learn the underlying principles that make DuckDB so fast on any machine (Theory)

You will learn to work with DuckDB from Python environment (Practice)

You will learn to work with DuckDB from CLI (command line) environment (Practice)

Use DuckDB as a backend database for your Streamlit Python Analytics Apps (Practice)

Combine DuckDB with dbt (Data Build Tool) to streamline Analytics Data Warehouse development (Practice)

You will learn to work in MotherDuck: a Cloud-native environment (SaaS) for DuckDB (Practice)

You will understand how DuckDB is different from other data bases: both Analytical (Clickhouse, Redshift, Cassandra) and OLTP (PostgreSQL, SQLITE)

Requirements

Basic SQL is helpful but not necessary (we'll use guides provided)

Basic Python

Laptop or PC