MCSA/MCSE/MCDBA: SQL Server^TM 2000 Administration Study Guide: Exam 70-228, Updated, 2nd Edition

by Rick Sawtell; Joseph L. Jorden; Lance Mortensen

• ISBN13: 9780782142785
• ISBN10: 0782142788
• Edition: 2nd
• Format: Paperback
• Copyright: 2003-09-01
• Publisher: Sybex

Summary

Here's the book you need to prepare for Exam 70-228, Installing, Configuring, and Administering Microsoft SQL Server 2000. This Study Guide provides: In-depth coverage of every official exam objective Practical information on installing, configuring, and administering SQL Server 2000 Real-world insights, advice, and recommendations Hundreds of challenging practice questions, in the book and on the CD Leading-edge exam preparation software, including a test engine and electronic flashcards Authoritative coverage of all exam objectives, including: Installing and configuring SQL Server 2000 Creating SQL Server 2000 databases Managing, monitoring, and troubleshooting SQL Server 2000 databases Extracting and transforming data with SQL Server 2000 Managing and monitoring SQL Server 2000 security Managing, monitoring, and troubleshooting SQL Server 2000 Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Author Biography

Lance Mortensen, MCT, currently works as an independent consultant and instructor, teaching both Microsoft and Novell certification classes.

Joe Jorden, MCT, is an independent networking consultant. He recently co-authored Mastering SQL Server 2000, also from Sybex.

Rick Sawtell, MCT, is an indepenent consultant and also teaches classes on SQL Server, Access, and Visual Basic.

Table of Contents

Introduction

Assessment Test

Introduction to SQL Server 2000 and Relational Databases

Installing, Upgrading, and Configuring SQL Server 2000

SQL Server Tools, Utilities, and Queries

Planning, Creating, and Managing a Database in SQL Server 2000

Security and SQL Server 2000

Implementing Database Backups and Restorations

Managing Your Data

Implementing Proactive Administration and IIS Support in SQL Server 2000

Creating and Implementing a Replication Solution in SQL Server 2000

Monitoring and Optimizing SQL Server 2000

Glossary

Index

Table of Contents provided by Publisher. All Rights Reserved.