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.
<ASIN: 1633437256>
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.
Python Programming with Design Patterns
Author: James W. Cooper Publisher: Addison-Wesley Date: February 2022 Pages: 352 ISBN: 978-0137579938 Print: 0137579934 Kindle: B09D2RKQB5 Audience: Python developers Rating: 1 Reviewer: Mike James There was a time that design patterns were all the thing. Not so much now. But Python - does it have [ ... ]
|
Fundamentals of Database Management Systems
Author: Dr. Mark L. Gillenson Publisher: Wiley Pages: 416 ISBN:978-1119907466 Print:1119907462 Audience: Database managers Rating: 3 Reviewer: Kay Ewbank
This book is aimed at people taking a one-semester course in database management as part of their larger information systems management course. As suc [ ... ]
| More Reviews |
|