e.g. This is primarily aimed at first- and second-year undergraduates interested in engineering or science, along with high school students and professionals with an interest in programming.DuckDB From Zero teaches you how to embed DuckDB directly into your Rust applications, treating an analytical SQL engine as a library rather than a server. Across four hands-on modules, you'll move from compiling DuckDB into a single binary to writing SQL queries over local CSV, Parquet, and JSON files, streaming Arrow record batches into Polars, and shipping a polished command-line tool with cargo dist.
By the end you will understand when in-memory connections beat on-disk databases, how projection and predicate pushdown make Parquet queries fast on a laptop, how to hand results to Polars zero-copy through the Arrow C Data Interface, and how to package a Rust CLI that bundles DuckDB so users can install nothing and still run analytical queries against gigabytes of data.
The course is built around short videos, key-term readings, scenario-driven reflections, and an end-to-end demo project. You will leave with a working understanding of DuckDB-in-Rust patterns, the skills to design an analytical CLI you would actually want to use, and a clear mental model of where DuckDB fits between SQLite, Spark, and the Polars/Arrow ecosystem.
DuckDB as a library, not a server. How to compile it into a Rust binary, and when to use in-memory connections versus on-disk database files.
What's included
3 videos3 readings1 assignment
Show info about module content
3 videos•Total 8 minutes
Embedded Analytics in One Binary•3 minutes
Bundled vs System Library•2 minutes
In-Memory vs On-Disk•2 minutes
3 readings•Total 12 minutes
About This Course•10 minutes
Key Terms: Embedded Analytics•1 minute
Reflection: Embedded Analytics•1 minute
1 assignment•Total 5 minutes
Untitled•5 minutes
SQL Queries Over Local Files
Module 2•15 minutes to complete
Module details
Querying CSV, Parquet, and JSON files directly with DuckDB. How the read_csv_auto and read_parquet table functions work, why projection and predicate pushdown matter, and how to handle nested JSON.
What's included
3 videos2 readings1 assignment
Show info about module content
3 videos•Total 8 minutes
Reading CSV with read_csv_auto•3 minutes
Parquet and Pushdown•3 minutes
Reading Nested JSON•2 minutes
2 readings•Total 2 minutes
Key Terms: SQL Queries Over Local Files•1 minute
Reflection: SQL Queries Over Local Files•1 minute
1 assignment•Total 5 minutes
SQL Queries Over Local Files•5 minutes
Arrow Result Sets & Polars Interop
Module 3•15 minutes to complete
Module details
Moving DuckDB results into the broader data ecosystem via Apache Arrow. How to fetch Arrow record batches from DuckDB, hand them to Polars, and choose between DuckDB and Polars for each stage of a pipeline.
What's included
3 videos2 readings1 assignment
Show info about module content
3 videos•Total 8 minutes
Streaming Arrow Record Batches•3 minutes
DuckDB to Polars•2 minutes
Engine Selection Per Stage•3 minutes
2 readings•Total 2 minutes
Key Terms: Arrow & Polars•1 minute
Reflection: Arrow & Polars Interop•1 minute
1 assignment•Total 5 minutes
Arrow Result Sets & Polars Interop•5 minutes
Shipping DuckDB
Module 4•1 hour to complete
Module details
Packaging DuckDB-powered Rust code as a portable single-file CLI. How to design CLI ergonomics with clap, ship binaries with cargo dist, and wire main.rs to a lib.rs core that holds the DuckDB logic.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.