
The art of SQL
Stephane Faroult, Peter Robson · 2006
Programming and computer science › Databases and distributed data
#4,421 most recommended
Hacker News
10
mentions by 9 people · top 29% of 15,732 books
Open Library
3.00★★★★★★★★★★
1 rating · 2 want to read
Wikipedia
—
No article yet
About the book
A practical guide to writing SQL for relational databases, covering how to express data retrieval and modification in set-based terms and how the database engine executes a statement. Its scope is hands-on: query design, joins, subqueries, aggregation, and the indexing and optimizer behaviour that decide whether a query performs well. Faroult's central claim is that many SQL performance and correctness problems come from applying procedural habits to a declarative, set-oriented language, and that good SQL requires understanding how the engine will run it. He argues that developers should reason in sets rather than row by row, know their data and its distribution, and use indexes and the optimizer's behaviour deliberately rather than by guesswork. These ideas are presented through common patterns and anti-patterns, aimed at working developers who want to go beyond basic syntax.
Written by Claude from what it knows of this book.
What Hacker News says 89% recommend · 0% critical
In the commenters’ own words
I don't have any one complete book that I can recommend, and I don't even really have a great reading list for this. But I'll make an attempt to share what I…
It's tricky because most database writing is about SQL and OLTP and other practical things, but studying those things without first understanding the basic…
What Open Library readers say 3.00 from 1 rating
- 50
- 40
- 31
- 20
- 10
- 2 want to read
- 0 reading
- 1 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
- 2006
- ISBN
- 9780596008949
- Editions known
- 6 at Open Library
- Open Library
- OL18678599W
Com051170Cs.cmp_sc.app_swCs.cmp_sc.prog_langGamesGeneralSQL (Computer program language)SqlSql (computer program language)
Read next: its neighbours on the mosaic
SQL Queries for Mere MortalsJohn L. Viescas · 2018 · recommended by 2 people · similar by subject and what people say about it
The art of R programmingNorman S. Matloff · 2011 · recommended by 8 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
UNIX Shell programmingStephen G. Kochan · 1985 · recommended by 4 people · loosely similar by subject
SQL Performance ExplainedMarkus Winand · 2011 · recommended by 26 people · similar by subject and what people say about it
The Art of PostgreSQLDimitri Fontaine · 2019 · recommended by 20 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
SQL for Web NerdsPhilip Greenspun · 2000 · recommended by 7 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
Programming PearlsJon Bentley · 1999 · recommended by 158 people · 2 people recommended both
TCP/IP IllustratedW. Richard Stevens · 1994 · recommended by 58 people · 2 people recommended both
Linux command line and shell scripting bibleRichard Blum · 2008 · recommended by 2 people · loosely similar by subject
Learning SQLAlan Beaulieu · 2005 · recommended by 3 people · similar by subject and what people say about it
Introduction to programming in JavaRobert Sedgewick · 2007 · recommended by 1 person · loosely similar by subject
High Performance MySQLJeremy D. Zawodny · 2004 · recommended by 27 people · similar by subject and what people say about it
Elements of programmingAlexander A. Stepanov · 2009 · recommended by 31 people · similar by subject and what people say about it
The Practice of ProgrammingBrian W. Kernighan · 1999 · recommended by 90 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 Manga Guide to DatabasesMana Takahashi · 2005 · 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
SQL CookbookAnthony Molinaro · 2005 · recommended by 7 people · 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
The Art of Readable CodeDustin Boswell · 2011 · recommended by 11 people · similar by subject and what people say about it
The art of RailsEdward Benson · 2008 · recommended by 4 people · similar by subject and what people say about it