Pro SQL Server 2012 Relational Database Design and Implementation

✍ Scribed by Louis Davidson, Jessica M. Moss (auth.)

• Publisher: Apress
• Year: 2012
• Tongue: English
• Leaves: 765
• Edition: 1
• Category: Library

✦ Synopsis

Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2012 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, Louis Davidson shows how to “get it right” in SQL Server database design and lay a solid groundwork for the future use of valuable business data.

• Gives a solid foundation in best practices and relational theory
• Covers the latest implementation features in SQL Server
• Takes you from conceptual design to an effective, physical implementation

✦ Table of Contents

Front Matter....Pages i-xxxi
The Fundamentals....Pages 1-36
Introduction to Requirements....Pages 37-51
The Language of Data Modeling....Pages 53-90
Initial Data Model Production....Pages 91-128
Normalization....Pages 129-167
Physical Model Implementation Case Study....Pages 169-243
Data Protection with Check Constraints and Triggers....Pages 245-299
Patterns and Anti-Patterns....Pages 301-369
Database Security and Security Patterns....Pages 371-443
Table Structures and Indexing....Pages 445-503
Coding for Concurrency....Pages 505-561
Reusable Standard Database Components....Pages 563-593
Considering Data Access Strategies....Pages 595-638
Reporting Design....Pages 639-670
Back Matter....Pages 671-751

✦ Subjects

Computer Science, general; Database Management