Book
達人に学ぶSQL徹底指南書 第2版
ミック
Summary
CASE 式・ウィンドウ関数・自己結合・EXISTS 述語など、SQL を集合指向言語として極めるための 応用技法と、実行計画の読み方を体系的に解説。データを「集合と論理」で扱う思考力を養い、 SQL を単なるデータ抽出言語から高度な集合操作言語へと昇華させる。
Target Readers
- SQL 基礎は理解したが応用に進めない中級エンジニア
- 複雑な集計・分析クエリを設計する開発者
Tags
Colophon
- Publisher
- 翔泳社
- ISBN
- 978-4798157825
- Published
- Oct 2018
- List price
- ¥2,750incl. taxMay differ from the actual selling price on Amazon
Get this book
* The link above is an advertisement via Amazon Associates.Related Books
Prerequisites
- Recommended
SQL 第2版
ミック
Reason: 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.
- Recommended
理論から学ぶデータベース実践入門
奥野幹也
Reason: 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.
- Related
リレーショナルデータベース入門 第3版
増永良文
Reason: After learning academic relational algebra and normalization theory, this path lets you verify how it is expressed in actual SQL via the 達人 guide. It grounds the abstractions you gained in theory into concrete query forms, converting knowledge into something usable in practice.
Sources
Next Books
- Recommended
プログラマのためのSQL 第4版
Joe Celko
Reason: 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.
- Recommended
SQLパフォーマンス詳解
Markus Winand
Reason: Once you can write applied SQL, you want to understand why a query is fast or slow from the internal structure of indexes. Markus Winand's 'SQL Performance Explained' builds index design up from how B-Trees work, connecting the way you write SQL with how fast it runs.
- Recommended
実践dbt入門
関山宜孝, 中谷宙央, 豊原世将, 大橋潤, 疋田宗太郎
Reason: 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 (実践dbt入門) 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.
Sources
- Related
失敗から学ぶRDBの正しい歩き方
曽根壮大
Reason: Even when you can write applied SQL fluently, the RDB-specific pitfalls you meet in production are a separate body of knowledge. Adding the operational perspective from this Japanese book (失敗から学ぶRDBの正しい歩き方) balances the ability to write SQL with the ability to operate the database.
Sources