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.

Pro SQL Server 2008 Relational Database Design and Implementation (Expert's Voice in SQL Server) 2008th Edition

3.7 out of 5 stars 10 customer reviews
ISBN-13: 978-1430208662
ISBN-10: 143020866X
Why is ISBN important?
ISBN
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 used On clicking this link, a new layer will be open
$9.74 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$41.10 On clicking this link, a new layer will be open
More Buying Choices
31 New from $15.00 31 Used from $0.41
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Windows10ForDummiesVideo
Windows 10 For Dummies Video Training
Get up to speed with Windows 10 with this video training course from For Dummies. Learn more.
$41.10 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Editorial Reviews

About the Author

Louis Davidson has been in the IT industry for more than 15 years as a corporate database developer and architect. He has spent the majority of his career working with Microsoft SQL Server, beginning from the early days of version 1.0. He has a bachelor s degree from the University of Tennessee at Chattanooga in computer science, with a minor in mathematics. Louis is the data architect for Compass Technology (Compass.net) in Chesapeake, Virginia, leading database development on their suite of nonprofit oriented CRM products, built on the Microsoft CRM platform and SQL Server technologies.
NO_CONTENT_IN_FEATURE

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

  • Series: Expert's Voice in SQL Server
  • Paperback: 680 pages
  • Publisher: Apress; 2008 edition (August 19, 2008)
  • Language: English
  • ISBN-10: 143020866X
  • ISBN-13: 978-1430208662
  • Product Dimensions: 7 x 1.5 x 9.2 inches
  • Shipping Weight: 2.2 pounds (View shipping rates and policies)
  • Average Customer Review: 3.7 out of 5 stars  See all reviews (10 customer reviews)
  • Amazon Best Sellers Rank: #2,109,095 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

By Denis Gobo on February 7, 2009
Format: Paperback
Good database design is extremely important if you want to have a database that performs well and is easily modifiable.
How many times did you have to go back and change countless lines of code because your database was not normalized and it was not easy to add another payment type to the existing database?

This is where Pro SQL Server 2008 Relational Database Design and Implementation comes in; in the first couple of chapters you are taught how to design a database in a normal form. Most books that deal with database design are dry and boring; you need to read a chapter several times to digest the information leaving you with a headache. Not this book, Pro SQL Server 2008 Relational Database Design and Implementation makes this almost fun, the author goes through the phases of database design in a fun way which is understandable to the common man

After the design is done and you have your database you will be shown how you can protect the integrity of your data. Remember nothing in the database is as important as to make sure the data is correct, if you have bad data then you might as well have no data at all. This book will show you how to protect the integrity of your data by using constraints and triggers

There is a whole chapter of some good tips and tricks, patterns and query techniques. I think that you will find out you can solve a whole lot of business problems with a numbers table much faster than if you had to do it without

Security is a big topic these days, look on the internet, ever week you here horror stories how some data was stolen or otherwise compromised.
Read more ›
Comment 10 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 purchased this book because I am teaching a college-level course that requires it. I have been in software development for 20 years, 10 of that as a data architect. Although literature is not always perfectly consistent, there is a pretty clear distinction between Conceptual, Logical, and Physical modeling on almost every web site.

In Chapter 1 Mr. Davidson does a good job summarizing the three, but he mysteriously adds a phase called "Implementation", which he attempts to use to mean the Physical Modeling, which is what EVERYONE else calls it. He then identifies a "Physical" phase as the tuning of an implemented model. Again, I cannot find ANY examples of this terminology being used this way. If he would have reversed these two names it would create much less confusion.

Meanwhile, he specifically identifies Conceptual Modeling "...consisting of a set of 'high-level' entities and the interactions between them" and Logical Modeling where "... you fully define the required set of entities, the relationships between them, the attributes of each entity, and the domains of these attributes...". This is consistent with the industry. Again, you identify detailed attributes at the Logical level.

But in Chapter 3, labeled "Conceptual Data Modeling", after going through a detailed example of requirements analysis, Mr. Davidson suddenly dives into attribute definition, all the way down to key structures! This is NOT Conceptual Modeling, and it conflicts with Chapter 1. The end of the chapter even has a section "Finishing the Conceptual Model." Chapter 4 discusses normalization, a step taken DURING Logical Modeling, but there is no mention of the progression from one phase to the next anywhere. By Chapter 5, the term Logical Model is suddenly used without warning.
Read more ›
1 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: Paperback
As I thought with the 2005 version of this book, I find Louis' book extremely well written, extremely informative, and down to earth. You get the impression that you're just discussing things with the author. Another thing that I love is that Louis' actually presents a point of view rather than spitting out what's already in books online, or just online itself. Not just facts, guidance. We need more writing like this, and more authors like Louis.
Comment 4 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
Pro SQL Server 2008

The title sounded very interesting to me & I was excited to learn a lot about SQL Server 2008. A large part of the book is about relational database design, which fair enough, hasn't really changed much and is mostly database independant. Hence the first part of the book has nothing much todo with SQL Server 2008.

For me, who's been working with database for a few years & I really wanted to improve my knowledge using this book. Whilst reading the book very carefully, what frustrated me the most, were the many many mistakes. Typos, content not making sense, incomplete updates from the previous edition, examples not working. Just so many mistakes on almost every page. If I received $10 for each mistake I found, I would make a small fortune.

A large part of the book is just full of references to other books to learn more about topics. There is truly very little SQL Server 2008 specific. Maybe nothing much changed or maybe the other was just too lazy to create new examples. Also, the sentences are often written in a way, which requires reading them 3 times before you understand what he means.

For such an expensive book & simple update from the last book --- very disappointing. Lots of room for improvement.
1 Comment 6 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

Most Recent Customer Reviews

Set up an Amazon Giveaway

Pro SQL Server 2008 Relational Database Design and Implementation (Expert's Voice in SQL Server)
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: Pro SQL Server 2008 Relational Database Design and Implementation (Expert's Voice in SQL Server)
Pages with Related Products. See and discover other items: relational database