Sunday, January 9, 2011

Professional SQL Server 2000 Database Design





About the Author Louis is an avowed database nut. Currently he is toiling as the database architect for Education Networks of America in Nashville, Tennessee, not to mention writing this book and hopefully one more.

He has been designing and implementing Microsoft SQL Server databases for around nine years, since his brilliant failure as a LAN Administrator for the Church of God International Headquarters in Cleveland, Tennessee (yes, there is a Cleveland in Tennessee). As SQL Server came packaged with Visual Basic 1.0 back then, he has also been developing with that product for around nine years, although his VB skills have been progressively getting worse since version 4.0, as he has been focusing primarily on SQL Server.

Louis has spoken at several conferences, such as CA-World in 1999 and 2000, concerning implementing solutions with ERwin; and at PASS 2000 Europe, he gave two presentations, one on normalization and the other on query optimization.

At home there is a wife Valerie and a daughter Chrissy, whom he dreams of one day spending a free moment with, since he hasn’t had any since the day that SQL Server and Visual Basic landed on his desk nine years ago…

Summary of Contents
Introduction 7
Part I: Logical Design 13
Chapter 1: Introduction to Database Methodologies 17
Chapter 2: Gathering Information for a Database Project 31
Chapter 3: Fundamental Database Concepts 47
Chapter 4: Entities, Attributes, Relationships, and Business Rules 75
Chapter 5: Data Modeling 109
Chapter 6: Normalization Techniques 151
Chapter 7: Advanced Normalization Topics 181
Chapter 8: Ending the Logical Design Phase 203
Part II – Physical Design and Implementation 227
Chapter 9: Planning the Physical Architecture 231
Chapter 10: Planning and Implementing the Basic Physical Architecture 255
Chapter 11: Ensuring Data Integrity 341
Chapter 12: Advanced Data Access and Modification Techniques 411
Chapter 13: Determining Hardware Requirements 509
Chapter 14: Completing the Project 553
Appendix A: Codd’s 12 Rules for an RDBMS 583
A Guide to the Index 595


Another Database Books
Another Web Programming Books
Download

No comments:

Post a Comment

Related Posts with Thumbnails

Put Your Ads Here!