Microsoft SQL Server 7.0 System Administration Training Kit offers a structured, self-paced learning program primarily designed to prepare you for Microsoft Certified Professional (MCP) exam 70-028. It also functions well as a solid tutorial for present and prospective database administrators.

Painting with a broad brush, the book covers all of the practical skills necessary for successful administration. It opens with a general overview of the product and a high-level chapter on installation. A section on upgrading follows as well as an introduction to the administration utilities.

While the coverage of database files and data transfers appears to be a bit short-winded, the essentials for administrator survival remain intact. Web site builders will find short discussions on full-text indexing and the production of Web pages from the database. Another three brief chapters focus on backup and restoration issues. Performance monitoring, replication, and maintenance plans are addressed in a similarly brisk manner.

Each chapter comprises structured lessons designed to cover applicable topics with review sections and study questions to keep you on track. A companion CD-ROM includes hands-on lessons and multimedia presentations to help illustrate key concepts. This structured tutorial offers a relatively quick way to prepare for the 70-028 exam and should get you up to speed on basic administration tasks. --Stephen Plain


Book Description
IS staff, database administrators, and system engineers will learn how to install, configure, administer, and troubleshoot Microsoft SQL Server 7.0. Students will attain an understanding of the architecture and, through the accompanying labs, gain hands-on experience with the procedures to plan, configure, and support solutions using the necessary robust Microsoft SQL Server 7.0 database management system. Upon course completion, students will be able to install SQL Server; manage files and databases; configure login security; implement database permissions; transfer and migrate data into databases; back up and restore databases; monitor SQL Server performance and automate administrative tasks; replicate data and distribute database information on the Web and more. This is the self-paced equivalent of the instructor-led training Course #832 and will prepare students for MCP exam 70-028, System Adminstration for Microsoft SQL Server 7.0. CDs include lab exercises and 120-day trial software for SQL Server 7.0.

ANNOTATION

The target audience of this title is SQL Server administrators who install,configure, and support SQL server in an enterprise network. Business owners, contractors, and database administrators will also find all they need to know about Microsoft SQL Server.

FROM THE PUBLISHER