Pro SQL server 2012 relational database design and implementation /

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

Full description

Saved in:
Bibliographic Details
Main Author: Davidson, Louis
Other Authors: Moss, Jessica
Format: Electronic eBook
Language:English
Published: [Berkeley, CA] : Apress, ©2012.
Series:Expert's voice in SQL server.
Subjects:
Online Access:CONNECT
Table of Contents:
  • The Fundamentals
  • Introduction to Requirements
  • The Language of Data Modeling
  • Initial Data Model Production
  • Normalization
  • Physical Model Implementation Case Study
  • Data Protection with Check Constraints and Triggers
  • Patterns and Anti-Patterns
  • Database Security and Security Patterns
  • Table Structures and Indexing
  • Coding for Concurrency
  • Reusable Standard Database Components
  • Considering Data Access Strategies
  • Reporting Design.