This book guides the reader example-by-example from setup, through that first SQL query, to advanced topics like building data pipelines and embedding DuckDB as a local data store for a Streamlit web app. Mark Needham, Michael Hunger and Michael Simons explore DuckDB’s handy SQL extensions, get to grips with aggregation, analysis, and data without persistence, and use Python to customize DuckDB.

Author: Mark Needham, Michael Hunger and Michael Simons
Publisher: Manning
Date: August 2024
Pages: 312
ISBN: 978-1633437258
Print: 1633437256
Kindle: B0DB2T4XS2
Audience: DuckDB developers
Level: Introductory/Intermediate
Category: Database

Topics include:

• 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

For more Book Watch just click.

Book Watch is I Programmer's listing of new books and is compiled using publishers' publicity material. It is not to be read as a review where we provide an independent assessment. Some, but by no means all, of the books in Book Watch are eventually reviewed.

To have new titles included in Book Watch contact  BookWatch@i-programmer.info

Follow @bookwatchiprog on Twitter or subscribe to I Programmer's Books RSS feed for each day's new addition to Book Watch and for new reviews.