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