A practical two day technical course for participants who are new to DuckDB and want to use high-performance analytical SQL directly within local, data engineering, and Python workflows. The agenda progresses from DuckDB architecture and analytical SQL through direct file querying, Parquet integration, Python interoperability, and performance optimisation. The course focuses on using DuckDB effectively as an embedded analytical engine without introducing unnecessary infrastructure.
You will learn how DuckDB executes analytical workloads, how to query local and remote datasets directly with SQL, and how to work efficiently with Parquet and other columnar data. You will integrate DuckDB with Python and common data processing libraries and understand when to use persistent databases, in-memory processing, or direct file access. You will also learn how to analyse query execution and tune workloads for efficient use of CPU, memory, storage, and external data.
*We customize the course outline and content to your specific needs and relevant use cases.
Module 1: DuckDB architecture and analytical processing
Module 2: Analytical SQL with DuckDB
Module 3: Querying files directly
Module 4: Parquet integration and analytical data workflows
Module 5: DuckDB with Python
Module 6: DataFrame and Arrow integration
Module 7: Query analysis and performance optimisation
Module 8: Designing efficient DuckDB analytical workflows
Hands-on learning with expert instructors at your location for organizations.
Master new skills guided by experienced instructors from anywhere.