Professional SQL Server 2000 Database Design (Programmer to Programmer) - Softcover

Davidson, Louis

Softcover

ISBN 10: 1861004761 ISBN 13: 9781861004765

Publisher: WROX Press Ltd, 2001

Synopsis

SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system.
Professional SQL Server 2000 Database Design provides an outline of the techniques that the designer can employ to make effective use of the full range of facilities that SQL Server 2000 offers. It attempts to move away from traditional texts on relational database design by considering design issues from a 'real world' point of view. To that end, it provides a full case study illustrating the scope of the designer's role - right from initial discussions regarding a client's needs, through development of a logical model, to full implementation of the system.

About this title

Synopsis

SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system. However, unless a database is designed correctly the powerful features of SQL Server 2000 are redundant. Database design is an essential skill that is often not adequately mastered by those who design databases as part of their jobs. This book presents the most widely used methodology (IDEF1X) in an easily accessible form and provides exhaustive information and examples on the process of designing and implementing a database application from the backend database programmer's standpoint. It takes the reader through the process of designing a database from conception to documentation. Subjects include: information and requirements gathering; modelling methodologies; normalization; reporting and de-normalization; writing the database documentation; implementing business rules; implementing the database in SQL Server 2000; and creating an operational data store.

About the Author

Louis Davidson 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.

Edition details

• Publisher: WROX Press Ltd
• Publication date: 2001
• Language: English
• ISBN 10: 1861004761
• ISBN 13: 9781861004765
• Binding: Paperback
• Edition number: 1
• Number of pages: 600