McSe: SQL Server 7 Administration: Training Guide : Exam : 70-028

by Wille, Christoph; Bersinic, Damir; Crothers, Tim; McGehee, Brad; Scrimger, Rob

• ISBN13: 9780735700031
• ISBN10: 0735700036
• Edition: CD
• Format: Hardcover
• Copyright: 1999-05-01
• Publisher: Pearson P T R

Summary

PLEASE PROVIDE COURSE INFORMATION The SQL Server 7 Administration Exam, Exam 70-028, is one of the most popular electives on the MCSE certification track. Candidates must take two electives, in addition to four core exams to get their MCSE certification. The Training Guide series from New Riders is the best way for students to prepare. Organized around the exam objectives, Training Guides make it easy for you to focus on areas where you need to improve. It also helps you identify what the key topics on the exam will be. This boo k offers concise, clearly delineated coverage of the key concepts necessary to pass the SQL Server 7 Administration exam. An added bonus is the exclusive Top Score test engine and unique software simulator provide you with a testing situation similar to what you will find on the actual exam. Approved by Microsoft as an Official Study Guide.

Author Biography

Christoph Wille, MCSE, MCSD, has an extensive background working with Microsoft SQL Server, Microsoft operating systems, Access, MFC, and OLE. He is currently a corporate Internet strategy consultant. Damir Bersinic, MCT, MCSE+I, Oracle Certified DBA and Trainer, has more than 15 years of industry experience working with SQL Server, Oracle, Microsoft Windows NT and Back Office, and other advanced products. He is president and founder of Bradley Systems Incorporated, a Microsoft Certified Solution Provider. Brad McGehee, MCT, MCSE, CNE, is a full-time computer trainer. He has written more than 100 articles on computers and has served as either author or editor on five computer books. Rob Scrimger, MCT, MCSE+I, is currently the Product Stream Leader, Microsoft, at Learnix. He has more than ten years of training experience in the areas of network operating systems and client/server applications.

Table of Contents

Introduction	01	(10)
Part I Exam Preparation	11	(578)
1 Planning	11	(108)
2 Installation and Configuration	119	(82)
3 Configuring and Managing Security	201	(106)
4 Managing and Maintaining Data	307	(50)
5 Performing Backup and Restore	357	(34)
6 Managing Replication	391	(30)
7 Automating Administrative Tasks	421	(30)
8 Using Linked Servers	451	(14)
9 Monitoring and Optimization	465	(60)
10 Troubleshooting	525	(64)
PART II Final Review	589	(56)
Study and Exam Prep Tips	589	(10)
Fast Facts	599	(16)
Practice Exam	615	(30)
Part III Appendixes	645	(28)
A Glossary	645	(10)
B Overview of the Certification Process	655	(8)
C What's On the CD-ROM	663	(2)
D Using the Top Score Software	665	(8)
Index	673