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...
Main Authors: | , |
---|---|
Format: | eBook |
Language: | English |
Published: |
Berkeley, CA
Apress
2016, 2016
|
Edition: | 5th ed. 2016 |
Subjects: | |
Online Access: | |
Collection: | Springer eBooks 2005- - Collection details see MPG.ReNa |
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