Fast Local Analytics with DuckDB
Free Beginner course · 10 lessons · 2 weeks · Certificate on completion
Query large files on your laptop at warehouse speed with DuckDB. Across 10 lessons you'll move from fundamentals to a portfolio-ready outcome — at your own pace, with quizzes after each lesson and a final exam to certify your mastery.
What you'll learn
- Why an in-process database
- Installing and querying
- Reading Parquet and CSV directly
- DuckDB SQL extras
- Python and pandas integration
- Working with remote files
Skills you'll pick up
- Why an in-process database
- Installing and querying
- Reading Parquet and CSV direct
- DuckDB SQL extras
- Python and pandas integration
- Working with remote files
Tools covered
- DuckDB
- Real-world projects
- Quizzes
- Final exam
Course modules
Module 1: Why an in-process database
Module 1 of Fast Local Analytics with DuckDB. 3 lessons · 3h
Module 2: DuckDB SQL extras
Module 2 of Fast Local Analytics with DuckDB. 3 lessons · 3h
Module 3: Window and analytic functions
Module 3 of Fast Local Analytics with DuckDB. 2 lessons · 2h
Module 4: DuckDB vs warehouses
Module 4 of Fast Local Analytics with DuckDB. 2 lessons · 2h
Lessons in this course
- Why an in-process database
- Installing and querying
- Reading Parquet and CSV directly
- DuckDB SQL extras
- Python and pandas integration
- Working with remote files
- Window and analytic functions
- Persisting databases
- DuckDB vs warehouses
- Project: analysing a 10GB dataset
Instructor
Sofia Lindqvist — Analytics Engineering Lead
Sofia Lindqvist is a Analytics Engineering Lead with years of hands-on experience teaching DuckDB to thousands of learners worldwide.
Certificate
Finish every lesson and pass the final exam to earn a free, verifiable Learnera certificate for Fast Local Analytics with DuckDB. It can be downloaded as a PDF and shared on LinkedIn.
Career outcomes
Median global salary $105,000 per year · median India salary ₹14,70,000 per year · 63,759 open roles worldwide
- DuckDB Specialist
- Senior DuckDB Lead
- DuckDB Consultant
Frequently asked questions
Is the Fast Local Analytics with DuckDB course free?
Yes. Every Learnera course, including Fast Local Analytics with DuckDB, is completely free — lessons, quizzes, the final exam, and the certificate.
How long does Fast Local Analytics with DuckDB take?
10 lessons, typically completed in 2 weeks at a comfortable pace.
Do I get a certificate?
Yes — pass the final exam and you receive a free, verifiable certificate you can share on LinkedIn.