SQL and Relational Theory: How to Write Accurate SQL Code und über 1,5 Millionen weitere Bücher verfügbar für Amazon Kindle. Erfahren Sie mehr


oder
Loggen Sie sich ein, um 1-Click® einzuschalten.
oder
Mit kostenloser Probeteilnahme bei Amazon Prime. Melden Sie sich während des Bestellvorgangs an.
Jetzt eintauschen
und EUR 4,39 Gutschein erhalten
Eintausch
Alle Angebote
Möchten Sie verkaufen? Hier verkaufen
Der Artikel ist in folgender Variante leider nicht verfügbar
Keine Abbildung vorhanden für
Farbe:
Keine Abbildung vorhanden

 
Beginnen Sie mit dem Lesen von SQL and Relational Theory: How to Write Accurate SQL Code auf Ihrem Kindle in weniger als einer Minute.

Sie haben keinen Kindle? Hier kaufen oder eine gratis Kindle Lese-App herunterladen.

SQL and Relational Theory: How to Write Accurate SQL Code [Englisch] [Taschenbuch]

C.J. Date
4.0 von 5 Sternen  Alle Rezensionen anzeigen (2 Kundenrezensionen)
Statt: EUR 26,95
Jetzt: EUR 24,95 kostenlose Lieferung. Siehe Details.
Sie sparen: EUR 2,00 (7%)
  Alle Preisangaben inkl. MwSt.
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Nur noch 2 auf Lager (mehr ist unterwegs).
Verkauf und Versand durch Amazon. Geschenkverpackung verfügbar.
Lieferung bis Mittwoch, 30. Juli: Wählen Sie an der Kasse Morning-Express. Siehe Details.

Weitere Ausgaben

Amazon-Preis Neu ab Gebraucht ab
Kindle Edition EUR 17,30  
Taschenbuch EUR 24,95  

Kurzbeschreibung

18. Januar 2012
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. This second edition includes new material on recursive queries, "missing information" without nulls, new update operators, and topics such as aggregate operators, grouping and ungrouping, and view updating. If you have a modest-to-advanced background in SQL, you'll learn how to deal with a host of common SQL dilemmas. * Why is proper column naming so important? * Nulls in your database are causing you to get wrong answers. Why? What can you do about it? * Is it possible to write an SQL query to find employees who have never been in the same department for more than six months at a time? * SQL supports "quantified comparisons," but they're better avoided. Why? How do you avoid them? * Constraints are crucially important, but most SQL products don't support them properly. What can you do to resolve this situation? Database theory and practice have evolved since the relational model was developed more than 40 years ago. SQL and Relational Theory draws on decades of research to present the most up-to-date treatment of SQL available. C.J. Date has a stature that is unique within the database industry. A prolific writer well known for the bestselling textbook An Introduction to Database Systems (Addison-Wesley), he has an exceptionally clear style when writing about complex principles and theory.

Hinweise und Aktionen

  • Amazon Trade-In: Tauschen Sie Ihre gebrauchten Bücher gegen einen Amazon.de Gutschein ein - wir übernehmen die Versandkosten. Mehr erfahren


Wird oft zusammen gekauft

SQL and Relational Theory: How to Write Accurate SQL Code + Database Design and Relational Theory: Normal Forms and All That Jazz (Theory in Practice)
Preis für beide: EUR 52,90

Die ausgewählten Artikel zusammen kaufen


Produktinformation

  • Taschenbuch: 444 Seiten
  • Verlag: O'Reilly & Associates; Auflage: 2 (18. Januar 2012)
  • Sprache: Englisch
  • ISBN-10: 1449316409
  • ISBN-13: 978-1449316402
  • Größe und/oder Gewicht: 2,3 x 15,9 x 24,1 cm
  • Durchschnittliche Kundenbewertung: 4.0 von 5 Sternen  Alle Rezensionen anzeigen (2 Kundenrezensionen)
  • Amazon Bestseller-Rang: Nr. 215.917 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)

Mehr über den Autor

Entdecken Sie Bücher, lesen Sie über Autoren und mehr

Produktbeschreibungen

Über den Autor und weitere Mitwirkende

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.

Welche anderen Artikel kaufen Kunden, nachdem sie diesen Artikel angesehen haben?


Kundenrezensionen

4 Sterne
0
2 Sterne
0
1 Sterne
0
4.0 von 5 Sternen
4.0 von 5 Sternen
Die hilfreichsten Kundenrezensionen
2 von 2 Kunden fanden die folgende Rezension hilfreich
Format:Taschenbuch|Verifizierter Kauf
ungeeignet für Alle, die nach Kochrezepten suchen, um schnell ein gegebenenes Problem lösen: Dem Autor geht es um die Erklärung des relationalen Modells, dessen Unterstützung die de facto Monopol-Datenbanksprache SQL einerseits nur unvollkommen leistet und andererseits auch nicht erzwingt, weshalb die meisten Datenbanken in der Praxis nicht den Prinzipien genügen, nach denen die Väter dieses Modells, zu denen neben C.F. Codd auch der Autor C.J. Date gehört, diese Art der Datenhaltung konzipiert haben. Abweichungen von diesen Prinzipien sind nur in wenigen Fällen gerechtfertigt und führen selbst in moderat großen Systemen schnell zu Schwierigkeiten, denen sich die Betreiber derselben zumeist gar nicht bewusst sind. C.J. Date und H. Darwen haben die Sprache Tutorial D konzipiert, welche das relationale Modell besser unterstützt, vor allem aber vollständig realisiert. Der Autor gibt eine präzise Beschreibung des relationalen Modells - das hat er auch in mehreren anderen Büchern getan, das vorliegende ist jedoch der bis dato letzte Stand - und dazu ist Tutorial D in der Tat eine geeignete Sprache, die man dann leider auch lernen muss, um die Feinheiten und die Unterschiede zu falsch verwendetem SQL zu verstehen. Wer sich diese Mühe macht, wird an Hand dieser Darstellung verstehen, wie man auch in Ansi-SQL fast alle Aspekte umsetzen kann, um eine einwandfreie Anwendung zu erstellen, und die zahlreichen Fallen vermeiden kann, die in der blinden Verwendung von SQL lauern. Gemäß Einsteins Credo, dass man Probleme so einfach wie möglich, aber nicht einfacher darstellen sollte, hat C.J. Date hier gute Arbeit geleistet. Lesen Sie weiter... ›
War diese Rezension für Sie hilfreich?
2 von 2 Kunden fanden die folgende Rezension hilfreich
3.0 von 5 Sternen More relational than SQL oriented 18. Januar 2012
Von mko
Format:Taschenbuch
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.
Lesen Sie weiter... ›
War diese Rezension für Sie hilfreich?
Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)
Amazon.com: 3.4 von 5 Sternen  5 Rezensionen
19 von 21 Kunden fanden die folgende Rezension hilfreich
3.0 von 5 Sternen More relational than SQL oriented 18. Januar 2012
Von mko - Veröffentlicht auf Amazon.com
Format:Taschenbuch
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.
15 von 17 Kunden fanden die folgende Rezension hilfreich
2.0 von 5 Sternen Great content, terrible writing 13. Juni 2012
Von Dan P - Veröffentlicht auf Amazon.com
Format:Taschenbuch
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 von 7 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Timeless 24. Juli 2012
Von SB - Veröffentlicht auf Amazon.com
Format:Kindle Edition|Verifizierter Kauf
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
1 von 1 Kunden fanden die folgende Rezension hilfreich
3.0 von 5 Sternen Academic, not practical 5. Januar 2014
Von Timothy Beckham - Veröffentlicht auf Amazon.com
Format:Taschenbuch|Verifizierter Kauf
I am plowing my way through this book, and I must say that it appears to be impressive from an abstract, mathematical point of view, but I don't understand it!! I have been programming with PHP/MySQL for a few years, getting along ok, but in need of some theory behind my efforts. I thought Date's books would do it, especially in light of the reviews I've been reading. However, the author writes with such abstract complexity (though he tries - and fails - to make it seem down-to-earth), that I have to read and reread and reread and reread the same sentence, just to get some sense of what he is trying to say!

For example, Date defines an interesting term, "relvar", which stands for "relation variable". He goes into some detail about how that is distinguished from a "relation value", a "relation", a "table", and other terms. After reading it all, I thought I understood what a relvar was. Turns out that there is some distinction between "relvar" and "relation" or "relation value" that still escapes me, so when I get into other areas of the book, I am lost. This is a major aspect of Date's explanations of the relational model, yet I cannot grasp the subtleties that he finds fundamental - and, apparently, obvious. What a mess!

Date requires precision in the definition of terms, and I understand that from a philosophical point of view. However, he does not go through adequate explanations of those definitions, at least from my point of view. Yet he then proceeds to use those terms rather casually, assuming the reader understands his rather obtuse and insufficient explanations,

I need a book to walk me through the intricate differences between the practical tasks of programming with a particular system such as MySQL and the corresponding, abstract aspects of the relational model. Date purports to do that, but he failed with me.

I am not sure what to recommend about this book, but it seems clear to me that any reader should start out with a fairly firm understanding of the mathematics of set theory and how the relational model fits into that. Then one should read Date with a bit of care, because, although I am sure he tries to write with insight and clarity, I don't think he succeeds very well.
0 von 1 Kunden fanden die folgende Rezension hilfreich
4.0 von 5 Sternen Great book 2. Juli 2013
Von Angel Rivera - Veröffentlicht auf Amazon.com
Format:Taschenbuch|Verifizierter Kauf
The only problem I had was that it was more technical than I needed. Will come in handy down the road.
Waren diese Rezensionen hilfreich?   Wir wollen von Ihnen hören.
Kundenrezensionen suchen
Nur in den Rezensionen zu diesem Produkt suchen

Kunden diskutieren

Das Forum zu diesem Produkt
Diskussion Antworten Jüngster Beitrag
Noch keine Diskussionen

Fragen stellen, Meinungen austauschen, Einblicke gewinnen
Neue Diskussion starten
Thema:
Erster Beitrag:
Eingabe des Log-ins
 

Kundendiskussionen durchsuchen
Alle Amazon-Diskussionen durchsuchen
   


Ähnliche Artikel finden


Ihr Kommentar