 |
Pro SQL Server 2008 Relational Database Design and Implementation
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.
|
|
