This is Real Life Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Original Essays | February 15, 2015

    Jennifer Jacquet: IMG Is Shame Necessary?



    Is Shame Necessary? is my first book, so I am far from having earned the right to discuss writing a book in general. But I can say something about... Continue »

    spacer
Qualifying orders ship free.
$59.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Remote Warehouse Database- Design

Pro SQL Server 2005 Database Design and Optimization (Pro)

by

Pro SQL Server 2005 Database Design and Optimization (Pro) Cover

 

Synopses & Reviews

Publisher Comments:

This book teaches the SQL Server database professional effective strategies for designing proper databases, covering everything from how to gather business requirements, to logical data modeling, and normalization. It then shows you how to implement your design on SQL Server 2005. However, this new fully-revised edition does not stop there. Having established an understanding of the process of designing and implementing SQL Server 2005 databases, it then provides completely new material describing how to optimize and secure access to this data, covering indexing strategies, SQL design and optimization as well as strategies for increased scalability to support large numbers of concurrent users. It also provides in-depth advice on optimal code distribution in SQL Server 2005 applications, in light of innovations such as the ability to use .NET code in the database itself (see SQL Server 2005 Assemblies Revealed, Apress,

Synopsis:

Pro SQL Server 2005 Database Design and Optimization will teach you effective strategies for designing proper databases. It covers everything from how to gather business requirements to logical data modeling and normalization. It then shows you how to implement your design on SQL Server 2005.

The authors also describe how to optimize and secure access to this data, covering indexing strategies, SQL design and optimization, and strategies for increased scalability to support large numbers of concurrent users. They provide in-depth advice on optimal code distribution in SQL Server 2005 applications, in the wake of innovations to be able to use .NET code in the database itself. This essential book will ensure that projects have a well-designed database and secure, optimized data access strategies right from the start.

Synopsis:

Covering everything from how to gather business requirements to logical data modeling and normalization, this reference shows how to implement design on SQL Server 2005. The authors then provide in-depth advice on optimal code distribution in SQL Server 2005 applications, in the wake of innovations to be able to use .NET code in the database itself.

Table of Contents

Relational Database Introduction.- Discovery of Objects to be modeled.- Data Modeling.- Basic Normalization.- Advanced Normalization.- Implementing Physical Tables.- Maintaining Data Integrity.- Securing access to the data.- Index design strategies.- Designing Optimal SQL.- Implementing for Concurrency.- Architecture Considerations (Kurt Windisch).- Cross Platform Deployment (Kevin Kline).- Codd's Laws.- Intrinsic Datatype reference.- Case Study.

Product Details

ISBN:
9781590595299
Author:
Davidson, Louis
Publisher:
Apress
With:
Kline, Kevin
With:
Windisch, Kurt
Author:
Windisch, Kurt
Subject:
Database Management - SQL Server
Subject:
Database-SQL
Subject:
Database design
Series:
Pro
Publication Date:
20060531
Binding:
TRADE PAPER
Language:
English
Illustrations:
Y
Pages:
644
Dimensions:
9.31x7.51x1.45 in. 2.55 lbs.

Other books you might like

  1. Beginning SQL Server Express... New Trade Paper $39.99

Related Subjects

Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Networking » General
Computers and Internet » Software Engineering » Software Management

Pro SQL Server 2005 Database Design and Optimization (Pro) New Trade Paper
0 stars - 0 reviews
$59.99 In Stock
Product details 644 pages Apress - English 9781590595299 Reviews:
"Synopsis" by , Pro SQL Server 2005 Database Design and Optimization will teach you effective strategies for designing proper databases. It covers everything from how to gather business requirements to logical data modeling and normalization. It then shows you how to implement your design on SQL Server 2005.

The authors also describe how to optimize and secure access to this data, covering indexing strategies, SQL design and optimization, and strategies for increased scalability to support large numbers of concurrent users. They provide in-depth advice on optimal code distribution in SQL Server 2005 applications, in the wake of innovations to be able to use .NET code in the database itself. This essential book will ensure that projects have a well-designed database and secure, optimized data access strategies right from the start.

"Synopsis" by , Covering everything from how to gather business requirements to logical data modeling and normalization, this reference shows how to implement design on SQL Server 2005. The authors then provide in-depth advice on optimal code distribution in SQL Server 2005 applications, in the wake of innovations to be able to use .NET code in the database itself.
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.