Mastering DuckDB: The Hands on Guide

Partner: Udemy
Affiliate Name:
Area:
Description: Description: Mastering DuckDB – Fast, Lightweight Analytics for Modern Data WorkflowsDuckDB is a modern, high-performance SQL OLAP database designed for lightning-fast analytics, yet lightweight enough to run entirely within your application, Jupyter notebook, or Python script. With zero setup, zero servers, and near-instant performance, DuckDB is revolutionizing how we interact with local data.Whether you're a data analyst exploring CSV files, a data engineer building ETL pipelines, or a data scientist running experiments on structured data — DuckDB will save you time, effort, and frustration. This course is your complete guide to mastering DuckDB from scratch, with hands-on exercises, real-world projects, and expert insights.What You Will LearnThis course is designed to take you from the basics to advanced use cases with DuckDB. Here’s a detailed overview of what you’ll gain:Introduction to DuckDBWhat is DuckDB and why is it gaining popularity?OLAP vs OLTP – and where DuckDB fits inHow DuckDB compares to SQLite, Pandas, Postgres, and big data toolsInstalling DuckDB across platforms (Windows, Mac, Linux)Using DuckDB via CLI, Python, Jupyter, and SQLGetting Started with SQL in DuckDBCreating databases and running queriesFiltering, aggregations, group by, joins, and subqueriesWindow functions, CTEs (Common Table Expressions), and date/time functionsCreating views and temporary tablesUsing SQL for data exploration, profiling, and reportingQuerying Data Files Directly (No Import Required!)Querying CSV files directly from disk with SQLWorking with large Parquet files — efficiently and fastIntegrating with Apache ArrowUs
Category: Development > Database Design & Development > Database Management Systems (DBMS)
Partner ID:
Price: 49.99
Commission:
Source: Impact
Go to Course