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...
Saved in:
Main Author: | |
---|---|
Other Authors: | |
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.