SQL and relational theory how to write accurate SQL code
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...
Otros Autores: | |
---|---|
Formato: | Libro electrónico |
Idioma: | Inglés |
Publicado: |
Sebastopol, CA :
O'Reilly
2015.
|
Edición: | 3rd ed |
Materias: | |
Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629979206719 |
Tabla de Contenidos:
- 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