Pro SQL Server relational database design and implementation : best practices for scalability and performance /

Learn effective and scalable database design techniques in SQL Server 2019 and other recent SQL Server versions. This book is revised to cover additions to SQL Server that include SQL graph enhancements, in-memory online transaction processing, temporal data storage, row-level security, and other de...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Davidson, Louis
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [Place of publication not identified] : Apress, 2021.
Edición:6th ed.
Temas:
SQL server.
SQL server
Client/server computing.
Relational databases.
Database management.
Architecture client-serveur (Informatique)
Bases de données relationnelles.
Bases de données > Gestion.
Relational databases
Client/server computing
Database management
Microsoft software
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
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 Case Study
  • 7. Physical Model Implementation
  • 8. Data Protection Patterns with Check Constraints and Triggers
  • 9. Patterns and Anti-Patterns
  • 10. Database Security and Security Patterns
  • 11. Data Structures, Indexes, and Their Applications
  • 12. Matters of Concurrency
  • 13. Coding Architecture
  • 14. Appendix A: Scalar Datatype Reference.

Ejemplares similares