Getting Started with DuckDB

DuckDB is a lightweight, open-source database that has become a go-to solution for running analytical queries on local machines. In this talk, we will explore why that is, showing off some of its simplicity, portability, and extensibility. We will investigate how its columnar data storage helps with analytical queries and how to read data in common file formats such as CSV, JSON, and Parquet. We will also dig into its SQL interface and see how closely it mirrors relational database solutions. By the end of this talk, we will understand some of the best use cases for DuckDB and what it takes to get started.