Pro SQL Server 2000 Database Design

Building Quality OLTP Databases

Louis Davidson - Collection The Expert's Voice

568 pages, parution le 13/02/2004

Ajouter à une liste

Indisponible

Résumé

Pro SQL Server 2000 Database Design 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 conception of the database and its design considerations 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.

L'auteur - Louis Davidson

Louis Davidson - Louis has been in the IT industry for ten years, as a corporate database developer and architect. He is currently a database administrator for Compass Technology Management, supporting the Christian Broadcasting Network and NorthStar Studios in Nashville, TN. Davidson has a bachelor's degree from the University of Tennessee at Chattanooga in computer science with a minor in mathematics The majority of his experience has been spent with Microsoft SQL Server from version 1.0 to the latest version that is in Beta. His areas of expertise are database architecture and coding in T-SQL, and he has written thousands of stored procedures and triggers through the years.

Sommaire

Introduction to Database Concepts
Gathering Information for a Database Project
Fundamental Database Concepts
Entities, Attributes, Relationships, and Business Rules
Data Modeling
Normalization Techniques
Advanced Normalization Topics
Ending die Logical Design Phase
Planning die Physical Architecture
Building the Basic Table Structures
Declarative Data Protection
Programmatic Data Protection
Advanced Data Access and Modification
Determining Hardware Requirements
Completing die Project

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Apress
Auteur(s)	Louis Davidson
Collection	The Expert's Voice
Parution	13/02/2004
Nb. de pages	568
Format	17,5 x 23,5
Couverture	Broché
Poids	940g
Intérieur	Noir et Blanc
EAN13	9781590593028
ISBN13	978-1-59059-302-8