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
40 Algorithms Every Programmer Should Know
Learn algorithms for solving classic computer science problems with this concise guide covering everything from fundamental …
book
Designing Data-Intensive Applications
Data is at the center of many challenges in system design today. Difficult issues need to …
book
Data Science from Scratch, 2nd Edition
To really learn data science, you should not only master the tools—data science libraries, frameworks, modules, …
book
Relational Database Design and Implementation, 4th Edition
Relational Database Design and Implementation: Clearly Explained, Fourth Edition, provides the conceptual and practical information necessary …