DeepRead
Cover of SQL puzzles & answers

SQL puzzles & answers

Joe Celko · 1997

Programming and computer science › Databases and distributed data

#8,360 most recommended

About the book

A collection of tricky SQL puzzles for advanced database programmers, each followed by one or more worked solutions and explanations. Its scope covers query design across SQL-99 and later standards, the SQL Style coding conventions, and temporal query problems. The central claim is that solving SQL problems depends on a set-oriented way of thinking, which the author develops by working through each puzzle from the SQL perspective rather than with procedural habits. The book holds that one puzzle often admits several valid solutions, and it invites readers to compare their own against the author's. It also identifies common misconceptions about SQL and relational database systems that lead to faulty queries.

Written by Claude from what it knows of this book.

What Hacker News says 75% recommend · 0% critical

02420092015202020232009 peak · 1
This bookAverage book in Databases and distributed data

In the commenters’ own words

What Open Library readers say

No Open Library reader has rated it yet.

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
1997
ISBN
9780123735966
Editions known
4 at Open Library
Open Library
OL2629232W

SQL (Computer program language)

Explore in the mosaic

Read next: its neighbours on the mosaic

  • Joe Celko's SQL for Smarties
    Joe Celko · 1995 · recommended by 10 people · similar by subject and what people say about it
  • Java puzzlers
    Joshua Bloch · 2005 · recommended by 12 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 for Web Nerds
    Philip Greenspun · 2000 · recommended by 7 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
  • Using SQLite
    Jay A. Kreibich · 2010 · recommended by 1 person · loosely similar by subject
  • The art of SQL
    Stephane 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
  • SQL for Dummies
    Allen G. Taylor · 1993 · recommended by 1 person · 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
  • Sams teach yourself SQL in 10 minutes
    Ben Forta · 1999 · recommended by 0 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
  • Algorithmic puzzles
    Anany Levitin · 2011 · recommended by 1 person · similar by subject and what people say about it
  • SQL Cookbook
    Anthony Molinaro · 2005 · recommended by 7 people · similar by subject and what people say about it
  • The C puzzle book
    Alan R. Feuer · 1982 · recommended by 10 people · similar by subject and what people say about it
  • The Gödelian puzzle book
    Raymond M. Smullyan · 2013 · recommended by 2 people · similar by subject and what people say about it
  • SQL and relational theory
    C. J. Date · 2009 · recommended by 9 people · similar by subject and what people say about it
  • C Traps and Pitfalls
    Andrew Koenig · 1989 · recommended by 19 people · similar by subject and what people say about it
  • Learning SQL
    Alan Beaulieu · 2005 · recommended by 3 people · similar by subject and what people say about it
  • Aha! Insight
    Martin Gardner · 1978 · recommended by 4 people · similar by subject and what people say about it
  • Winning Ways for Your Mathematical Plays
    Elwyn R. Berlekamp · 1982 · recommended by 16 people · similar by subject and what people say about it
  • Database System Concepts
    Korth · 2005 · recommended by 4 people · similar by subject and what people say about it
  • Programming interviews exposed
    John Mongan · 2007 · recommended by 29 people · similar by subject and what people say about it
  • Developing time-oriented database applications in SQL
    Richard T. Snodgrass · 1999 · recommended by 6 people · loosely similar by subject