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

Full description

Saved in:
Bibliographic Details
Main Author: Davidson, Louis (Author) 
Corporate Author: SpringerLink (online služba) (Distributor) 
Format: eBook
Language:English
Published: New York, NY : Apress, 2021
Genre/form:příručky
elektronické knihy
ISBN:978-1-4842-6497-3
978-1-4842-6496-6
9781484264966
Subjects:
SQL
Online Access:Plný text
Tags: Add Tag
No Tags, Be the first to tag this record!
Cover Image
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