Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

SQL and Relational Theory: How to Write Accurate SQL Code Second Edition Edition

3.7 out of 5 stars 6 customer reviews
Related Text
ISBN-13: 978-1449316402
ISBN-10: 1449316409
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Sell yours for a Gift Card
We'll buy it for $8.42
Learn More
Trade in now
Have one to sell? Sell on Amazon
Rent On clicking this link, a new layer will be open
$15.85 On clicking this link, a new layer will be open
Buy used On clicking this link, a new layer will be open
$25.46 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$39.99 On clicking this link, a new layer will be open
More Buying Choices
13 New from $29.91 15 Used from $20.97

There is a newer edition of this item:

Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Save Up to 90% on Textbooks Textbooks
$39.99 FREE Shipping. Only 9 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.


Frequently Bought Together

  • SQL and Relational Theory: How to Write Accurate SQL Code
  • +
  • Database Design and Relational Theory: Normal Forms and All That Jazz (Theory in Practice)
Total price: $76.77
Buy the selected items together

Editorial Reviews

About the Author

C.J. Date has a stature that is unique within the database industry. C.J. is a prolific writer, and is well-known for his best-selling textbook: An Introduction to Database Systems (Addison Wesley). C.J. is an exceptionally clear-thinking writer who can lay out principles and theory in a way easily understood by his audience.

NO_CONTENT_IN_FEATURE



Product Details

  • Paperback: 448 pages
  • Publisher: O'Reilly Media; Second Edition edition (December 28, 2011)
  • Language: English
  • ISBN-10: 1449316409
  • ISBN-13: 978-1449316402
  • Product Dimensions: 7 x 0.9 x 9.2 inches
  • Shipping Weight: 1.4 pounds (View shipping rates and policies)
  • Average Customer Review: 3.7 out of 5 stars  See all reviews (6 customer reviews)
  • Amazon Best Sellers Rank: #1,134,698 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Top Customer Reviews

Format: Paperback
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.
Read more ›
2 Comments 23 of 26 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I purchased this book to get a good grasp on the theory behind database systems, which I use in my regular work. In terms of content, it's all here. All the knowledge is represented and understandable.

But I have to stress how awful the writing in this book can be. The author wastes a lot of time repeating himself or speaking in a condescending manner about "common practices" and "misconceptions." After reading the reviews and praise for this book on both Amazon and StackOverflow, I was expecting clarity and concision in the spirit of Kernighan and Ritchie's The C Programming Language, but I was thoroughly disappointed. Date's book is painful to read. There are some sections which read well enough, but too often the pacing of the book grinds to a halt as he reiterates or over-elaborates on minor points, and occasionally his tone is so overbearing and condescending that I get frustrated and have to put the book down.

There are things to learn here. But you will have a painful time finding them as you slog through this book.
6 Comments 20 of 25 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
By SB on July 23, 2012
Format: Kindle Edition Verified Purchase
This book is amazing! Chap 11 alone is worth it! Date can repeat the same thing (I've read most of his books) a 100 times, but each time he provides a subtle different insight. He describes in detail why some issues are bad (nulls, duplicates etc) -- sound simple, but it is easy to overlook their 'side-effects' , how entities (rvas) must be treated semantically (predicates), semi join & join are unrelated, but difference is special semi-difference . Date is 'Time'less
2 Comments 8 of 10 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
SQL and Relational Theory: How to Write Accurate SQL Code
This item: SQL and Relational Theory: How to Write Accurate SQL Code
Price: $39.99
Ships from and sold by Amazon.com