June 2008
Beginner to intermediate
304 pages
7h 5m
English
book
A Developer’s Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008
by Eric Johnson, Joshua Jones
Overview
“A Developer’s Guide to Data Modeling for SQL
Server explains the concepts and practice of data modeling
with a clarity that makes the technology accessible to anyone
building databases and data-driven applications.
“Eric Johnson and Joshua Jones combine a deep understanding
of the science of data modeling with the art that comes with years
of experience. If you’re new to data modeling, or find the
need to brush up on its concepts, this book is for
you.”
—Peter Varhol, Executive Editor, Redmond
Magazine
Model SQL Server Databases That Work Better, Do More, and Evolve
More Smoothly
Effective data modeling is essential to ensuring that your
databases will perform well, scale well, and evolve to meet
changing requirements. However, if you’re modeling databases
to run on Microsoft SQL Server 2008 or 2005, theoretical or
platform-agnostic data modeling knowledge isn’t enough:
models that don’t reflect SQL Server’s unique
real-world strengths and weaknesses often lead to disastrous
performance.
A Developer’s Guide to Data Modeling for SQL
Server is a practical, SQL Server-specific guide to data
modeling for every developer, architect, and administrator. This
book offers you invaluable start-to-finish guidance for designing
new databases, redesigning existing SQL Server data models, and
migrating databases from other platforms.
You’ll begin with a concise, practical overview of the core
data modeling techniques. Next, you’ll walk through
requirements gathering and discover how to convert requirements
into effective SQL Server logical models. Finally, you’ll
systematically transform those logical models into physical models
that make the most of SQL Server’s extended functionality.
All of this book’s many examples are available for download
from a companion Web site.
This book enables you to
Understand your data model’s physical elements, from storage to referential integrity
Provide programmability via stored procedures, user-defined functions, triggers, and .NET CLR integration
Normalize data models, one step at a time
Gather and interpret requirements more effectively
Learn an effective methodology for creating logical models
Overcome modeling problems related to entities, attribute, data types, storage overhead, performance, and relationships
Create physical models—from establishing naming guidelines through implementing business rules and constraints
Use SQL Server’s unique indexing capabilities, and overcome their limitations
Create abstraction layers that enhance security, extensibility, and flexibility
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.