Duckdb The Ultimate Guide

Duckdb – The Ultimate Guide
Published 12/2023
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz

Master DuckDB: Analytics Database of Future. 5 Practice Projects+Theory to learn DuckDB Python, Streamlit, CLI and more

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

Description

Overview

Section 1: Course Introduction

Lecture 1 Welcome!

Lecture 2 What will You Learn in this Course?

Lecture 3 What is DuckDB & Why is it SO COOL?

Section 2: DuckDB Introduction

Lecture 4 What is DuckDB? (detailed)

Lecture 5 Why use DuckBD?

Lecture 6 What role does DuckDB play in modern Analytics World?

Lecture 7 DuckDB’s competition & market niche

Lecture 8 When should you use DuckDB? (typical use cases)

Lecture 9 Who Should Use DuckDB?

Section 3: Environment Setup & Demo

Lecture 10 DuckDB Installation

Lecture 11 Environment configuration

Lecture 13 Outputting SQL’s results into files

Section 4: CLI usage: DuckDB’s Innovations in SQL

Lecture 14 Practice Case Description

Lecture 15 Importing Data

Lecture 16 DuckDB SQL Innovations: SUMMARIZE & REPLACE

Lecture 17 DuckDB SQL Innovations: EXCLUDE & COLUMNS & GROUP BY ALL

Lecture 18 Window Functions: the DuckDB way

Lecture 19 PIVOTing in DuckDB

Lecture 20 TABLE Functions in DuckDB

Section 5: Duckdb Python

Lecture 21 Practice Case Description

Lecture 22 Downloading Data

Section 6: Streamlit + Duckdb

Lecture 26 Streamlit Introduction

Lecture 27 Practice Case Description

Lecture 30 Launching the App

Section 7: Duckdb + DBT

Lecture 31 Data Build Tool (dbt) Introduction

Lecture 32 Practice Case Description

Lecture 33 Data Walkthrough

Lecture 36 Running dbt Pipeline

Lecture 37 DBeaver: Amazing Database Management Tool

Lecture 38 DuckDB Backward Compatibility Issue: SOLVED

Lecture 39 Exploring End Result: duckdb DataWarehouse

Section 8: MotherDuck: Cloud offering of duckdb as a SaaS

Lecture 40 What is MotherDuck?

Lecture 41 MotherDuck’s Features

Lecture 42 Attaching a Remote Database

Lecture 43 Detaching a Remote Database

Lecture 44 Automating Authentication to MotherDuck Platform

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