Data Engineering

A book-shaped table of contents for data engineering: foundations and lifecycle, data modeling, storage systems, ingestion and CDC, distributed processing (Spark/Flink), SQL mastery, workflow orchestration, data quality, platform and cloud architecture, pipeline observability, security and governance, performance engineering, system design, and MAANG interview preparation through capstone builds — cross-linking the existing observability book instead of duplicating it.

2 — Advanced SQL

Advanced analytical SQL — window functions, ranking, running totals, recursive queries and recursive CTEs, pivoting, and common table expressions.

3 — Query Optimization

How a query planner turns SQL into an execution plan — reading execution plans, index usage, predicate pushdown, partition pruning, join strategy selection, and cost-based optimization.

Data Engineering

A book-shaped table of contents for data engineering: foundations and lifecycle, data modeling, storage systems, ingestion and CDC, distributed processing (Spark/Flink), SQL mastery, workflow orchestration, data quality, platform and cloud architecture, pipeline observability, security and governance, performance engineering, system design, and MAANG interview preparation through capstone builds — cross-linking the existing observability book instead of duplicating it.

1 — What is Data Engineering?

How data engineering evolved into its own discipline, how the role differs from analytics engineering and data science, and the foundational distinctions (batch vs. streaming, OLTP vs. OLAP) that shape the rest of this book.