Pro SQL Server 2000 Database Design and over 2 million other books are available for Amazon Kindle . Learn more

Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading Pro SQL Server 2000 Database Design on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Pro SQL Server 2000 Database Design: Building Quality Oltp Databases [Paperback]

Louis Davidson

RRP: 35.50
Price: 31.16 & FREE Delivery in the UK. Details
You Save: 4.34 (12%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Want it tomorrow, 11 July? Choose Express delivery at checkout. Details


Amazon Price New from Used from
Kindle Edition 29.60  
Paperback 31.16  

Book Description

1 Feb 2004 1590593022 978-1590593028
This book takes an in-depth, practical look at the process of designing and building efficient relational databases. It is a book of two halves. The first covers the logical design of databases, and the second looks at the physical design and implementation on SQL Server 2000. Whereas many texts on this topic are rather dry and theoretical, this books considers design issues from a "real world" point of view. It covers the process of implementing a database using Microsoft SQL Server 2000 from the point where someone mentions to you that they want a database, all the way through to generating tables and implementing access to these tables. It provides a full and realistic case study that clearly illustrates the full process, from initial discussions of a client's needs, through development of a logical model, to a full implementation of the system.

Product details

More About the Author

Discover books, learn about writers, and more.

Product Description

About the Author

Louis has been in the information technology industry for ten years, as a corporate database developer and architect. Currently, he is serving as a Database Administrator for Compass Technology Management in their Nashville Data Center supporting the Christian Broadcasting Network and NorthStar Studios in Nashville, TN. The majority of his experience, with slight deviations into Visual Basic, has been spent with Microsoft SQL Server from version 1.0 to whatever latest version that is in Beta. Louis' primary areas of expertise are in database architecture and coding in Transact-SQL, and he has written thousands of stored procedures and triggers throughout the years. Louis was a contributing author to "SQL Server 2000 Stored Procedure Handbook"

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on (beta) 4.7 out of 5 stars  3 reviews
4 of 4 people found the following review helpful
4.0 out of 5 stars Design AND implementation 12 Jun 2004
By W Boudville - Published on
How much do you already know about designing and implementing a SQL database? That is really two questions.
The first refers to applying a well trodden theory of SQL design to your application. What tables should you conceptually extract? How should these be interrelated by judicious choice of primary and foreign keys? What are the germane attributes in each table? All these issues are explained by Davidson in the first part of the book. He goes well into discussing how to normalise data, and the numerous normal forms. He does this at a level independent of SQL Server. So even if your database is dB2 or Oracle or whatever, you should be able to profitably gain something from his teachings.
But having designed your database, now comes having to implement it. The second part of the book. Here is the SQL Server specific material. The details specific to its implementation do matter. But you know what? A fair amount of the examples use mostly standard SQL commands. In your application, you should probably strive to do likewise, to the maximum extent possible. It minimises the amount of inevitable lockin to SQL Server.
There are also sections in the second part that apply to any relational database. Like his description of best practices, in chapter 13.
Davidson presents a useful balance between design and implementation. A favourable contrast to texts that predominently deal with only one aspect.
2 of 2 people found the following review helpful
5.0 out of 5 stars Real-world approach to database design 27 May 2005
By James A. Luetkehoelter - Published on
This isn't your typical technical book. While Mr. Davidson does go into the technical aspects of logical and physical design, he does so in a way that the focus is not "how-to", but "how-should". It reads as if you're listen to a seasoned professional share his experience.

The book covers the entire database design process, from practical matters like discovering and refining business requirements to the actual implementation. Much of the information covered actually applies to any relational database platform. I've been doing this type of work for the last 10 years, and this book has a permament place on my bookshelf.
1 of 1 people found the following review helpful
5.0 out of 5 stars DB Design for the business world 16 Dec 2005
By Stephen Collins - Published on
I've read several books on SQL Server and database design, but this one, i think, give the best view on both.

The first half of the book is solely focused on the design, and business-oriented side of your database - the first three chapters are littered with "Consult your client, Consult your client, Consult your client," which keeps you in the mindset that your whole endeavor is focused on keeping the customer happy, which makes the whole process seem much more human than most of the other more technical books.

the second half covers every detail of how you would physically implement your solution, from how to build the tables, to what kind of hardware you would need, and even covers which version of Windows Server and SQL Server you would need for each job.

Overall, I simply love this whole book. And if you really want to complete your knowledge of SQL Server as a whole, couple this with Microsoft SQL Server 2000 Unleashed (2nd Edition) by Sams, and you'll soon become a SQL monster.
Were these reviews helpful?   Let us know

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category