DuckDB The Ultimate Guide

DuckDB – The Ultimate Guide, available at $19.99, has an average rating of 4.7, with 84 lectures, based on 57 reviews, and has 518 subscribers.

You will learn about 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) This course is ideal for individuals who are Developers & Data Engineers who want to learn about modern local data warehousing and developing Analytics solutions faster or Data Analysts & Data Scientists who want to upskill and learn how to use embedded analytics databases or Data Professionals & Enthusiasts who want to upgrade their skills in DataBases & Data Modelling or People that want to become a Data Scientist, BI analyst, Data Engineer or Data Analyst It is particularly useful for Developers & Data Engineers who want to learn about modern local data warehousing and developing Analytics solutions faster or Data Analysts & Data Scientists who want to upskill and learn how to use embedded analytics databases or Data Professionals & Enthusiasts who want to upgrade their skills in DataBases & Data Modelling or People that want to become a Data Scientist, BI analyst, Data Engineer or Data Analyst.

Enroll now: DuckDB – The Ultimate Guide

Summary

Title: DuckDB – The Ultimate Guide

Price: $19.99

Average Rating: 4.7

Number of Lectures: 84

Number of Published Lectures: 84

Number of Curriculum Items: 84

Number of Published Curriculum Objects: 84

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will 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)

Who Should Attend

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

Target Audiences

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

Why should I learn DuckDB?

1. + 1200% of searches in the last 2 years
   Its popularity is growing RAPIDLY!

2. Data lakes and bulky Big Data Infrastructure (like Apache Hadoop & Spark) are not optimal solution to every Data problem

   DuckDB is an awesome solution for running a database very similar to PostgreSQL, but with HUGE Analytical Capabilities, locally without any fuss

3. 100% free & supports dozens of various integrations

   duckdb Python, duckdb dbt, duckdb Streamlit, duckdb s3 & wasm & Docker + many more: you can almost anything with it. Additionally, you can easily do data exports: duckdb csv, duckdb parquet, duckdb json are all ways to share your analysis results in no time! Python integration is as easy as doing “pip install duckdb” & you’re ready to go! We will dive deep into duckdb Python integration in one of the cases.

4. Ease of use
   Rather than having a PostgreSQL/Mariadb for each developer on the team, you can setup configuration to spawn an in memory instance of DuckDB. If you need to fetch data from the Internet, it’s no problem either: Duckdb Httpfs is a package that we’ll also study.

5. Local Analysis of BigData
   If you want to run a columnar database locally on pretty big data, there isn’t really anything else like it. You could instead run PySpark locally but that would be much more of a headache. Duckdb Pivot can even help you create Spreadsheet-like tables.

6. Easy to learn after SQLite
   It’s a step forward to Analytics field from SQLite. DuckDB performs great when running aggregate queries on limited columns whereas SQLite works great when fetching one or more rows using filters. In the Course we will compare and contrast duckdb vs Sqlite and duckdb vs Clickhouse.

7. 300%+ faster than Pandas
   Pandas loads all data into memory and runs on a single thread. Hence it can’t operate on larger than memory datasets and also doesn’t use all of your CPU  cores. Whereas DuckDB can operate on datasets larger than memory. Moreover, it can distribute load across all the CPU cores. All that using SQL language by default!

This Course is not just a duckdb tutorial: it’s a packaged solution to master this new & rapidly growing technology.

Expected Outcomes

After this Course:

You will learn how to Architect & Implement Analytics Solutions that use duck db as the database

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

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

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)

Use a DuckDB dbt (Data Build Tool) combo to streamline Analytics Data Warehouse development (Practice)

You will learn to work in MotherDuck: a Cloud-native environment (SaaS) for duck db (Practice). You can think of it as DuckDB GUI that you might miss in CLI

Learn to interact with DuckDB inside Docker environment

Understand how DuckDB fits into Micro-service architecture of Analytical services

Use Rill: a DuckDB-powered BI-as-Code “last-mile ETL” platform for blazing fast Dashboarding

What’s inside

Video lectures (with interactive annotations)

PDFs with Practice Cases Outlines

Demo Resources

Fully packaged code base for Practice Projects

Full lifetime access with all future updates

Certificate of course completion

30-Day Money-Back Guarantee

The course isn’t static! I collect students’ feedback and work on improving it

[Course Updates]:

01.2024: + Bonus Section: Let’s build a DuckDB-powered Recommender Micro-service

02.2024: + “Rill Data” Section: DuckDB-powered BI-as-Code “last-mile ETL” platform

05.2024: + Updates in MotherDuck section: explore new AI-powered features in the platform

06.2024: + “DuckDB in Data Pipelines” Section: use case to learn how DuckDB can play the “data transformer” role

Digital assets used:

-Image from freepik with free licence from freepik dot com “Free vector gradient dynamic blue lines background”

Course Curriculum

Chapter 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?

Chapter 2: DuckDB Introduction

Lecture 1: What is DuckDB? (detailed)

Lecture 2: Why use DuckBD?

Lecture 3: What role does DuckDB play in modern Analytics World?

Lecture 4: DuckDBs competition & market niche

Lecture 5: When should you use DuckDB? (typical use cases)

Lecture 6: Who Should Use DuckDB?

Chapter 3: Environment Setup & Demo

Lecture 1: DuckDB Installation

Lecture 2: Environment configuration

Lecture 3: Getting started with DuckDBs SQL

Lecture 4: Outputting SQLs results into files

Chapter 4: CLI usage: DuckDBs Innovations in SQL

Lecture 1: Practice Case Description

Lecture 2: Importing Data

Lecture 3: DuckDB SQL Innovations: SUMMARIZE & REPLACE

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

Lecture 5: Window Functions: the DuckDB way

Lecture 6: PIVOTing in DuckDB

Lecture 7: TABLE Functions in DuckDB

Chapter 5: Duckdb Python

Lecture 1: Practice Case Description

Lecture 2: Downloading Data

Lecture 3: Duckdb and Python: Analytics workflow – part1

Lecture 4: Duckdb and Python: Analytics workflow – part2

Lecture 5: Duckdb and Python: Analytics workflow – part3

Chapter 6: Streamlit + Duckdb

Lecture 1: Streamlit Introduction

Lecture 2: Practice Case Description

Lecture 3: Fetching Data – part1

Lecture 4: Fetching Data – part2

Lecture 5: Launching the App

Chapter 7: Duckdb + DBT

Lecture 1: Data Build Tool (dbt) Introduction

Lecture 2: Practice Case Description

Lecture 3: Data Walkthrough

Lecture 4: Fetching Data – part1

Lecture 5: Fetching Data – part2

Lecture 6: Running dbt Pipeline

Lecture 7: DBeaver: Amazing Database Management Tool

Lecture 8: DuckDB Backward Compatibility Issue: SOLVED

Lecture 9: Exploring End Result: duckdb DataWarehouse

Chapter 8: MotherDuck: Cloud offering of DuckDB as a SaaS

Lecture 1: What is MotherDuck?

Lecture 2: MotherDucks Features

Lecture 3: Attaching a Remote Database

Lecture 4: Detaching a Remote Database

Lecture 5: Automating Authentication to MotherDuck Platform

Lecture 6: Mother Duck Updates: Summer 2024

Lecture 7: Sharing Databases

Lecture 8: AI in MotherDuck: Intro

Lecture 9: Querying Data with Natural Language feature

Lecture 10: A More Challenging Query for AI

Chapter 9: Rill: a DuckDB-powered BI-as-Code platform

Lecture 1: Rill Intro

Lecture 2: Case End Product DEMO

Lecture 3: What is Rill?

Lecture 4: Case Data

Lecture 5: Data Sources

Lecture 6: Data Models

Lecture 7: Dashboard Outlining

Lecture 8: UI: Part 1

Lecture 9: UI: Part 2

Lecture 10: Setting up a Github repo

Lecture 11: Connecting Rill Cloud to Github

Lecture 12: Sharing access to Dashboard

Lecture 13: Scheduling Data Refresh

Lecture 14: Deleting Rill Project

Chapter 10: DuckDB in Complex Data Pipelines

Lecture 1: DuckDB in Data Pipelines

Lecture 2: End Result: What Well be Working Towards

Lecture 3: Dagster: Intro

Lecture 4: Setting up Environment

Lecture 5: Data Pipeline Walkthrough: part 1

Lecture 6: Data Pipeline Walkthrough: part 2

Lecture 7: Launching Pipeline & Case wrapping up

Chapter 11: Bonus: Spinning up a DuckDB-powered Recommender Microservice

Lecture 1: Case Intro

Lecture 2: Business Case Architecture

Lecture 3: Disclaimer: Fast Forward if needed

Lecture 4: Movies Data base API

Lecture 5: Dockerfile: Packaging the Project

Lecture 6: Managing Python Dependencies with Poetry

Lecture 7: Fetching Data from API

Lecture 8: Understanding Data

Lecture 9: Recommender System Codebase

Lecture 10: FastAPI Microservice

Lecture 11: Building Docker Image

Lecture 12: Exploring Data inside DuckDB

Lecture 13: Getting Recommendations

Lecture 14: Wrapping Up the Case

Instructors

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

Rating Distribution

1 stars: 0 votes

2 stars: 2 votes

3 stars: 6 votes

4 stars: 16 votes

5 stars: 33 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!