Pro SQL Server Relational Database Design and Implementation

• Κύριοι συγγραφείς: Davidson, Louis (Συγγραφέας), Moss, Jessica (Συγγραφέας)
• Συγγραφή απο Οργανισμό/Αρχή: SpringerLink (Online service)
• Μορφή: Ηλεκτρονική πηγή Ηλ. βιβλίο
• Γλώσσα: English
• Έκδοση: Berkeley, CA : Apress : Imprint: Apress, 2016.
• Έκδοση: Fifth Edition.
• Θέματα: 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...

Πίνακας περιεχομένων:

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