Microsoft Certified Solution Developer.
For Certification Exam #70-028.
Intermediate - Advanced Level Users.
This book is specially designed and written to help you pass the Administering SQL Server 7.0 exam. It features special sections on proven test-taking strategies, warnings on trick questions, and time-saving study tips. It also provides practice exams with special questions designed to prepare you to take the exam. As a bonus, it provides a special Cram Sheet with tips, acronyms, and memory joggers you can use to take the certification exam.
You will learn how to:
- Install and upgrade to SQL Server 7
- Plan hardware and software
- Install services and SQL Mail
- Plan and implement security for the server, database, and data objects
- Manage databases, files, and file groups
- Use tools available to transfer data from alternate data sources
- Back up and restore databases, files and sets
- Determine what to monitor, and how
- Use the SQL profiler and resource governor
- Automate administrative tasks
- Mange and troubleshoot replication and remote servers
