DeepRead
Cover of SQL Cookbook

About the book

A problem-oriented collection of SQL recipes, each stating a common task and giving one or more working queries for it. Topics include retrieving and sorting rows, working across multiple tables, inserting, updating and deleting data, querying database metadata, string, date and numeric manipulation, reporting and aggregation, and hierarchical or graph-like queries. The examples cover several major relational database products, with differences between them noted. The book's central claim is that many problems that seem to need procedural code or application-side processing can be solved with a single set-based SQL statement, using techniques such as CASE expressions, self-joins, grouping, and analytic functions. Each recipe pairs a problem with a solution and a discussion of how it works, so the reader can adapt the pattern rather than memorise the query. It presents SQL as a language to think in terms of sets and conditions, not only a way to fetch rows.

Written by Claude from what it knows of this book.

What Hacker News says 100% recommend · 0% critical

012201220142016201820202012 peak · 2
This bookAverage book in Databases and distributed data

In the commenters’ own words

What Open Library readers say 4.00 from 1 rating

  1. 50
  2. 41
  3. 30
  4. 20
  5. 10
  • 10 want to read
  • 1 reading
  • 2 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

Details

First published
2005
ISBN
9780596009762
Editions known
2 at Open Library
Open Library
OL8167532W

Explore in the mosaic

Read next: its neighbours on the mosaic

  • Learning SQL
    Alan Beaulieu · 2005 · recommended by 3 people · similar by subject and what people say about it
  • Practical SQL, 2nd Edition
    Anthony DeBarros · 2021 · recommended by 5 people · similar by subject and what people say about it
  • SQL antipatterns
    Bill Karwin · 2010 · recommended by 31 people · similar by subject and what people say about it
  • Joe Celko's SQL for Smarties
    Joe Celko · 1995 · recommended by 10 people · similar by subject and what people say about it
  • Transactional information systems
    Gerhard Weikum · 2001 · recommended by 2 people · loosely similar by subject
  • The art of SQL
    Stephane Faroult · 2006 · recommended by 8 people · similar by subject and what people say about it
  • SQL Performance Explained
    Markus Winand · 2011 · recommended by 26 people · similar by subject and what people say about it
  • SQL for Web Nerds
    Philip Greenspun · 2000 · recommended by 7 people · similar by subject and what people say about it
  • PostgreSQL 16 Administration Cookbook
    Gianni Ciolli · 2023 · recommended by 2 people · similar by subject and what people say about it
  • SQL for Dummies
    Allen G. Taylor · 1993 · recommended by 1 person · similar by subject and what people say about it
  • The data warehouse toolkit
    Ralph Kimball · 1996 · recommended by 23 people · similar by subject and what people say about it
  • Database systems
    Hector Garcia-Molina · 2001 · recommended by 11 people · similar by subject and what people say about it
  • Pro SQL Server Internals
    Dmitri Korotkevitch · 2014 · recommended by 2 people · similar by subject and what people say about it
  • High Performance MySQL
    Jeremy D. Zawodny · 2004 · recommended by 27 people · similar by subject and what people say about it
  • Ruby cookbook
    Lucas Carlson · 2006 · recommended by 1 person · similar by subject and what people say about it
  • Developing time-oriented database applications in SQL
    Richard T. Snodgrass · 1999 · recommended by 6 people · similar by subject and what people say about it
  • The data model resource book
    Len Silverston · 1997 · recommended by 8 people · similar by subject and what people say about it
  • SQL Design Patterns
    Vadim Tropashko · 2007 · recommended by 2 people · similar by subject and what people say about it
  • Database Internals
    Alex Petrov · 2019 · recommended by 31 people · similar by subject and what people say about it
  • SQL puzzles & answers
    Joe Celko · 1997 · recommended by 3 people · similar by subject and what people say about it
  • SQL and relational theory
    C. J. Date · 2009 · recommended by 9 people · loosely similar by subject
  • Database System Concepts
    Korth · 2005 · recommended by 4 people · similar by subject and what people say about it
  • The Guru's Guide to Transact-SQL
    Ken Henderson · 2000 · recommended by 2 people · similar by subject and what people say about it
  • SQL Queries for Mere Mortals
    John L. Viescas · 2018 · recommended by 2 people · similar by subject and what people say about it