DuckDB

Course Scope

This section contains the DuckDB course structured as a comprehensive Docusaurus MDX curriculum covering OLAP SQL, file-based data ingestion, window functions, analytical extensions, and real-world analytics use cases.

Modules

• 1. Introduction
• 2. DuckDB Data Types
• 3. Basic SQL Operations
• 4. Filtering and Conditions
• 5. Aggregate Functions
• 6. Joins and Set Operations
• 7. Grouping and Filtering
• 8. Advanced SQL Features
• 9. File and Data Ingestion
• 10. Performance and Extensions
• 11. Database Management
• 12. Run Analytics in DuckDB

Notes

• DuckDB is an in-process OLAP database — no server daemon required.
• All queries can be run directly from the CLI, Python, or embedded in applications.
• Content covers standard SQL, DuckDB-specific extensions (HTTPFS, Arrow, Parquet), and applied analytics patterns.
• Module 1 includes dedicated lessons on DuckDB for SEO, DuckDB for AI Agents, and DuckDB Strengths.

Course Usage

Recommended Learning Order

Follow the modules in numeric order. Use DuckDB's CLI or Python API to run every query in a local .db file before applying patterns to production datasets.

What's Next

• Start with 1. Introduction to understand what makes DuckDB unique.
• Jump to 12. Run Analytics for applied real-world analytics patterns.