Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
SQL and Relational Theory: How to Write Accurate SQL Code

Buy

This edition differs from its predecessor in a number of ways. The overall objective remains the same, of course— using SQL relationally is still the emphasis—but the text has been revised throughout to reflect, among other things, experience gained from teaching live seminars based on the first edition.

One significant change is a deletion: The appendix on design theory has gone. There are two reasons for this change. First, design theory as such never really did have all that much to do with the book’s main message, anyway; second, the appendix was getting so extensive that it threatened to overwhelm the rest of the text. (It was already longer than any chapter or any other appendix in the book. In fact, I’ve since expanded the material into a separate book in its own right. That book—Normal Forms and All That Jazz: A Database Professional’s Guide to Database Design Theory—is due to be published soon by O’Reilly. It can be seen as a companion, or perhaps a sequel, to the present book.)

On the positive side, a lot of new material has been added (including, importantly, a discussion of how to deal with missing information without using nulls); examples, exercises, and answers have been expanded and improved in various respects; and the treatment of SQL has been upgraded to cover recent changes to the SQL standard. A variety of corrections and numerous cosmetic improvements have also been made.2 (In particular, the Tutorial D examples—Tutorial D being the language I use to illustrate relational concepts—have been upgraded to reflect several recent improvements to that language. See Appendix D.) The net effect is to make the text rather more comprehensive—but, sadly, some 25 percent bigger—than its predecessor.

Talking of the text, I’d like to say something about my use of footnotes. Frankly, I’m rather embarrassed at how many footnotes there are; I’m well aware how annoying they can be—indeed, they can seriously impede readability. But any text dealing with SQL is more or less forced into a heavy use of footnotes, at least if it wants to be tutorial in nature and yet reasonably comprehensive at the same time. The reason is that SQL involves so many inconsistencies, exceptions, and special cases that treating everything “in line”—i.e., at the same level of description—makes it very difficult to see the forest for the trees. (Indeed, this is one reason why the SQL standard itself is so difficult to understand.) Thus, there are numerous places in the book where the major idea is described “in line” in the main body of the text, and exceptions and the like (which must at least be mentioned, for reasons of accuracy and completeness) are relegated to a footnote. It might be best simply to ignore all footnotes on a first reading.

(HTML tags aren't allowed.)

Learning Chef
Learning Chef

Automate your infrastructure using code and leverage DevOps with Chef

About This Book

  • Leverage the power of Chef to transform your infrastructure into code to deploy new features in minutes
  • Understand the Chef architecture and its various components including the different types of server...
Web 2.0 and Social Networking for the Enterprise: Guidelines and Examples for Implementation and Management Within Your Organization
Web 2.0 and Social Networking for the Enterprise: Guidelines and Examples for Implementation and Management Within Your Organization
Humans are creatures of collaboration. Since the beginning of time, we have sought each other out and wanted to communicate and share. Language finds its very purpose in this. As social beings, and aided by all manner of advancement, our ability to interact has evolved.

Centuries ago, man stood on hilltops separated by miles and
...
Earthquake Early Warning Systems
Earthquake Early Warning Systems
In the last few decades economic losses due to natural disasters have increased exponentially worldwide and little progress has been seen in reducing their rate of fatalities. This also holds for earthquake disasters and is mainly due to increasing population and industrial density in high hazard and vulnerability areas....

Oscillation-Based Test in Mixed-Signal Circuits
Oscillation-Based Test in Mixed-Signal Circuits

Oscillation-Based Test in Mixed-Signal Circuits presents the development and experimental validation of the structural test strategy called Oscillation-Based Test – OBT in short. The results here presented allow to assert, not only from a theoretical point of view, but also based on a wide experimental support, that OBT is an efficient...

Pediatric Infectious Diseases Revisited (Birkh?user Advances in Infectious Diseases)
Pediatric Infectious Diseases Revisited (Birkh?user Advances in Infectious Diseases)
In both industrialized and developing countries, childhood immunization has become one of the most important and cost-effective public health interventions. National immunization programs have prevented millions of deaths since WHO initiated the ‘Expanded Program on Immunization’ in 1974. Smallpox was eradicated in 1979,...
ALGORITHMS FOR LINEAR-QUADRATIC OPTIMIZATION
ALGORITHMS FOR LINEAR-QUADRATIC OPTIMIZATION

Linear-quadratic optimization is one of the most exciting topics in the con trol engineering literature of recent decades. The interest in linear optimal dynamical systems, and especially in those with quadratic cost functional, can be explained by both the richness of properties these systems possess, and the pragmatic value and physical...

©2021 LearnIT (support@pdfchm.net) - Privacy Policy