MCSE/MCSD: SQL Server 7 Database Design Study Guide

Overview

Here's the book you need to prepare for Exam 70-029, Designing and Implementing Databases with Microsoft SQL Server 7.0.
This Microsoft Certified Professional Approved Study Guideprovides:

• Full coverage of every exam objective-all the information you need to know
  
• Lots of challenging review questions, in the book and on the CD
  
• Practical information on designing and implementing a SQL Server database in the real world
  Authoritative coverage of critical exam topics, including:
  
• Developing a logical data model
• Applying normalization rules
• Incorporating business rules into the data model
• Deriving the physical design
• Creating data services
• Accessing data using the dynamic SQL model
• Accessing data using the stored procedure model
• Creating a physical database
• Creating and managing files, file groups, and transaction logs
• Populating the database with data from an external source
• Maintaining a database
• Evaluating and optimizing query execution plan performance
• Diagnosing and resolve locking problems
• Identifying SQL Server events and performance problems

Read More