IT-eBooks.directory Facebook Icon Image IT-eBooks.directory Google Plus Icon Image IT-eBooks.directory Twitter Icon Image
IT-eBooks.directory Logo Image

SQL and Relational Theory

How to Write Accurate SQL Code

SQL and Relational Theory Image

Book details:

Publisher:O'Reilly Media
Categories: OReilly , How To
Author:
Edition:1
ISBN-10:0596523068
ISBN-13:9780596523060
Pages:428
Published:
Posted:Jun 30 2016
Language:English
Book format:CHM
Book size:1.19 MB

Book Description:

Understanding SQL's underlying theory is the best way to guarantee that your SQL code is correct and your database schema is robust and maintainable. On the other hand, if you're not well versed in the theory, you can fall into several traps. In SQL and Relational Theory, author C.J. Date demonstrates how you can apply relational theory directly to your use of SQL. With numerous examples and clear explanations of the reasoning behind them, you'll learn how to deal with common SQL dilemmas, such as:Should database access granted be through views instead of base tables? Nulls in your database are causing you to get wrong answers. Why? What can you do about it? Could you 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 Edgar Codd originally defined the relational model back in 1969. Independent of any SQL products, SQL and Relational Theory draws on decades of research to present the most up-to-date treatment of the material available anywhere. Anyone with a modest to advanced background in SQL will benefit from the many insights in this book.

Download Link:

Related Books:

SQL and Relational Theory 2nd Edition Image

SQL and Relational Theory 2nd Edition

Jun 30 2016 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 backgro...

Time and Relational Theory Image

Time and Relational Theory

Aug 19 2016 Time and Relational Theory provides an in-depth description of temporal database systems, which provide special facilities for storing, querying, and updating historical and future data. Traditionally, database management systems provide little or no special support for temporal data at all. This situation is changing because: * Cheap storage enables retention of large volumes of historical data in data warehouses* Users are now faced with temporal data problems, and need solutions * Temporal features have recently been incorporated into the SQL standard, and vendors have begun to add temporal...

IT-eBooks.directory