DeepRead
Cover of SQL and relational theory

SQL and relational theory

C. J. Date · 2009

Programming and computer science › Databases and distributed data

#3,088 most recommended

About the book

The book explains the relational model that underlies SQL, covering relations, predicates, and relational operators, and shows how SQL's constructs map onto that theory. It is aimed at working developers who write queries and design schemas and want to understand why their SQL returns the results it does. Date argues that SQL departs from the relational model in ways that can silently produce incorrect results, including duplicate rows, nulls, and three-valued logic. He contends that knowing the underlying theory lets a programmer write SQL that is correct by construction rather than by trial and error. The book applies that position to query formulation and database design, using the relational model as the standard against which SQL is judged.

Written by Claude from what it knows of this book.

What Hacker News says 69% recommend · 0% critical

02.552010201520202012 peak · 5
This bookAverage book in Databases and distributed data

In the commenters’ own words

  • I wasn't a programmer (finance background), and I learnt enough SQL to be useful in perhaps 20 minutes. Reading just one Date book [1] took me a further 3…

    crdb · 2015 · in Ask HN: My son wants to make side money programming

  • I was about to prepare the query without ties and yes it is a lot harder than necessary and, more important IMO, much less readable/intuitive for people than…

    cico71 · 2012 · in OrmHate

What Open Library readers say

No Open Library reader has rated it yet.

  • 5 want to read
  • 1 reading
  • 0 have read

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
2009
ISBN
9781449319724
Editions known
2 at Open Library
Open Library
OL18355805W

Com051000Cs.cmp_sc.app_swCs.cmp_sc.prog_langDatabase managementGamesGeneralProfessional, career & trade -> computer science -> generalProfessional, career & trade -> computer science -> programming languages (jr/sr)Professional, career & trade -> computer science -> sqlRelational databasesSQL (Computer program language)Sql

Explore in the mosaic

Read next: its neighbours on the mosaic