DeepRead
Cover of Joe Celko's SQL for Smarties

Joe Celko's SQL for Smarties

Joe Celko · 1995

Programming and computer science › Databases and distributed data

#3,324 most recommended

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

0242009201520202009 peak · 4
This bookAverage book in Databases and distributed data

In the commenters’ own words

What Open Library readers say 5.00 from 1 rating

  1. 51
  2. 40
  3. 30
  4. 20
  5. 10
  • 6 want to read
  • 0 reading
  • 3 have read

Only 1 rating: treat the average as a hint.

Open Library’s page for the book

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

Explore in the mosaic

Read next: its neighbours on the mosaic