DuckDB – The Ultimate Guide

Master DuckDB: Analytics Database of Future. 7 Practice Projects+Theory to ace DuckDB Python, Streamlit, CLI and Docker

Created by: Max Migutin
Data, Digital & Cloud Instructor | 10+ years of experience

What Will I 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

Target audience

• Developers & Data Engineers who want to learn about modern local data warehousing and developing Analytics solutions faster
• Data Analysts & Data Scientists who want to upskill and learn how to use embedded analytics databases
• Data Professionals & Enthusiasts who want to upgrade their skills in DataBases & Data Modelling
• People that want to become a Data Scientist, BI analyst, Data Engineer or Data Analyst