MCSE: SQL Server 2000 Design Study Guide

Here's the book you need to prepare for Exam 70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition:

• In-depth coverage of every exam objective--all the information you need to know
• Practical information on designing and implementing a SQL Server 2000 database
• Hundreds of challenging review questions, in the book and on the CD
• Leading-edge exam preparation software, including a testing engine and electronic flashcards

• Developing a logical data model
• Implementing the physical database
• Retrieving and modifying data
• Programming business logic
• Tuning and optimizing data access
• Designing a database security plan

CONTENTS

Introduction

Chapter 1: Database Logical Modeling

Chapter 2: Database Physical Modeling

Chapter 3: Creating and Maintaining Tables

Chapter 4: Implementing Data Integrity

Chapter 5: Creating and Maintaining Indexes

Chapter 6: Creating and Maintaining Database Objects

Chapter 7: Accessing Data

Chapter 8: Modifying Data

Chapter 9: Importing and Exporting Data

Chapter 10: Locking

Chapter 11: Developing a Security Plan

Chapter 12: Analyzing and Optimizing Data Access

Index