Louis Davidson

Pro SQL Server 2000 Database Design

Building Quality Oltp Databases

• Broschiertes Buch

Produktbeschreibung

This book 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 point where someone mentions to you that they want a database, 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.

---

Obtain a deep understanding of database design and modeling concepts.

Implement a complete case study, from initial requirements gathering, right up to the point where it is up and running on SQL Server 2000.

Design and build relational databases that will be more efficient and productive for your organization.

Produktdetails

• Verlag: Apress
• Artikelnr. des Verlages: 978-1-59059-302-8
• Softcover reprint of the original 1st ed.
• Seitenzahl: 592
• Erscheinungstermin: 22. Januar 2004
• Englisch
• Abmessung: 237mm x 177mm x 34mm
• Gewicht: 928g
• ISBN-13: 9781590593028
• ISBN-10: 1590593022
• Artikelnr.: 12350730

Autorenporträt

Louis Davidson has been in the IT industry for more than 15 years as a corporate database developer and architect. He has spent the majority of his career working with Microsoft SQL Server, beginning from the early days of version 1.0. He has a bachelor s degree from the University of Tennessee at Chattanooga in computer science, with a minor in mathematics. Louis is the data architect for Compass Technology (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.

Inhaltsangabe

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