Cover of The Book on Data, Data Engineering, Data Analytics, and Agentic AI - Volume 1 by Alex Merced

The Book on Data, Data Engineering, Data Analytics, and Agentic AI - Volume 1

Published by Self-published · Tech

A complete guide to modern data systems, data engineering, analytics, and AI.

About the author: Alex Merced is Head of Developer Relations at Dremio and the author of 77 books on data, AI, economics, fiction, and tabletop RPGs. His story is on WhoIsAlexMerced.com.

Who this book is for

Data engineers who want to build resilient pipelines, software engineers moving into data, and technical leaders who need one reference for data infrastructure.

Table of contents

  1. The Origins of Data Management
  2. From OLTP to OLAP and the Birth of the Data Warehouse
  3. The Data Lake Era
  4. The Data Lakehouse Architecture
  5. Understanding Data Types and Structures
  6. Data Modeling for Analytics
  7. Essential Statistics for Data Practitioners
  8. File Formats and Storage
  9. Open Table Formats
  10. The Open Source Data Ecosystem
  11. The Data Engineering Challenge
  12. ETL, ELT, and Data Pipeline Design
  13. Data Warehouse Architectures
  14. Data Lakehouse Architectures
  15. Query Federation and Virtual Data Layers
  16. The Medallion Architecture and Data Mesh
  17. Batch Processing at Scale
  18. Stream Processing and Real-Time Pipelines
  19. Single-Node Engines: DuckDB, DataFusion, and Polaris
  20. Designing for Cost, Performance, and Maintainability

Excerpt

Every significant shift in computing follows the same pattern. First, the early adopters build something that works but is hard to use. Then, the tooling matures, the costs drop, and suddenly an entire industry reorganizes around the new approach. We saw it with relational databases in the 1980s, with the web in the 1990s, with cloud computing in the 2010s, and we are living through it right now with two simultaneous revolutions: the open data lakehouse and artificial intelligence.

Related books

Work with Alex