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
Database Design and Relational Theory: Normal Forms and All That Jazz
Create database designs that scale, meet business requirements, and inherently work toward keeping your data structured …