Cargando…

Pro SQL Server Relational Database Design and Implementation

Learn effective and scalable database design techniques in a SQL Server 2016 and higher environment. This book is revised to cover in-memory online transaction processing, temporal data storage, row-level security, durability enhancements, and other design-related features that are new or changed in...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autores principales: Davidson, Louis (Autor), Moss, Jessica (Autor)
Autor Corporativo: SpringerLink (Online service)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Berkeley, CA : Apress : Imprint: Apress, 2016.
Edición:5th ed. 2016.
Temas:
Acceso en línea:Texto Completo
Tabla de Contenidos:
  • 1. The Fundamentals
  • 2. Introduction to Requirements
  • 3. The Language of Data Modeling
  • 4. Conceptual and Logical Data Model Production
  • 5. Normalization
  • 6. Physical Model Implementation Case Study
  • 7. Expanding Data Protection with Check Constraints and Triggers
  • 8. Patterns and Anti-Patterns
  • 9. Database Security and Security Patterns
  • 10. Index Structures and Application
  • 11. Matters of Concurrency
  • 12. Reusable Standard Database Components
  • 13. Architecting Your System
  • 14. Reporting Design
  • 15. Appendix: Scalar Datatype Reference.