
SQL and relational theory
C. J. Date · 2009
Programming and computer science › Databases and distributed data
#3,088 most recommended
Hacker News
17
mentions by 13 people · top 19% of 15,732 books
Open Library
—
No ratings yet
5 want to read
Wikipedia
—
No article yet
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
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…
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…
What Open Library readers say
No Open Library reader has rated it yet.
- 5 want to read
- 1 reading
- 0 have read
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
Read next: its neighbours on the mosaic
Database Design and Relational TheoryC. J. Date · 2012 · recommended by 1 person · similar by subject and what people say about it
An introduction to database systemsC. J. Date · 1975 · recommended by 14 people · 2 people recommended both
Learning SQLAlan Beaulieu · 2005 · recommended by 3 people · similar by subject and what people say about it
Transactional information systemsGerhard Weikum · 2001 · recommended by 2 people · similar by subject and what people say about it
Database in depthC. J. Date · 2005 · recommended by 4 people · similar by subject and what people say about it
Time and Relational TheoryC. J. Date · 2014 · recommended by 1 person · similar by subject and what people say about it
Foundations of databasesSerge Abiteboul · 1994 · recommended by 1 person · 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 relational model for database managementE. F. Codd · 1990 · recommended by 2 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
Readings in database systemsMichael Stonebraker · 1998 · recommended by 11 people · 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
UNIX relational database managementRod Manis · 1988 · recommended by 2 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
Database management systemsRaghu Ramakrishnan · 2001 · recommended by 7 people · similar by subject and what people say about it
The art of SQLStephane Faroult · 2006 · recommended by 8 people · similar by subject and what people say about it
Database Design for Mere MortalsMichael J. Hernandez · 1996 · recommended by 12 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
SQL Performance ExplainedMarkus Winand · 2011 · recommended by 26 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
Database design and implementationEdward Sciore · 2008 · recommended by 7 people · similar by subject and what people say about it
Data and RealityWilliam Kent · 1978 · recommended by 15 people · similar by subject and what people say about it
Version control with GitJon Loeliger · 2009 · recommended by 6 people · loosely similar by subject