View Course Outline

This Microsoft approved course provides step-by-step preparation to install, configure, administer, and troubleshoot Microsoft SQL Server version 7.0. At the conclusion of this course, you’ll be fully prepared for system administration using Microsoft SQL Server version 7.0, and be prepared to pass MCP exam #70-028.

Course includes 8+ hours of total training time...

• 5 CDs
• Over 8 hours of media run time

Administering SQL Server 7.0

This Microsoft approved course provides step-by-step preparation to install, configure, administer, and troubleshoot Microsoft SQL Server version 7.0. At the conclusion of this course, you’ll be fully prepared for system administration using Microsoft SQL Server version 7.0, and be prepared to pass MCP exam #70-028.

SESSION 1
Total Time: 97 Minutes

• Introduction
• Installation Planning
• Installation
• SQL Enterprise Manager
• SQL Tools

SESSION 2
Total Time: 105 Minutes

• Troubleshooting Installation
• Advanced Installation
• Upgrade
• Client Install
• Creating Databases
• Database Considerations

SESSION 3
Total Time: 104 Minutes

• Performance Considerations
• Managing Databases
• Security Models
• Logins & Users
• Permissions & Roles
• Applying Permissions & Roles

SESSION 4
Total Time: 106 Minutes

• Backups
• Transaction Logs
• Filegroup Backups
• Optimizing Backups
• Restore
• Backup & Restore
• Relocating Data

SESSION 5
Total Time: 96 Minutes

• Replication Overview
• Configuring Replication
• Linked Server
• Automation
• Alerts & Troubleshooting
• SQL Mail
• Monitoring & Optimizing
• Full Text Search

back to top

Wayne Snyder is a recognized expert in application development and database design and modeling with specialization in Microsoft SQL Server. Wayne has worked with SQL from its first release, and won the prized Microsoft MVP (Most Valuable Professional) award in 1998. His certifications include MCDBA, MCSE, and MCT. Wayne is a highly respected speaker at industry conferences and a sought-after reviewer for major technical publications. He is a popular instructor and consultant currently working with IKON Education Services.

back to top