SQL and Relational Theory

SQL and Relational Theory
Author :
Publisher : "O'Reilly Media, Inc."
Total Pages : 447
Release :
ISBN-10 : 9781449316402
ISBN-13 : 1449316409
Rating : 4/5 (409 Downloads)

Book Synopsis SQL and Relational Theory by : C. Date

Download or read book SQL and Relational Theory written by C. Date and published by "O'Reilly Media, Inc.". This book was released on 2011-12-16 with total page 447 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.


SQL and Relational Theory Related Books

SQL and Relational Theory
Language: en
Pages: 447
Authors: C. Date
Categories: Computers
Type: BOOK - Published: 2011-12-16 - Publisher: "O'Reilly Media, Inc."

DOWNLOAD EBOOK

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 pr
SQL and Relational Theory
Language: en
Pages: 447
Authors: C.J. Date
Categories: Computers
Type: BOOK - Published: 2011-12-16 - Publisher: "O'Reilly Media, Inc."

DOWNLOAD EBOOK

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 pr
Time and Relational Theory
Language: en
Pages: 579
Authors: C.J. Date
Categories: Computers
Type: BOOK - Published: 2014-08-13 - Publisher: Morgan Kaufmann

DOWNLOAD EBOOK

Time and Relational Theory provides an in-depth description of temporal database systems, which provide special facilities for storing, querying, and updating h
Database in Depth
Language: en
Pages: 234
Authors: C.J. Date
Categories: Computers
Type: BOOK - Published: 2005-05-05 - Publisher: "O'Reilly Media, Inc."

DOWNLOAD EBOOK

This book sheds light on the principles behind the relational model, which is fundamental to all database-backed applications--and, consequently, most of the wo
Database Design and Relational Theory
Language: en
Pages: 277
Authors: C. J. Date
Categories: Computers
Type: BOOK - Published: 2012-04-17 - Publisher: "O'Reilly Media, Inc."

DOWNLOAD EBOOK

Because databases often stay in production for decades, careful design is critical to making the database serve the needs of your users over years, and to avoid