Goal
The path to "プログラマのためのSQL 第4版"
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 the 達人 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: After the applied set operations, advance to Joe Celko's set-theory-based advanced idioms and the nested-set model for hierarchical data. Including declarative hierarchical queries such as recursive CTEs, it is the capstone of the set-theoretic mindset—shedding procedural thinking entirely.