Please Sign Up to Request This Product

SQL and Relational Theory

How to Write Accurate SQL Code

You need to be an approved reviewer to request a product. Please sign up to request access or login to your account.

If you've already signed up and you haven't heard from us yet please email reviewers@oreilly.com and we will check on your request.

Description

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.

Reviews

On Feb 4 Kiatikun Luangkesorn wrote:
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. Full Review  >

Rating: StarStarStarStarStar4.0

On Jan 19 Sriram Sanka wrote: Good reference for relational concepts
This book does n`t deal with SQL statements .. But is all about between SQL and the Relational concepts theory in a mathematical way.How SQL departs from relational theory, the basic principles of relational theory etc… Full Review  >

Rating: StarStarStarStarStar4.0

On Jan 18 Michal Konrad Owsiak wrote: More relational than SQL oriented
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. Full Review  >

Rating: StarStarStarStarStar3.0

On Jan 2 Surachart Opun wrote: Great book for SQL and Relational
In this book, you learn about Relational model; Types and Domains, Tuples and Relations,... that's all many contents, ideas and examples. You will learn SQL and Relational theory from Professional. When you read each chapter finish, you will see "Exercise", that will help you memorize and understand more. It has well-formed paragraphs and many references; it's good for readers. I believe this book is useful for DBAs, students and someone who interests in SQL and Relational. Full Review  >

Rating: StarStarStarStarStar5.0

Receive free ebooks and videos in exchange for your reviews.

Join the O'Reilly Reader Review Program

Learn more >

Returning?

Top Reviewers

Michal Konrad Owsiak, 95 Reviews

Santosh Shanbhag, 61 Reviews

Surachart Opun, 60 Reviews

Doron Katz, 57 Reviews

Shawn Day, 55 Reviews

See More Reviewers >

Featured Review

Mac Hacks

Doron Katz wrote:
Your springboard for the curious-minded
A smorgasbord cookbook of recipes to help you get the most of your mac, Mac… Full Review >

Rating: StarStarStarStarStar4.0