DuckDB topics
12 short topics in Data Engineering and Analytics. Each one is a single focused exercise with a clear piece of evidence at the end.
12 topics, one exercise each.
Work through them in order, or jump to the one you need.
These are draft topic outlines (draft; instructor review pending). Full lessons follow after review; ask Ajay if you need a topic sooner.
- 01
Analytical data modeling
Demonstrate analytical data modeling in a focused DuckDB example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 02
Time and partition organization
Demonstrate time and partition organization in a focused DuckDB example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 03
Data ingestion and update patterns
Demonstrate data ingestion and update patterns in a focused DuckDB example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 04
Aggregation and query windows
Demonstrate aggregation and query windows in a focused DuckDB example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 05
Column or measurement representations
Demonstrate column or measurement representations in a focused DuckDB example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 06
Index and ordering strategy
Demonstrate index and ordering strategy in a focused DuckDB example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 07
Query resource management
Demonstrate query resource management in a focused DuckDB example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 08
Late-arriving and corrected data
Demonstrate late-arriving and corrected data in a focused DuckDB example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 09
Retention and compaction strategy
Demonstrate retention and compaction strategy in a focused DuckDB example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 10
Access and client connectivity
Demonstrate access and client connectivity in a focused DuckDB example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 11
Analytical query profiling
Demonstrate analytical query profiling in a focused DuckDB example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 12
Dashboard and export integration
Demonstrate dashboard and export integration in a focused DuckDB example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course →
Learn the same ideas beyond DuckDB.
These courses share topics with this one, so you can compare how each language or tool handles the same concept.
More in Relational databases.
You have the curiosity.
Let’s turn it into capability.
Start with a practical workshop or bring a specific question to Ajay.