A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008 Adobe PDF 0321574206 9780321574206

		Index \| Next Record \| Browse



For Current Pricing Click Here

Static eBook Details Page - Go to the eReadable Website

A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008
ISBN: 0321574206
ISBN13: 9780321574206

A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008
By: Joshua Jones ; Eric Johnson
Publisher: Addison Wesley Professional
Subject: Data Modeling & Design
Format(s): Adobe PDF

Our Price: $ 29.87

Table of contents:

This is the eBook version of the printed book. If the print book includes a CD-ROM, this content is not included within the eBook version.

Model SQL Server Databases That Work Better, Do More, and Evolve More Smoothly

Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you’re modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn’t enough: models that don’t reflect SQL Server’s unique real-world strengths and weaknesses often lead to disastrous performance.

A Developer’s Guide to Data Modeling for SQL Server is a practical, SQL Server-specific guide to data modeling for every developer, architect, and administrator. This book offers you invaluable start-to-finish guidance for designing new databases, redesigning existing SQL Server data models, and migrating databases from other platforms.

You’ll begin with a concise, practical overview of the core data modeling techniques. Next, you’ll walk through requirements gathering and discover how to convert requirements into effective SQL Server logical models. Finally, you’ll systematically transform those logical models into physical models that make the most of SQL Server’s extended functionality. All of this book’s many examples are available for download from a companion Web site.

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

Static Book Details Index Page - Click Here to go to the eReadable Website

Copyright © 2007 - 2008 Computer Manuals ltd. All rights reserved. No part of the content of this web-site may be reproduced in any form without the prior written consent of eReadable.com or Computer Manuals ltd. For legal information regarding this site please read our disclaimer.

Please send any comments or queries regarding our products to info@ereadable.com.
All jacket designs are for illustration only and may change. All prices and details are subject to change without notice. All prices include VAT where applicable. E & O. E.

A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008 ISBN: 0321574206ISBN13: 9780321574206

A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008
ISBN: 0321574206
ISBN13: 9780321574206