Book
Joe Celko's SQL for Smarties, 4th Edition
Advanced SQL Programming
Joe Celko
Summary
The Japanese translation of the fourth edition of Joe Celko's SQL for Smarties, published by Shoeisha with translation and commentary by Mick. It is a practitioner's reference that pushes at the limits of what SQL can express: representing tree structures with the nested-set model, advanced grouping and aggregation, query optimization, and metadata operations. Its 39 chapters range from schema-level objects and NULL handling through comparison and evaluation predicates, virtual tables including views and common table expressions, window functions and OLAP, arrays and set operations, and dedicated chapters on trees, graphs, and temporal queries in SQL. The Japanese edition runs to more than 800 pages.
Target Readers
- Senior engineers who want to push SQL's declarative, set-based expressiveness as far as it goes
- Architects who want a spec-level understanding of SQL and database design, not just working familiarity
- Developers who need to model hierarchical or graph-shaped data in SQL, using techniques such as the nested-set model
Tags
Colophon
- Publisher
- Shoeisha
- 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
Tatsujin ni Manabu SQL Tettei Shinansho, 2nd Edition (A Thorough Guide to SQL, Learned from an Expert)
For Those Who Do Not Want to Remain Beginners
Mick
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 Jissen Nyumon (A Practical Introduction to SQL)
Writing Fast, Easy-to-Understand Queries
Mick
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.
- Related
SQL Queries for Mere Mortals, 4th Edition
A Hands-On Guide to Data Manipulation in SQL
John L. Viescas
Reason: SQL Queries for Mere Mortals introduces thinking in sets in its seventh chapter and ends with harder problems built on CASE and unlinked tables; the fourth edition also adds a chapter on window functions. For a reader who can work through all of that and wants to push set-oriented SQL further, Joe Celko's SQL for Smarties is the next book.
Next Books
- Related
Database Internals
A Deep Dive into How Distributed Data Systems Work
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.