DuckDB in Action (MEAP V02)
Mark Needham, Michael Hunger, Michael Simons
Compliments of MotherDuck
Dive into DuckDB and start processing gigabytes of data with ease—all with no data warehouse.
You don’t need expensive hardware or to spin up a whole new cluster whenever you want to analyze a big data set. You just need DuckDB! This modern and fast embedded database runs on a laptop, and lets you easily process data from almost any source, including JSON, CSV, Parquet, SQLite and Postgres. In DuckDB 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.
Open up DuckDB 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 DuckDB 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 DuckDB with custom functionality
Dive into DuckDB and start processing gigabytes of data with ease—all with no data warehouse.
You don’t need expensive hardware or to spin up a whole new cluster whenever you want to analyze a big data set. You just need DuckDB! This modern and fast embedded database runs on a laptop, and lets you easily process data from almost any source, including JSON, CSV, Parquet, SQLite and Postgres. In DuckDB 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.
Open up DuckDB 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 DuckDB 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 DuckDB with custom functionality
Kategori:
Tahun:
2023
Edisi:
Chapters 1 to 4 of 13
Penerbit:
Manning Publications
Bahasa:
english
Halaman:
123
ISBN 10:
1633437256
ISBN 13:
9781633437258
Fail:
PDF, 7.26 MB
IPFS:
,
english, 2023