Pro SQL Server Relational Database Design and Implementation

• Main Authors: Davidson, Louis (Author), Moss, Jessica (Author)
• Corporate Author: SpringerLink (Online service)
• Format: Electronic eBook
• Language: English
• Published: Berkeley, CA : Apress : Imprint: Apress, 2016.
• Edition: Fifth Edition.
• Subjects: Computer science.; Database management.; Computer Science.; Database Management.

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...

Table of Contents:

• 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.