
SQL Cookbook
Anthony Molinaro · 2005
Programming and computer science › Databases and distributed data
#5,428 most recommended
Hacker News
7
mentions by 7 people · top 38% of 15,732 books
Open Library
4.00★★★★★★★★★★
1 rating · 10 want to read
Wikipedia
—
No article yet
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
In the commenters’ own words
Did you try SQL Cookbook? I think that was the one I used to enjoy. Lots of receipts. The first are quite simple but the later, more advanced ones should take…
Yeah but the functions and style used in these answers vary across implementations (date_trunc, etc.) I highly recommend the SQL Cookbook for newer SQL dev as…
What Open Library readers say 4.00 from 1 rating
- 50
- 41
- 30
- 20
- 10
- 10 want to read
- 1 reading
- 2 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
Details
- First published
- 2005
- ISBN
- 9780596009762
- Editions known
- 2 at Open Library
- Open Library
- OL8167532W
Read next: its neighbours on the mosaic
Learning SQLAlan Beaulieu · 2005 · recommended by 3 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 antipatternsBill Karwin · 2010 · recommended by 31 people · similar by subject and what people say about it
Joe Celko's SQL for SmartiesJoe Celko · 1995 · recommended by 10 people · similar by subject and what people say about it
Transactional information systemsGerhard Weikum · 2001 · recommended by 2 people · loosely similar by subject
The art of SQLStephane Faroult · 2006 · recommended by 8 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
SQL for Web NerdsPhilip Greenspun · 2000 · recommended by 7 people · similar by subject and what people say about it
PostgreSQL 16 Administration CookbookGianni Ciolli · 2023 · 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
The data warehouse toolkitRalph Kimball · 1996 · recommended by 23 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
Pro SQL Server InternalsDmitri Korotkevitch · 2014 · recommended by 2 people · similar by subject and what people say about it
High Performance MySQLJeremy D. Zawodny · 2004 · recommended by 27 people · similar by subject and what people say about it
Ruby cookbookLucas Carlson · 2006 · recommended by 1 person · 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
The data model resource bookLen Silverston · 1997 · recommended by 8 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
Database InternalsAlex Petrov · 2019 · recommended by 31 people · similar by subject and what people say about it
SQL puzzles & answersJoe Celko · 1997 · recommended by 3 people · similar by subject and what people say about it
SQL and relational theoryC. J. Date · 2009 · recommended by 9 people · loosely similar by subject
Database System ConceptsKorth · 2005 · recommended by 4 people · similar by subject and what people say about it
The Guru's Guide to Transact-SQLKen Henderson · 2000 · recommended by 2 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