: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
|