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...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
Berkeley, CA
Apress
2021, 2021
|
| Edition: | 6th ed. 2021 |
| 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 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