DuckDB Basics: Get started using SQL in the CLI

DuckDB is an incredible data technology that's transforming how analysts, data engineers, and developers work with data locally. In this video, I'll walk you through the fundamentals of getting started with DuckDB using SQL in its command-line interface. You'll learn: - What DuckDB is and why it's so fast - How to install DuckDB in seconds - Creating in-memory vs. persistent databases - Importing sample data sets - Running SQL queries - Joining tables efficiently - Creating, managing, and dropping tables - Inserting data - Reading CSV and Parquet files locally AND from URLs - Exporting results to different formats DuckDB is the perfect starting point if you want to understand modern analytical databases before diving into Python integration or other languages. If you're tired of spinning up distributed computing for simple analytical tasks, this video is for you. Resources: - Substack article: https://thefulldatastack.substack.com/p/duckdb-basics-using-sql-in-the-cli - My LinkedIn: https://www.linkedin.com/in/hoytemerson/ - My X: https://x.com/HoytEmerson - My company: https://www.earlysignal.tech/