SQL and Relational Theory: How to Write Accurate SQL Code
Enlarge cover
Rate this book
Clear rating

SQL and Relational Theory: How to Write Accurate SQL Code

3.67 of 5 stars 3.67  ·  rating details  ·  51 ratings  ·  11 reviews
Understanding SQL's underlying theory is the best way to guarantee that your SQL code is correct and your database schema is robust and maintainable. On the other hand, if you're not well versed in the theory, you can fall into several traps. In SQL and Relational Theory, author C.J. Date demonstrates how you can apply relational theory directly to your use of SQL. With nu...more
Kindle Edition, 432 pages
Published (first published January 1st 2009)
more details... edit details

Friend Reviews

To see what your friends thought of this book, please sign up.

Reader Q&A

To ask other readers questions about SQL and Relational Theory, please sign up.

Be the first to ask a question about SQL and Relational Theory

This book is not yet featured on Listopia. Add this book to your favorite list »

Community Reviews

(showing 1-30 of 249)
filter  |  sort: default (?)  |  rating details
Mike
There is a scene in The Simpsons where Homer, on a health kick, declares, "I only eat food in bar form. When you concentrate food, you unleash its awesome power, I’m told." He then goes on to compress five pounds of spaghetti into a bar shape, and after quickly eating the condensed mega-meal asks for an ambulance. One might have a similar reaction after reading SQL and Relational Theory: How to Write Accurate SQL Code: there is so much covered in so little space coupled with the suggested exerci...more
Paul
C.J. Date is angry.

He's been working with the relational algebra for a long time—longer than SQL's been around—and he wishes people would use it. He wrote Databases, Types, and the Relational Model: The Third Manifesto with Hugh Darwen to try to rectify things, but productization seems elusive.

In the meantime, thankfully, Date has squinted hard at SQL and managed to find ways to approach it actually relationally (no, SQL as normally practiced can't be said to be relational—another example of ter...more
Louis
Date's book is almost two books in one. First is a book on relational theory. As such, it is meant for deep reading. The second is SQL, the Good Parts. And as such it can get pendantic. But for someone who already knows something about working with data, it can be a good discussion on what you can and cannot get away with.

The first part of the book is an introduction to relational theory, mixed with the author's discussion of what is wrong with the SQL specification and the various implementatio...more
Karl Evard
NOT FOR YOUR AVERAGE PROGRAMMER

This book takes a deep look in to how databases should be and not how they are and how you can make use of them. As a book on DB mathematics it would get 5 stars but as a book to teach "how to write accurate SQL code" It falls far short of it's goal.
Issues
1) Most people who are looking to "write accurate SQL code" are not at the mathematical level that this book requires. They are your average Joe Programmer and while they could benefit greatly from the math behind...more
Peter House
"SQL and Relational Theory", a book written by one of E.F. Codd's contemporaries, C.J. Date, is intended to give database practitioners an introduction to relational theory and its relationship with the SQL standard and syntax. The book accomplishes this goal but not in a clean way. The author has a lot to say about the SQL standard, much of which isn't unfair, but he does it in a way that is disruptive to the flow of the book.

Much of the conversation around SQL in this book tends be normative i...more
Doug
This is a rigorous discussion of relational theory and how SQL fails to adhere to its practice, entirely. Therefore the author introduces a relationally-complete language, Tutorial D, alongside SQL, to show its advantages. I found this tutorial language to be more logically sound, but as it has no practical implementation, it's academic at best. That is, there are no database products that I use that could employ this language. I am stuck with SQL, so I agree with Celko's conclusion.

Celko's rev...more
Ben
It was quite a trudge through this book.

(As a disclaimer on this review, I should mention I only have a basic familiarity of SQL and this book assumes a more thorough knowledge of it from the outset. I doubt I'm qualified to have a strong an opinion on the book.)

One of the more compelling aspects of this book was that is seemed to target an approach of "theory in use." Since that's an expression that as far as I know I just made up, I'll define it quickly. Many technical books either fall loose...more
Bruce
A painful read and that's not because of the topic matter.

The author desperately needed an editor to come in and horrible sentence structure and ditch a good 25% of the text in this book. The author's writing style left me screaming "GET TO THE @^$#ING POINT".

It's hard to get anything out a book when every other sentence has parenthesis and references to asides. A decent editor would have avoided this and greatly improved the book. I'm sure the author knows his stuff and I'm sure the book has gr...more
Thomas
Oct 09, 2011 Thomas marked it as to-read
Reading this on my phone as an epub, so it's a bit slow going. I have the older edition of this in print, but it's changed enough that I'm trying to stick to the newer material.
JJ
I always wondered why SQL works the way it does. This book has the answers.
M
M marked it as to-read
Sep 19, 2014
Adesa Victor
Adesa Victor marked it as to-read
Sep 17, 2014
Keshavamurthy B.n.
Keshavamurthy B.n. marked it as to-read
Sep 10, 2014
Tom Fitz
Tom Fitz marked it as to-read
Sep 08, 2014
Jacob Gabrielson
Jacob Gabrielson marked it as to-read
Aug 31, 2014
Paulo Nuin
Paulo Nuin marked it as to-read
Aug 08, 2014
Ryan Linton
Ryan Linton marked it as to-read
Jul 23, 2014
Deepa
Deepa added it
Jul 21, 2014
Madhuri
Madhuri marked it as to-read
Jul 03, 2014
Ujwalendu Prakash
Ujwalendu Prakash is currently reading it
Aug 04, 2014
Gábor Barát
Gábor Barát is currently reading it
Jun 15, 2014
« previous 1 3 4 5 6 7 8 9 next »
There are no discussion topics on this book yet. Be the first to start one »

Goodreads is hiring!

If you like books and love to build cool products, we may be looking for you.
Learn more »
Christopher J. Date (born 1941) is an independent author, lecturer, researcher, and consultant, specializing in relational database theory.
--from wikipedia
More about C.J. Date...
An Introduction to Database Systems Database in Depth: Relational Theory for Practitioners Databases, Types, and the Relational Model: The Third Manifesto Temporal Data & the Relational Model A Guide to SQL Standard

Share This Book