- 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
SQL and Relational Theory
How to Write Accurate SQL Code
THIRD EDITION
C. J. Date
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.