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
| Introduction |
|
1 | (6) |
| Part I: Getting Started |
|
7 | (24) |
|
The Microsoft SQL Server 2000 System Administration Exam |
|
|
9 | (8) |
|
Exam Prep Roadmap: A SQL Server 2000 Primer |
|
|
17 | (14) |
| Part II: Installing and Configuring SQL Server 2000 |
|
31 | (80) |
|
Planning to Implement SQL Server 2000 |
|
|
33 | (20) |
|
Installing SQL Server 2000 |
|
|
53 | (16) |
|
Upgrading to SQL Server 2000 |
|
|
69 | (12) |
|
Troubleshooting Installation Problems |
|
|
81 | (12) |
|
Configuring SQL Server to Send E-Mail |
|
|
93 | (18) |
| Part III: Creating SQL Server Databases |
|
111 | (82) |
|
|
|
113 | (16) |
|
|
|
129 | (20) |
|
|
|
149 | (22) |
|
Creating and Managing Database Objects |
|
|
171 | (22) |
| Part IV: Managing, Monitoring, and Troubleshooting Databases |
|
193 | (112) |
|
Managing and Optimizing Database Performance |
|
|
195 | (28) |
|
|
|
223 | (12) |
|
|
|
235 | (26) |
|
|
|
261 | (20) |
|
Using Database Monitoring and Troubleshooting Tools |
|
|
281 | (24) |
| Part V: Transferring Data |
|
305 | (68) |
|
Integrating SQL Server with Internet Information Services |
|
|
307 | (10) |
|
Importing and Exporting Data |
|
|
317 | (24) |
|
Installing, Configuring, and Troubleshooting Replication |
|
|
341 | (32) |
| Part VI: Securing SQL Server |
|
373 | (48) |
|
Configuring Login Security |
|
|
375 | (14) |
|
|
|
389 | (20) |
|
|
|
409 | (12) |
| Part VII: Managing, Monitoring, and Troubleshooting SQL Server 2000 |
|
421 | (44) |
|
Automating Administrative Tasks and Alerts |
|
|
423 | (20) |
|
Optimizing Hardware Resources |
|
|
443 | (10) |
|
Monitoring and Troubleshooting SQL Server |
|
|
453 | (12) |
| Part VIII: The Part of Tens |
|
465 | (10) |
|
Ten Terrific Exam Day Tips |
|
|
467 | (4) |
|
Ten MCSE Certification Resources |
|
|
471 | (4) |
| Part IX: Appendix |
|
475 | (8) |
|
|
|
477 | (6) |
| Index |
|
483 | (18) |
| Hungry Minds, Inc. End-User License Agreement |
|
501 | (2) |
| Installation Instructions |
|
503 | |
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.
