DuckDB – The Ultimate Guide

سرفصل های دوره

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

1. Course Introduction

1. Welcome!

2. What will You Learn in this Course

3.1 1.duckdb_speed_test.zip

3.2 duckdb_udemy.pdf

3. What is DuckDB & Why is it SO COOL

2. DuckDB Introduction

1.1 duckdb_udemy.pdf

1. What is DuckDB (detailed)

2. Why use DuckBD

3. What role does DuckDB play in modern Analytics World

4. DuckDBs competition & market niche

5. When should you use DuckDB (typical use cases)

6. Who Should Use DuckDB

3. Environment Setup & Demo

1.1 2.installation&demo.zip

1. DuckDB Installation

2. Environment configuration

3. Getting started with DuckDBs SQL

4. Outputting SQLs results into files

4. CLI usage DuckDBs Innovations in SQL

1.1 3.cli_usage.zip

1. Practice Case Description

2. Importing Data

3. DuckDB SQL Innovations SUMMARIZE & REPLACE

4. DuckDB SQL Innovations EXCLUDE & COLUMNS & GROUP BY ALL

5. Window Functions the DuckDB way

6. PIVOTing in DuckDB

7. TABLE Functions in DuckDB

5. Duckdb Python

1.1 4.duckdb_python_case1.zip

1. Practice Case Description

2. Downloading Data

3. Duckdb and Python Analytics workflow - part1

4. Duckdb and Python Analytics workflow - part2

5. Duckdb and Python Analytics workflow - part3

6. Streamlit + Duckdb

1.1 5.duckdb_streamlit.zip

1. Streamlit Introduction

2. Practice Case Description

3. Fetching Data - part1

4. Fetching Data - part2

5. Launching the App

7. Duckdb + DBT

1.1 6.duckdb_dbt.zip

1. Data Build Tool (dbt) Introduction

2. Practice Case Description

3. Data Walkthrough

4. Fetching Data - part1

5. Fetching Data - part2

6.1 Staging layer Whats that and Why is it needed.html

6.2 Staging Models Best Practices.html

6. Running dbt Pipeline

7. DBeaver Amazing Database Management Tool

8. DuckDB Backward Compatibility Issue SOLVED

9. Exploring End Result duckdb DataWarehouse

8. MotherDuck Cloud offering of duckdb as a SaaS

1.1 7.motherduck.zip

1. What is MotherDuck

2. MotherDucks Features

3. Attaching a Remote Database

4. Detaching a Remote Database

5. Automating Authentication to MotherDuck Platform

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy