Book description
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 that theory into practice. In this book, Chris Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it to your use of SQL.
This third edition has been revised, extended, and improved throughout. Topics whose treatment has been expanded include data types and domains, table comparisons, image relations, aggregate operators and summarization, view updating, and subqueries. A special feature of this edition is a new appendix on NoSQL and relational theory.
Publisher resources
Table of contents
 Cover Page
 Title Page
 Copyright Page
 Dedication
 About the Author
 Contents
 Preface to the First Edition
 Preface to the Second Edition
 Preface to the Third Edition
 Chapter 1: Setting the Scene
 Chapter 2: Types and Domains
 Chapter 3: Tuples and Relations, Rows and Tables
 Chapter 4: No Duplicates, No Nulls
 Chapter 5: Base Relvars, Base Tables

Chapter 6: SQL and Relational Algebra I: The Original Operators
 Some preliminaries
 More on closure
 Restriction
 Projection
 Join
 Union, intersection, and difference
 Which operators are primitive?
 Formulating expressions one step at a time
 What do relational expressions mean?
 Evaluating SQL table expressions
 Expression transformation
 The reliance on attribute names
 Exercises
 Answers
 Chapter 7: SQL and Relational Algebra II: Additional Operators
 Chapter 8: SQL and Constraints
 Chapter 9: SQL and Views
 Chapter 10: SQL and Logic

Chapter 11: Using Logic to Formulate SQL Expressions
 Some transformation laws
 Example 1: Logical implication
 Example 2: Universal quantification
 Example 3: Implication and universal quantification
 Example 4: Correlated subqueries
 Example 5: Naming subexpressions
 Example 6: More on naming subexpressions
 Example 7: Dealing with ambiguity
 Example 8: Using COUNT
 Example 9: Another variation
 Example 10: UNIQUE quantification
 Example 11: ALL or ANY comparisons
 Example 12: GROUP BY and HAVING
 Exercises
 Answers
 Chapter 12: Miscellaneous SQL Topics
 Appendix A: The Relational Model
 Appendix B: SQL Departures from the Relational Model
 Appendix C: A Relational Approach to Missing Information
 Appendix D: A Tutorial D Grammar
 Appendix E: Summary of Recommendations
 Appendix F: NoSQL and Relational Theory
 Appendix G: Suggestions for Further Reading
 Index
 Footnotes
 Backcover
Product information
 Title: SQL and Relational Theory, 3rd Edition
 Author(s):
 Release date: November 2015
 Publisher(s): O'Reilly Media, Inc.
 ISBN: 9781491941171
You might also like
book
Database Design and Relational Theory
What makes this book different from others on database design? Many resources on design practice do …
video
C.J. Date's SQL and Relational Theory Master Class
Chris Date is the world's best known relational advocate. In this online seminar, he shows howto …
book
SQL in a Nutshell, 3rd Edition
For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the …
book
SQL in a Nutshell, 4th Edition
For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL …