| help | account  


Pro SQL Server 2008 Relational Database Design and Implementation
View Larger Image
Louis Davidson, Kevin Kline, Kurt Windisch, Scott Klein
Apress, Paperback, Published August 2008, 680 pages, ISBN 143020866X
List Price: $59.99
Our Price: $36.50
You Save: $23.49 (39% Off)


FREE Shipping on Orders over $40!*
Availability: In-Stock
Read an excerpt:
Chapter 1: Introduction to Database Concepts



     

Excerpt provided courtesy of Apress. Copyright © Apress, Inc. Written permission from the publisher is required for any use of this material.

Be the First to Write a Review and tell the world about this title!

People who purchase this book frequently purchase:

Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:

Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand all the way to the physical implementation of the design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, authors Louis Davidson, Kevin Kline, Scott Klein, and Kurt Windisch show how to “get it right” in SQL Server database design and lay a solid groundwork for the future use of valuable business data.

• Solid foundation in best practices and relational theory
• Maximize SQL Server features to enhance security, performance, scalability
• Thorough treatment from conceptual design to an effective, physical implementation


What you’ll learn

• Develop conceptual models of client data using interviews and client documentation.
• Normalize data models to enhance scalability and the long term use of valuable data.
• Translate conceptual models into high–performing SQL Server databases.
• Secure and protect the integrity of data as part of meeting regulatory requirements.
• Take full advantage of new SQL Server features such as the spatial datatype, XML support, transparent data encryption, and more.
• Create effective indexing to speed query performance.


Who is this book for?

Pro SQL Server 2008 Relational Database Design and Implementation is designed for programmers of all types who want to use SQL Server 2008 to store data. Rookie database programmers will find a complete course on the fundamentals of database design that includes conceptual designs and physical implementation. Seasoned veterans will find many tips and tricks for implementing database systems that will be well worth the time invested in reading this book.

 

About the Apress Pro Series

The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder.

You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard–won solutions to problems you will face in your professional programming career.

 

About the Authors

Louis Davidson has been in the IT industry for over 15 years as a corporate database developer and architect, spend the majority of his career with Microsoft SQL Server from the early days of 1.0 to whatever is the latest version currently in beta. He has a bachelor’s degree from the University of Tennessee at Chattanooga in computer science with a minor in mathematics.

Currently Louis is the data architect for Compass Technology (www.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.

Kevin Kline is the technical strategy manager for SQL Server solutions at Quest Software, a leading provider of award-winning tools for database management and application monitoring on the SQL Server platform. Kevin is the president of the international Professional Association for SQL Server (PASS). He has been a Microsoft SQL Server MVP since 2004. Kevin is the lead author of SQL in a Nutshell: A Desktop Quick Reference (O’Reilly Media Inc., 2004) and Transact-SQL Programming (O’Reilly Media, Inc., 1999). Kevin writes the monthly SQL Server Drilldown column for Database Trends & Applications, blogs at http://www.sqlmag.com, and is a resident expert at SearchSQLServer.com. Kevin is a top-rated speaker, appearing at international conferences such as Microsoft TechEd, DevTeach, PASS, Microsoft IT Forum, and SQL Connections. When he’s not pulling his hair out over work, he loves to spend time with his four kids and in his flower and vegetable gardens.

Scott Klein is an independent consultant with a passion for all things SQL Server, .NET, and XML. He is the author of several books, including Professional SQL Server 2005 XML (Wrox, 2006) and Professional LINQ (Wrox, 2008), and he writes the biweekly feature article for the SQL PASS Community Connector. He has also contributed articles for several web sites, including Wrox (http://www.wrox.com) and TopXML (http://www.topxml.com). He frequently speaks to SQL Server and .NET user groups around Florida. Scott lives in Wellington, Florida, and when he is not sitting in front of a computer, he can be found hanging out with his family or aboard his Yamaha at the local motocross track. He can be reached at ScottKlein@SqlXml.com.

Kurt Windisch is a senior technical specialist with Levi, Ray & Shoup, Inc., a global provider of technology solutions with headquarters in Springfield, Illinois. He has more than 15 years of experience in IT, and is a DBA and technical architect for the internal IT department at LRS. He spent 5 years serving on the board of directors for PASS, has written for several SQL Server magazines, and has presented at conferences internationally on the topic of database programming with SQL Server.




Forgot your password?
FAQs
Shipping Options
Returns
Your Orders
Your Account