Finding the Best Starting Point for You

3 4

Because this book is self-paced, you can skip some lessons and revisit them later. Note, however, that you must complete the procedures in Chapter 2, "Installing SQL Server 2000," before you can perform procedures in the other chapters. Use the following table to find the best starting point for you.

If you	Follow this learning path
Are preparing to take the Microsoft Certified Professional Exam 70-228, Installing, Configuring and Administering Microsoft SQL Server 2000 Enterprise Edition.	Work through all chapters, 1 - 16, in order
Want to review information about specific topics from the exam	Use the "Where to Find Specific Skills in This Book" section that follows this table

Where to Find Specific Skills in This Book

The following tables provide a comprehensive list of the skills measured on the Microsoft Certified Professional Exam 70-228, Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition. The table lists the skill and indicates where in this book you will find the lesson relating to that skill.

Note

---

Exam skills are subject to change without prior notice at the sole discretion of Microsoft.

Installing and Configuring SQL Server 2000

Skill Being Measured	Location in Book
Install SQL Server 2000	Chapter 2
Upgrade to SQL Server 2000	Chapter 4
Create a linked server	Chapter 12
Configure SQL Mail and SQLAgentMail	Chapter 12
Configure network libraries	Chapter 2
Troubleshoot failed installations	Chapter 2

Creating SQL Server 2000 Databases

Skill Being Measured	Location in Book
Configure database options for performance	Chapter 6
Attach and detach databases	Chapter 6
Create and alter databases	Chapter 6

Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases

Skill Being Measured	Location in Book
Optimize database performance	Chapter 6, Chapter 14
Optimize data storage	Chapter 6
Modify the database schema	Chapter 5, Chapter 6
Perform disaster recovery operations	Chapter 8, Chapter 9, Chapter 15
Perform integrity checks	Chapter 12, Chapter 13
Troubleshoot transactions and locking	Chapter 14

Extracting and Transforming Data with SQL Server 2000

Skill Being Measured	Location in Book
Set up Internet Information Services (IIS) virtual directories to support XML	Chapter 12
Import and export data	Chapter 7
Develop and manage Data Transformation Services (DTS) packages	Chapter 7
Manage linked servers	Chapter 12
Configure, maintain, and troubleshoot replication services	Chapter 15

Managing and Monitoring SQL Server 2000 Security

Skill Being Measured	Location in Book
Configure mixed security modes or Windows Authentication	Chapter 2, Chapter 10
Create and manage logins	Chapter 10
Create and manage database users	Chapter 11
Create and manage security roles	Chapter 10, Chapter 11
Enforce and manage security	Chapter 10, Chapter 11
Set permissions in a database	Chapter 11
Manage security auditing	Chapter 11, Chapter 14

Managing, Monitoring, and Troubleshooting SQL Server 2000

Skill Being Measured	Location in Book
Create, manage, and troubleshoot SQL Server Agent jobs	Chapter 13, Chapter 15
Configure alerts and operators by using SQL Server Agent	Chapter 13
Optimize hardware resource usage	Chapter 6, Chapter 14, Chapter 16
Optimize and troubleshoot SQL Server system activity	Chapter 14