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 the theory into practice. In this insightful book, author C.J. Date explains relational theory in depth, and demonstrates through numerous examples and exerc...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, CA :
O'Reilly
2011.
|
| Edición: | 2nd ed |
| Colección: | Theory in practice (Sebastopol, Calif.)
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628224106719 |
Tabla de Contenidos:
- Table of Contents; Preface to the First Edition; Preface to the Second 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; 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; Chapter 12: Miscellaneous SQL Topics
- Appendix A: The Relational ModelAppendix 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: Answers to Exercises; Appendix G: Suggestions for Further Reading; Index
