A Developer's Guide to Data Modeling for SQL Server and over one million other books are available for Amazon Kindle. Learn more
  • List Price: $49.99
  • Save: $32.33 (65%)
Rented from RentU
To Rent, select Shipping State from options above
Due Date: Dec 20, 2014
FREE return shipping at the end of the semester. Access codes and supplements are not guaranteed with rentals.
FREE Shipping on orders over $35.
Used: Good | Details
Sold by RentU
Condition: Used: Good
Comment: Fast shipping from Amazon! Qualifies for Prime Shipping and FREE standard shipping for orders over $35. Overnight, 2 day and International shipping available! Excellent Customer Service.. May not include supplements such as CD, access code or DVD.
Access codes and supplements are not guaranteed with used items.
  • List Price: $49.99
  • Save: $7.45 (15%)
Only 2 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
Trade in your item
Get a $2.00
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008 Paperback – July 4, 2008

ISBN-13: 978-0321497642 ISBN-10: 0321497643 Edition: 1st

Buy New
Price: $42.54
Price: $17.66
18 New from $27.00 27 Used from $1.92
Amazon Price New from Used from
"Please retry"
"Please retry"
$27.00 $1.92

Frequently Bought Together

A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008 + Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference)
Price for both: $72.91

Buy the selected items together

Customers Who Bought This Item Also Bought


Save up to 90% on Textbooks
Rent textbooks, buy textbooks, or get up to 80% back when you sell us your books. Shop Now

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: 9.1 x 7.1 x 0.8 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: #1,695,156 in Books (See Top 100 in Books)

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.

About the Author

Eric Johnson (Microsoft SQL MVP)is the co-founder of Consortio Services and the primary database technologies consultant. His background in information technology is diverse, ranging from operating systems and hardware to specialized applications and development. He has even done his fair share of work on networks. Because IT is a way to support business processes, Eric has also acquired an MBA. All in all, he has ten years of experience with IT, much of it working with Microsoft SQL Server. Eric has managed and designed databases of all shapes and sizes. He has delivered numerous SQL Server training classes and Webcasts as well as presentations at national technology conferences. Most recently, he presented at TechMentor on SQL Server 2005 replication, reporting services, and integration services. In addition, he is active in the local SQL Server community, serving as the president of the Colorado Springs SQL Server Users Group. He is also the co-host of CS Techcast, a weekly podcast for IT professionals at www.cstechcast.com. You can find Eric’s blog at www.consortioservices.com/blog.

Joshua Jones
(MCTS, SQL Server 2005; MCITP, Database Administrator) is operating systems and database systems consultant with Consortio Services in Colorado Springs. There he provides training, administration, analysis, and design support for customers using SQL Server 2000 and 2005. In his seven years as an IT professional, he has worked in many areas of information technology, including Windows desktop support, Windows 2000 and 2003 server infrastructure design and support (AD, DNS, MS Exchange), telephony switch support, and network support. Josh has spoken at various PASS sponsored events about SQL Server topics such as 64-bit SQL Server implementation, reporting services administration, and performance tuning. He is also a co-host of CS Techcast, a weekly podcast for IT professionals at www.cstechcast.com.

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.2 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

7 of 7 people found the following review helpful By Ronald B. Kunce on August 18, 2008
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 5 people found the following review helpful By Software Doctor on August 18, 2008
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Charles on September 9, 2012
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 4 people found the following review helpful By Peter O'KELLY on July 7, 2008
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

What Other Items Do Customers Buy After Viewing This Item?