Pro SQL Server 2005 Database Design and Optimization

✍ Scribed by Louis Davidson, Kevin Kline, Kurt Windisch

• Publisher: Apress
• Year: 2006
• Tongue: English
• Leaves: 672
• Category: Library

✦ Synopsis

Pro SQL Server 2005 Database Design and Optimization will teach you effective strategies for designing proper databases. It covers everything from how to gather business requirements to logical data modeling and normalization. It then shows you how to implement your design on SQL Server 2005.The authors also describe how to optimize and secure access to this data, covering indexing strategies, SQL design and optimization, and strategies for increased scalability to support large numbers of concurrent users. They provide in-depth advice on optimal code distribution in SQL Server 2005 applications, in the wake of innovations to be able to use .NET code in the database itself. This essential book will ensure that projects have a well-designed database and secure, optimized data access strategies right from the start.

✦ Table of Contents

Pro SQL Server 2005 Database Design and Optimization......Page 1
Contents......Page 8
CHAPTER 1 Introduction to Database Concepts.......Page 28
CHAPTER 2 Data Modeling......Page 60
CHAPTER 3 Conceptual Data Modeling......Page 98
CHAPTER 4 The Normalization Process......Page 148
CHAPTER 5 Implementing the Base Table Structures......Page 208
CHAPTER 6 Protecting the Integrity of Your Data......Page 300
CHAPTER 7 Securing Access to the Data......Page 362
CHAPTER 8 Table Structures and Indexing......Page 422
CHAPTER 9 Coding for Concurrency......Page 466
CHAPTER 10 Code-Level Architectural Decisions......Page 516
CHAPTER 11 Database Interoperability......Page 568
APPENDIX A Codd’s 12 Rules for an RDBMS......Page 600
APPENDIX B Datatype Reference......Page 608
INDEX......Page 640