Book
プログラマのためのSQL 第4版
Joe Celko
Summary
SQL の表現力の限界に挑む実務者向けバイブル。入れ子集合モデルによる木構造の表現、 グループ化と集約の高度な技法、最適化、メタデータ操作までを 800 ページ超で詳解。 世界中の DB プロフェッショナルが参照する標準的リファレンスで、ミックによる訳・解説付き。
Target Readers
- SQL の表現力を限界まで使いこなしたい上級エンジニア
- DB 設計と SQL 仕様を深く理解したいアーキテクト
Tags
Colophon
- Publisher
- 翔泳社
- ISBN
- 978-4798128023
- Published
- May 2013
- List price
- ¥5,060incl. 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: 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.
- Related
SQL実践入門
ミック
Reason: With a tuning foundation grounded in execution plans, Celko's advanced idioms land more deeply—you grasp not just the syntax but why a given form performs well. A supplementary path for re-examining declarative complex queries such as recursive CTEs from both expressiveness and performance.
Next Books
- Related
Database Internals
Alex Petrov
Reason: Pushing Celko's set-theoretic advanced SQL to its limits sparks interest in how those declarative queries are executed and stored internally. Learning storage engines and index implementations in Petrov's 'Database Internals' bridges the gap between SQL's declarations and their physical execution.
Sources