Description
Pro SQL Server Relational Database Design and Implementation (6th Ed., 6th ed.)
Best Practices for Scalability and Performance
Author: Davidson Louis
Language: EnglishSubject for Pro SQL Server Relational Database Design and Implementation:
1154 p. · 17.8x25.4 cm · Paperback
Description
/li>Contents
/li>Biography
/li>Comment
/li>
- Develop conceptual models of client data using interviews and client documentation
- Implement designs that work on premises, in the cloud, or in a hybrid approach
- Recognize and apply common database design patterns
- Normalize data models to enhance integrity and scalability of your databases for the long-term use of valuable data
- Translate conceptual models into high-performing SQL Server databases
- Secure and protect data integrity as part of meeting regulatory requirements
- Create effective indexing to speed query performance
- Understand the concepts of concurrency
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.