Date C.J. SQL and Relational Theory: How to Write Accurate SQL Code

2nd edition. — O’Reilly Media, Inc., 2011. — 445 p. — ISBN: 1449316409, 9781449316402.One of the most famous researchers and authors in relational databases shows how to program in SQL in a robust manner that avoids many common errors and facilitates long-term data maintenance.
The SQL database query language is full of traps for those who are not well educated in the concepts of relational databases. In this book, researcher C.J. Date explains the best practices of database coding, with clear explanations of the reasoning behind them. The book drawson decades of research to offer clear advice with plenty of examples.Key Selling Points:
New edition benefits from experience gained from teaching live seminars.
New material includes doing missing information and "don't know" queries without nulls, new update operators, aggregate operators, grouping and ungrouping, and view updating.
Teaches relational database principles and how to apply them in practice.
Aimed at SQL practitioners (people with SQL experience, not beginners).
Shows how to avoid pitfalls that ensue when following naive advice offered in many beginners' books.
Written by one of the earliest researchers in relational databases, with insights gained from decades of practice and consulting.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.