:clover: A Developer's Guide to Data Modeling for SQL Server: Covering SQL 2005 and 2008 [h33t] {purestevil}™release
:?: Publication Info:
Author(s) : Eric Johnson, Joshua Jones
Publisher : Addison-Wesley Professional
Date : 2008
Pages : 299
Format : PDF
ISBN-10 : 0321497643
:?: Book Info:
This book enables you to:
- Understand your data model's physical elements, from storage to referential integrity
- Provide programmability via stored procedures, user-defined functions, triggers, and .NET CLR integration
- Normalize data models, one step at a time
- Gather and interpret requirements more effectively
- Learn an effective methodology for creating logical models
- Overcome modeling problems related to entities, attribute, data types, storage overhead, performance, and relationships
- Create physical models from establishing naming guidelines through implementing business rules and constraints
- Use SQL Server's unique indexing capabilities, and overcome their limitations
- Create abstraction layers that enhance security, extensibility, and flexibility
|