Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put the theory into practice. In this insightful book, author C.J. Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it directly to your use of SQL.

Subscriber Reviews

Average Rating: 4 out of 5 rating Based on 2 Ratings

"More relational than SQL oriented" - by mko on 18-JAN-2012
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
SQL and Relational Theory is devoted to relational theory and explaining why SQL is not relationally complete. Author will guide you through various topics from the relational modeling and show how SQL is limited in a way. At some point this is interesting but will left you with a felling that you have to stick to practices derived from particular implementation of the SQL while at the same time you will be aware of it’s limitations in relational sense. This can lead to the increase of the anger level towards your database vendor.

When I was reading the book there was one thing that bothered me all the time. C.J. introduces “Tutorial D” language which is, let’s say, better suited for relation modeling than SQL is. I can agree with C.J. here, but question is whether learning yet another language just for the tutorial purpose is worth the effort. I am not sure what the answer should be, because it is hard to imagine how to explain some of the topics without any language at all.

When you read the book, you can definitely tell that C.J. has mathematical background. He tries to be very specific at almost each aspect of the book and makes no space for misinterpretation – especially when it comes to the definitions. Sometimes it seems to be little bit awkward though (e.g. see the definition of comma separated list). This has it’s advantages and disadvantages. At some point you can be sure what author meant to say, while at the same time the language of the book has this special, “scientific feeling”. I, personally, am the very fan of Wittgenstein’s thesis that everything you want to say can be said simply. Anyway, bear in mind that the book is theoretical rather than pragmatic.

While I value the content of the book, I can’t say I read it cover to cover over just one evening holding my breath. This book has academic style (lots of condensed information) and it doesn’t suit me. On the other hand, the topic itself is neither a fiction. Summarizing. If you are looking for a book that will teach you SQL a gentle way. Don’t buy it. However, if you are aware of the relational theory, if you are looking for a theoretical background and want to extend you knowledge in data modeling area, I think you may find this book really comprehensive and interesting.

Report as Inappropriate

Table of Contents

 

Extras

The publisher has provided additional content related to this title.


Description
Content

Visit the catalog page for SQL and Relational Theory, 2nd Edition

  • Catalog Page

Visit the errata page for SQL and Relational Theory, 2nd Edition

  • Errata