SQL and relational theory : how to write accurate SQL code / C.J. Date.

Format:

Book

Author/Creator:

Date, C. J., author.

Language:

English

Subjects (All):

SQL (Computer program language).

Relational databases.

Physical Description:

1 online resource (584 p.)

Edition:

3rd ed.

Other Title:

Structured Query Language and relational theory

Place of Publication:

Sebastopol, CA : O'Reilly, 2015.

System Details:

text file

Summary:

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.

Contents:

Front Cover; Back Cover; Title Page; Copyright Page; About the Author; Table of Contents; Preface to 1st Edition; Preface to 2nd Edition; Preface to 3rd 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 Alegebra I: The Original Operators; 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 ExpressionsChapter 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

Notes:

Includes bibliographical references and index.

Includes index.

Description based on online resource; title from PDF title page (ebrary, viewed January 20, 2016).

ISBN:

9781491941133

1491941138

9781491941164

1491941162

9781491941157

1491941154

OCLC:

930868444