Mcdba sql server 2000

The Only Certification Study System Based on 200,000+ Hours of IT Training Experience

100% Complete Coverage—All official test objectives for Exam 70-228 are covered in detail

Hands-on Exercises—Step-by-step instruction modeled after classroom labs

Exam Watch—Warnings based on thorough post-exam research identifying the most troublesome exam topics and how to answer them correctly

Three Types of Practice Questions—Knowledge, scenario, and lab-based questions, all with in-depth answers

From the Classroom—Discussions of important issues direct from the classrooms of Global Knowledge's award-winning instructors

Full coverage of the topics you need to review, including how to:

• Install and configure SQL Server 2000
• Plan for multiple instances of SQL Server
• Plan the physical placement of files
• Perform an unattended setup
• Upgrade from a previous version to SQL Server 2000
• Monitor and tune SQL Server 2000
• Optimize SQL Server performance using files and filegroups
• Manage database files
• Create and assign SQL Server roles
• Implement security using stored procedures, views, and user-defined functions
• Backup and restore data
• Transfer data and objects using DTS
• Implement multimaster replication

CD-ROM features full CertTrainer CBT software and the new ExamSim test engine­­more than 300 questions on CD

CertTrainer

• e-Training—Self-paced review of key SQL Server 2000 topics, including exam tips
• CERTCAM—Instructional SQL Server 2000 animations with expert audio explanations
• In-depth Links—Need more explanation? Topically relevant links provide detailed instruction
• Skill Assessment—Test your knowledge with more than 250 challenging practice exam questions
• Score Reports—Indicate subject areas requiring further study

ExamSim

• Complete Practice Exam—A realistic MCDBA exam with questions found only on the CD-ROM
• Review Mode—Analyze what you got wrong and why
• Detailed Answers—Explain why the correct options are right and why the incorrect options are wrong
• Score Report—Provides an overall assessment of your performance

PLUS

E-book—Electronic, searchable version of the Study Guide

Table of Contents

• Chapter 1: MS SQL Server Overview.
• Chapter 2: Capacity and Growth Planning for a SQL Database.
• Chapter 3: Planning Database and Server Security.
• Chapter 4: Planning for Installation.
• Chapter 5: Installing SQL Server.
• Chapter 6: Configuring SQL Server.
• Chapter 7: Monitoring and Tuning SQL Server.
• Chapter 8: Managing Database Files.
• Chapter 9: Managing Security.
• Chapter 10: Automating Administrative Tasks.
• Chapter 11: Backing Up Database.
• Chapter 12: Methods of Restoring Databases.
• Chapter 13: Transferring Data.
• Chapter 14: Replication.
• Chapter 15: Implementing Replication Scenarios.
• Chapter 16: Setting Up Replication