MCSE SQL SERVER 2000 ADMINISTRATION FOR DUMMIES

MCSE SQL Serve 2000 Administration For Dummies brings you concise coverage of the Microsoft exam objectives. This book is a valuable resource for experienced users who are seeking a quick review of the exam material. And, for the less-experienced user, this book will provide accessible information as well as extensive self-assessment and practice question opportunities in both written and electronic format. The real-world experience of the authors enables them to present information that underlies the key concepts and ideas of the exam objectives. You can rely on this friendly ...For Dummies guide to prepare you for the SQL Server 2000 Administration exam (70-228).

Covers: Exam 070-228

Rozanne Whalen and Dan Whalen, both MCSE, MCDBA, and MCT, teach MCSE and MCDBA exam-preparation courses. Rozanne also writes instructor training manuals and is the editor of the Inside Microsoft Windows 2000 journal.

Introduction.

PART I: Getting Started.

Chapter 1: The Microsoft SQL Server 2000 System Administration Exam.

Chapter 2: Exam Prep Roadmap: A SQL Server 2000 Primer.

PART II: Installing and Configuring SQL Server 2000.

Chapter 3: Planning to Implement SQL Server 2000.

Chapter 4: Installing SQL Server 2000.

Chapter 5: Upgrading to SQL Server 2000.

Chapter 6: Troubleshooting Installation Problems.

Chapter 7: Configuring SQL Server to Send E-Mail.

PART III: Creating SQL Server Databases.

Chapter 8: Designing Databases.

Chapter 9: Creating Databases.

Chapter 10: Managing Databases.

Chapter 11: Creating and Managing Database Objects.

PART IV: Managing, Monitoring, and Troubleshooting Databases.

Chapter 12: Managing and Optimizing Database Performance.

Chapter 13: Optimizing Data Storage.

Chapter 14: Backing Up Databases.

Chapter 15: Restoring Databases.

Chapter 16: Using Database Monitoring and Troubleshooting Tools.

PART V: Transferring Data.

Chapter 17: Integrating SQL Server with Internet Information Services.

Chapter 18: Importing and Exporting Data.

Chapter 19: Installing, Configuring, and Troubleshooting Replication.

PART VI: Securing SQL Server.

Chapter 20: Configuring Login Security.

Chapter 21: Implementing Permissions.

Chapter 22: Auditing SQL Server.

PART VII: Managing, Monitoring, and Troubleshooting SQL Server 2000.

Chapter 23: Automating Administrative Tasks and Alerts.

Chapter 24: Optimizing Hardware Resources.

Chapter 25: Monitoring and Troubleshooting SQL Server.

PART VIII: The Part of Tens.

Chapter 26: Ten Terrific Exam Day Tips.

Chapter 27: Ten MCSE Certification Resources.

PART IX: Appendix.

Appendix: About the CD.

Index.

Hungry Minds, Inc. End-User License Agreement.

Installation Instructions.

Book Registration Information.