{"product_id":"duckdb-in-action-9781633437258","title":"Duckdb in Action","description":"\u003cb\u003eDive into DuckDB and start processing gigabytes of data with ease--all with no data warehouse.\u003c\/b\u003e \u003cp\u003e\u003c\/p\u003eDuckDB is a cutting-edge SQL database that makes it incredibly easy to analyze big data sets right from your laptop. In \u003ci\u003eDuckDB in Action\u003c\/i\u003e 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 DuckDB--all through hands-on examples. \u003cp\u003e\u003c\/p\u003eOpen up \u003ci\u003eDuckDB in Action\u003c\/i\u003e and learn how to: \u003cp\u003e\u003c\/p\u003e- Read and process data from CSV, JSON and Parquet sources both locally and remote\u003cbr\u003e - Write analytical SQL queries, including aggregations, common table expressions, window functions, special types of joins, and pivot tables\u003cbr\u003e - Use DuckDB from Python, both with SQL and its \"Relational\"-API, interacting with databases but also data frames\u003cbr\u003e - Prepare, ingest and query large datasets\u003cbr\u003e - Build cloud data pipelines\u003cbr\u003e - Extend DuckDB with custom functionality \u003cp\u003e\u003c\/p\u003e Pragmatic and comprehensive, \u003ci\u003eDuckDB in Action\u003c\/i\u003e introduces the DuckDB database and shows you how to use it to solve common data workflow problems. You won't need to read through pages of documentation--you'll learn as you work. Get to grips with DuckDB's unique SQL dialect, learning to seamlessly load, prepare, and analyze data using SQL queries. Extend DuckDB with both Python and built-in tools such as MotherDuck, and gain practical insights into building robust and automated data pipelines. \u003cp\u003e\u003c\/p\u003ePurchase of the print book includes a free eBook in PDF and ePub formats from Manning Publications. \u003cp\u003e\u003c\/p\u003e \u003cb\u003eAbout the technology\u003c\/b\u003e \u003cp\u003e\u003c\/p\u003e DuckDB 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. DuckDB 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. \u003cp\u003e\u003c\/p\u003e \u003cb\u003eAbout the book\u003c\/b\u003e \u003cp\u003e\u003c\/p\u003e \u003ci\u003eDuckDB in Action\u003c\/i\u003e guides you example-by-example from setup, through your first SQL query, to advanced topics like building data pipelines and embedding DuckDB as a local data store for a Streamlit web app. You'll explore DuckDB's handy SQL extensions, get to grips with aggregation, analysis, and data without persistence, and use Python to customize DuckDB. A hands-on project accompanies each new topic, so you can see DuckDB in action. \u003cp\u003e\u003c\/p\u003e \u003cb\u003eWhat's inside\u003c\/b\u003e \u003cp\u003e\u003c\/p\u003e- Prepare, ingest and query large datasets\u003cbr\u003e - Build cloud data pipelines\u003cbr\u003e - Extend DuckDB with custom functionality\u003cbr\u003e - Fast-paced SQL recap: From simple queries to advanced analytics \u003cp\u003e\u003c\/p\u003e\u003cb\u003eAbout the reader\u003c\/b\u003e \u003cp\u003e\u003c\/p\u003e For data pros comfortable with Python and CLI tools. \u003cp\u003e\u003c\/p\u003e \u003cb\u003eAbout the author\u003c\/b\u003e \u003cp\u003e\u003c\/p\u003e \u003cb\u003eMark Needham\u003c\/b\u003e is a blogger and video creator at @?LearnDataWithMark. \u003cb\u003eMichael Hunger\u003c\/b\u003e leads product innovation for the Neo4j graph database. \u003cb\u003eMichael Simons\u003c\/b\u003e is a Java Champion, author, and Engineer at Neo4j.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAbout the Author\u003c\/b\u003e\u003cbr\u003e\u003cb\u003eMark Needham\u003c\/b\u003e is a blogger, and video creator at @]LearnDataWithMark, where his series on DuckDB offers viewers hands-on insights into practical database applications. \u003cp\u003e\u003c\/p\u003e\u003cb\u003eMichael Hunger\u003c\/b\u003e works on the open source Neo4j graph database filling many roles, where leads the product innovation and developer product strategy. \u003cp\u003e\u003c\/p\u003e\u003cb\u003eMichael Simons\u003c\/b\u003e is a Java Champion, author, and Staff Software Engineer at Neo4j and has been working professionally as a developer for more than 20 years.\u003cbr\u003e","brand":"Manning Publications","offers":[{"title":"Default Title","offer_id":50901524939026,"sku":"9781633437258","price":55.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0831\/4771\/8930\/files\/img_878bf657-0293-4c51-a656-b070d5bc0753.jpg?v=1738428848","url":"https:\/\/surprise-castle.myshopify.com\/products\/duckdb-in-action-9781633437258","provider":"Surprise Castle","version":"1.0","type":"link"}