Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008 1st Edition

4.3 out of 5 stars 4 customer reviews
ISBN-13: 978-0321497642
ISBN-10: 0321497643
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy new
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
16 New from $26.99
A Developer's Guide to Da... has been added to your Cart
More Buying Choices
16 New from $26.99 21 Used from $0.30
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

The Amazon Book Review
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
$35.99 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Editorial Reviews


“Eric and Joshua do an excellent job explaining the importance of data modeling and how to do it correctly. Rather than relying only on academic concepts, they use real-world examples to illustrate the important concepts that many database and application developers tend to ignore. The writing style is conversational and accessible to both database design novices and seasoned pros alike. Readers who are responsible for designing, implementing, and managing databases will benefit greatly from Joshua’s and Eric’s expertise.”
Anil Desai, Consultant, Anil Desai, Inc.

“Almost every IT project involves data storage of some kind, and for most that means a relational database management system (RDBMS). This book is written for a database-centric audience (database modelers, architects, designers, developers, etc.). The authors do a great job of showing us how to take a project from its initial stages of requirements gathering all the way through to implementation. Along the way we learn how to handle some of the real-world design issues that typically surface as we go through the process.

“The bottom line here is simple. This is the book you want to have just finished reading when your boss says ‘We have a new project I would like your help with.’”
Ronald Landers, Technical Consultant, IT Professionals, Inc.

“The Data Model is the foundation of the application. I’m pleased to see additional books being written to address this critical phase. This book presents a balanced and pragmatic view with the right priorities to get your SQL server project off to a great start and a long life.”
Paul Nielsen, SQL Server MVP, SQLServerBible.com

“This is a truly excellent introduction to the database design methodology that will work for both novices and advanced designers. The authors do a good job at explaining the basics of relational database modeling and how they fit into modern business architecture. This book teaches us how to identify the business problems that have to be satisfied by a database and then proceeds to explain how to build a solid solution from scratch.”
Alexzander N. Nepomnjashiy, Microsoft SQL Server DBA, NeoSystems North-West, Inc.

From the Back Cover

""A Developer's Guide to Data Modeling for SQL Server" explains the concepts and practice of data modeling with a clarity that makes the technology accessible to anyone building databases and data-driven applications.
"Eric Johnson and Joshua Jones combine a deep understanding of the science of data modeling with the art that comes with years of experience. If you're new to data modeling, or find the need to brush up on its concepts, this book is for you."
-Peter Varhol, Executive Editor, "Redmond Magazine"

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 integrityProvide programmability via stored procedures, user-defined functions, triggers, and .NET CLR integrationNormalize data models, one step at a timeGather and interpret requirements more effectivelyLearn an effective methodology for creating logical modelsOvercome 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 constraintsUse SQL Server's unique indexing capabilities, and overcome their limitationsCreate abstraction layers that enhance security, extensibility, and flexibility


New York Times best sellers
Browse the New York Times best sellers in popular categories like Fiction, Nonfiction, Picture Books and more. See more

Product Details

  • Paperback: 304 pages
  • Publisher: Addison-Wesley Professional; 1 edition (July 4, 2008)
  • Language: English
  • ISBN-10: 0321497643
  • ISBN-13: 978-0321497642
  • Product Dimensions: 7 x 0.7 x 9.2 inches
  • Shipping Weight: 1.3 pounds (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Best Sellers Rank: #2,084,888 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

Format: Paperback
"A Developers Guide to Data Modeling for SQL Server" is billed to be for all level of data modelling development, however it is written in a style targeted to beginning novice developers only, and never progresses very far beyond demonstrating the fundamentals of Data Modeling. For novices, it is extremely good resource, explaining highly technical concepts in an easy to understand non-technical language. However, for the experienced developer, it would be best to look elsewhere.
Comment 8 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I am a medical doctor with a passion for software and a special interest in database technologies. I must say that I am not in the category of beginners in database design and modelling. I have about 6+ years of experience in this. I started reading the first page of this book with a lot of skepticism. In fact I had purchased the book along with 3 others from Amazon and I was not really sure of whether I would like reading it...it appeared very basic to me!
But that was only until I started reading Page 1.... believe me this is no exaggeration... I could not put the book down for an entire 8 hours afterwards! I went to bed at 4 AM after I had finished 3/4ths of this lovely work. This masterpiece of a book is truely the fruit of years of experience and immaculate teaching ability on the part of the authors. I can only say one thing.... anyone even remotely intending to get into database design, modelling and implementation with SQL Server.... should get this book and read it!! Believe me you will love it. It is simply too good to be true....
Comment 5 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Kindle Edition Verified Purchase
This review is a little early and maybe needs a little background.

I've been writing SQL style statements (first in Foxpro, then in MS Access and MySQL) for years. But I was kind of thrown into the pool without really having a firm understanding of what was going on. Plus I always used front-ends like Access and MySQL Workbench, so I'd like the tool write the beginning statement, then I'd tweak it. Some of my tweaks got pretty complex and at one point I was writing VBA in Access to write SQL on the fly as the user selected options on a User form. So on the one hand, I was pretty fluent in how SQL statements worked. On the other, I didn't know anything about SQL Server, like Triggers, Stored Procedures and so on. I also didn't have the best grasp on the data types (BLOB, tinyInt, smallInt, Date, Time, DateTime...)

I'm looking at converting a MASSIVE Excel/VBA project into a web-based app with an SQL back-end and thought I should get a better understanding of the tools involved.

I'm only on Chapter 3 but so far everything has been presented in a straight-forward, easy to follow manner. Most everything is backed by a real-world example so even if you don't get the theory at first (Why use a Many-to-Many relationship?!?!), they give you a real world example and the lightbulb comes on.

I may come back and tweak this if the rest of the book doesn't live up to the first part, but I'm sure it will be fine.

The only complaint I have is that a lot of the beginning of the book is like this "One of the great things about SQL is X which we'll get into next chapter. Y is also amazing and we'll talk about it in Chapter 9. Oh, and SQL wouldn't be SQL without Z which we'll talk about later in this chapter..." I know it's petty but there were a LOT of times where I was thinking "Stop talking about what you're going to talk about and just talk about something in the here and now!"
Comment One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
This book is a timely and helpful overview of the strategic importance of logical and physical data modeling. It also provides some useful insights into new modeling-related features in SQL Server 2008.

While some aspects of the book are likely to be somewhat controversial (e.g., the use of plural entity and table names [I prefer singular; the authors use plural], and the use of views for logical/physical data independence [I agree with the authors on the role and power of views, but some people prefer other abstraction mechanisms]), I believe the book should be required reading for anyone responsible for data modeling and database design aspects of working with SQL Server.
Comment 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Set up an Amazon Giveaway

A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008
Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway
This item: A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008