Michael Hunger & Mark Needham 
DuckDB in Action [EPUB ebook] 

Dive into Duck DB and start processing gigabytes of data with easeall with no data warehouse.Duck DB is a cutting-edge SQL database that makes it incredibly easy to analyze big data sets right from your laptop. In Duck DB in Action you’ll learn everything you need to know to get the most out of this awesome tool, keep your data secure on prem, and save you hundreds on your cloud bill. From data ingestion to advanced data pipelines, you’ll learn everything you need to get the most out of Duck DBall through hands-on examples. Open up Duck DB in Action and learn how to: *; Read and process data from CSV, JSON and Parquet sources both locally and remote *; Write analytical SQL queries, including aggregations, common table expressions, window functions, special types of joins, and pivot tables *; Use Duck DB from Python, both with SQL and its "Relational"-API, interacting with databases but also data frames *; Prepare, ingest and query large datasets *; Build cloud data pipelines *; Extend Duck DB with custom functionality Pragmatic and comprehensive, Duck DB in Action introduces the Duck DB database and shows you how to use it to solve common data workflow problems. You won’t need to read through pages of documentationyou’ll learn as you work. Get to grips with Duck DB’s unique SQL dialect, learning to seamlessly load, prepare, and analyze data using SQL queries. Extend Duck DB with both Python and built-in tools such as Mother Duck, and gain practical insights into building robust and automated data pipelines. About the technology Duck DB makes data analytics fast and fun! You don’t need to set up a Spark or run a cloud data warehouse just to process a few hundred gigabytes of data. Duck DB is easily embeddable in any data analytics application, runs on a laptop, and processes data from almost any source, including JSON, CSV, Parquet, SQLite and Postgres. About the book Duck DB in Action guides you example-by-example from setup, through your first SQL query, to advanced topics like building data pipelines and embedding Duck DB as a local data store for a Streamlit web app. You’ll explore Duck DB’s handy SQL extensions, get to grips with aggregation, analysis, and data without persistence, and use Python to customize Duck DB. A hands-on project accompanies each new topic, so you can see Duck DB in action. What’s inside *; Prepare, ingest and query large datasets *; Build cloud data pipelines *; Extend Duck DB with custom functionality *; Fast-paced SQL recap: From simple queries to advanced analytics About the reader For data pros comfortable with Python and CLI tools. About the author Mark Needham is a blogger and video creator at @?Learn Data With Mark. Michael Hunger leads product innovation for the Neo4j graph database. Michael Simons is a Java Champion, author, and Engineer at Neo4j.