
Joe Celko's SQL for Smarties
Joe Celko · 1995
Programming and computer science › Databases and distributed data
#3,324 most recommended
Hacker News
13
mentions by 13 people · top 24% of 15,732 books
Open Library
5.00★★★★★★★★★★
1 rating · 6 want to read
Wikipedia
—
No article yet
About the book
A practical guide to advanced SQL programming for working developers, covering query techniques, schema and data modeling, and the idioms that let SQL express logic the way a relational database expects. It draws on the SQL-92 standard and the vendor dialects of its era, and it includes problems such as hierarchies, temporal data, and aggregation. Its central claim is that SQL is a declarative, set-oriented language, and that most poor SQL comes from programmers carrying procedural habits such as row-by-row loops and cursors into it. Celko argues that good results depend on modeling the data correctly and on writing queries that operate on whole sets at once. The book presents recurring patterns and solutions as reusable idioms, and it treats the choice of data representation as a central factor in query quality and performance.
Written by Claude from what it knows of this book.
What Hacker News says 77% recommend · 0% critical
In the commenters’ own words
If you put unnecessary abstraction in front of perfectly good solution the you will end up with problems. Object oriented programing is about clearly…
NOT EXISTS has been known to be faster than a join for years now. In what possible way is this news? NOT EXISTS allows for short circuiting, like an OR: if at…
What Open Library readers say 5.00 from 1 rating
- 51
- 40
- 30
- 20
- 10
- 6 want to read
- 0 reading
- 3 have read
Only 1 rating: treat the average as a hint.
What critics say, via Wikipedia
No Wikipedia article about this book yet, so no critics to quote.
Reddit communities — coming later
The threads it came up in
Details
- First published
- 1995
- ISBN
- 9780123820228
- Editions known
- 16 at Open Library
- Open Library
- OL2629233W
Database managementGeneralProfessional, career & trade -> computer science -> database managementProfessional, career & trade -> computer science -> programming languages (jr/sr)Professional, career & trade -> computer science -> user interfacesSQL (Computer program language)SQL (Langage de programmation)Sql (computer program language)User interfaces
Read next: its neighbours on the mosaic
SQL puzzles & answersJoe Celko · 1997 · recommended by 3 people · similar by subject and what people say about it
The Manga Guide to DatabasesMana Takahashi · 2005 · recommended by 11 people · similar by subject and what people say about it
SQL for Web NerdsPhilip Greenspun · 2000 · recommended by 7 people · similar by subject and what people say about it
PostgreSQL 9.0 High PerformanceGregory Smith · 2010 · recommended by 12 people · similar by subject and what people say about it
Developing time-oriented database applications in SQLRichard T. Snodgrass · 1999 · recommended by 6 people · similar by subject and what people say about it
SQL antipatternsBill Karwin · 2010 · recommended by 31 people · similar by subject and what people say about it
SQL Performance ExplainedMarkus Winand · 2011 · recommended by 26 people · similar by subject and what people say about it
The art of SQLStephane Faroult · 2006 · recommended by 8 people · similar by subject and what people say about it
Joe Celko's Trees and Hierarchies in SQL for Smarties,Joe Celko · 2004 · recommended by 5 people · similar by subject and what people say about it
Practical SQL, 2nd EditionAnthony DeBarros · 2021 · recommended by 5 people · similar by subject and what people say about it
SQL Design PatternsVadim Tropashko · 2007 · recommended by 2 people · similar by subject and what people say about it
SQL for DummiesAllen G. Taylor · 1993 · recommended by 1 person · similar by subject and what people say about it
Database Design for Mere MortalsMichael J. Hernandez · 1996 · recommended by 12 people · similar by subject and what people say about it
The data warehouse toolkitRalph Kimball · 1996 · recommended by 23 people · similar by subject and what people say about it
Learning SQLAlan Beaulieu · 2005 · recommended by 3 people · similar by subject and what people say about it
An introduction to database systemsC. J. Date · 1975 · recommended by 14 people · similar by subject and what people say about it
SQL and relational theoryC. J. Date · 2009 · recommended by 9 people · similar by subject and what people say about it
Readings in database systemsMichael Stonebraker · 1998 · recommended by 11 people · similar by subject and what people say about it
Database systemsHector Garcia-Molina · 2001 · recommended by 11 people · similar by subject and what people say about it
Effective Oracle by designThomas Kyte · 2003 · recommended by 1 person · similar by subject and what people say about it
Database System ConceptsKorth · 2005 · recommended by 4 people · similar by subject and what people say about it
SQL Queries for Mere MortalsJohn L. Viescas · 2018 · recommended by 2 people · similar by subject and what people say about it
Database in depthC. J. Date · 2005 · recommended by 4 people · similar by subject and what people say about it
Thinking in JavaBruce Eckel · 1997 · recommended by 28 people · similar by subject and what people say about it