Goal
The path to "SQLアンチパターン 第2版"
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: After you can make SQL 'run', the next goal is to internalize why tables are split this way and why we normalize—grounded in relational theory. This Japanese book (理論から学ぶデータベース実践入門) reconstructs Codd's relational model in practitioner's terms, giving your syntax knowledge a theoretical backbone.
Why read this first: Once you have internalized relational and normalization theory, the next stage is translating it into real table design. This Japanese book (達人に学ぶDB設計徹底指南書) concretizes theory—normalization, primary keys, foreign keys—into the practical steps of logical and physical design, bridging theory and practice. Hence it is placed as a required prerequisite.
Sources
Why read this first: After learning the correct design procedure, the next step is learning what not to do from cautionary examples. Bill Karwin's 'SQL Antipatterns' systematizes classic failures—missing foreign keys (Keyless Entry), EAV, comma-separated lists—reinforcing from the flip side why enforcing integrity with constraints matters.