Microsoft Certified Database Administrator (MCDBA), Microsoft Certification - Individual Exams

McDba SQL Server 2000 All-in-One Exams Guide

Name: McDba SQL Server 2000 All-in-One Exams Guide
Author: Dave Perkovich
ISBN: 9780072131581

by Dave Perkovich

Write a review

Overview

All-in-One is all you need! This authoritative reference offers complete coverage of all material on the two core MCDBA SQL Server 2000 exams. You'll find exam objectives at the beginning of each chapter,helpful exam tips,end-of-chapter practice questions,and photographs and illustrations. The bonus CD-ROM contains practice tests,hundreds of questions,and LearnKey(tm) video clips. This comprehensive guide will not only help you pass the MCDBA SQL Server 2000 certification exams,but will also serve as an invaluable on-the-job reference.

Now you can prepare for the two required MCDBA exams —Installing,Configuring,and Administering (#70-228) and Designing and Implementing Databases (#70-229) — using this comprehensive reference. You'll also get an overview of the various editions of SQL Server,including which operating systems each edition supports,as well as full details on some of the advanced features of SQL Server 2000. Learn how to perform both local and remote installations,administer both Windows 2000 Server as well as SQL Server 2000,manage and maintain data,and much more. Each chapter contains detailed exam objectives,practice questions,and test-taking tips from a Microsoft-certified trainer,making this a premier study tool. Filled with practical advice,as well as case studies to help illustrate concepts and techniques you've just read about,this book is highly useful as both an exam preparation guide and an on-the-job resource.

Get complete details on exam topics including how to:

Install,configure,and upgrade to SQL Server 2000
Plan for a SQL Server database implementation
Create a user-defined database using both SQL ServerEnterprise Manager and Transact-SQL
Monitor security functions—set database permissions,manage user accounts and logon information
Modify,optimize,and troubleshoot a SQL Server 2000 database
Develop the logical data model and physical design of a SQL database

About the Author, Dave Perkovich

Syngress Media, Inc. (Rockland, MA) is an independent company committed to creating the very best book, software and Internet based exam preparation tools. They have published over 20 certification study guides and over a dozen Personal Testing Centers. All of these products are created by leading content experts, many of whom are also full-time trainers.