Learn effective and scalable database design techniques in a SQL Server environment.
Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand all the way to the physical implementation of the design in a SQL Server database.
Pro SQL Server 2008 Relational Database Design and Implementation
Introduction to Database Concepts.- Data Modeling.- Conceptual Data Modeling.- The Normalization Process.- Implementing the Base Table Structures.- Advanced Design Patterns.- Protecting the Integrity of Your Data.- Securing Access to the Data.- Table Structures and Indexing.- Coding for Concurrency.-Code-Level Architectural Decisions.- Database Interoperability.- Codd's 12 Rules for an RDBMS.-Datatype Reference.