DeepRead
Cover of The art of SQL

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

02420082010201520212020 peak · 3
This bookAverage book in Databases and distributed data

In the commenters’ own words

What Open Library readers say 3.00 from 1 rating

  1. 50
  2. 40
  3. 31
  4. 20
  5. 10
  • 2 want to read
  • 0 reading
  • 1 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
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)

Explore in the mosaic

Read next: its neighbours on the mosaic

  • SQL Queries for Mere Mortals
    John L. Viescas · 2018 · recommended by 2 people · similar by subject and what people say about it
  • The art of R programming
    Norman S. Matloff · 2011 · recommended by 8 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
  • UNIX Shell programming
    Stephen G. Kochan · 1985 · recommended by 4 people · loosely similar by subject
  • SQL Performance Explained
    Markus Winand · 2011 · recommended by 26 people · similar by subject and what people say about it
  • The Art of PostgreSQL
    Dimitri Fontaine · 2019 · recommended by 20 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
  • SQL for Web Nerds
    Philip Greenspun · 2000 · recommended by 7 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
  • Programming Pearls
    Jon Bentley · 1999 · recommended by 158 people · 2 people recommended both
  • TCP/IP Illustrated
    W. Richard Stevens · 1994 · recommended by 58 people · 2 people recommended both
  • Linux command line and shell scripting bible
    Richard Blum · 2008 · recommended by 2 people · loosely similar by subject
  • Learning SQL
    Alan Beaulieu · 2005 · recommended by 3 people · similar by subject and what people say about it
  • Introduction to programming in Java
    Robert Sedgewick · 2007 · recommended by 1 person · loosely similar by subject
  • High Performance MySQL
    Jeremy D. Zawodny · 2004 · recommended by 27 people · similar by subject and what people say about it
  • Elements of programming
    Alexander A. Stepanov · 2009 · recommended by 31 people · similar by subject and what people say about it
  • The Practice of Programming
    Brian W. Kernighan · 1999 · recommended by 90 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 Manga Guide to Databases
    Mana Takahashi · 2005 · 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
  • SQL Cookbook
    Anthony Molinaro · 2005 · recommended by 7 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
  • The Art of Readable Code
    Dustin Boswell · 2011 · recommended by 11 people · similar by subject and what people say about it
  • The art of Rails
    Edward Benson · 2008 · recommended by 4 people · similar by subject and what people say about it