Goal
The path to "Jissen dbt Nyumon (A Practical Introduction to dbt)"
Here is the reading path leading up to this book, derived from its dependencies and ordered from the fundamentals.
The path so far (3 books)
Why read this first: Once you have the basics of SELECT, the natural next step is set-oriented techniques—CASE expressions, window functions, set operations—that teach you to think in sets rather than procedurally. Both are Japanese SQL books by the same author (Mick), so the vocabulary carries over smoothly from introduction to application.
Why read this first: Grasping relational theory first makes the set operations and window functions in this advanced SQL guide land as the logical necessity of 'why think in sets'. Reading theory → implementation lets you derive each advanced SQL technique from first principles rather than memorizing it ad hoc.
Why read this first: Once you can wield SQL as a set-oriented language—CASE expressions, window functions, self-joins—the next step is learning how to assemble that SQL into a production data-transformation pipeline. This book covers running models in dbt, structuring a project, and generating tests and documentation, connecting applied SQL knowledge to the practical operation of an analytics platform.