For Certification Exam #70-028.
Intermediate - Advanced Level Users.
Includes 2 CD-ROMs.
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 robust 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 from one SQL Server to another
- Create custom administrative tools
- Perform a basic SQL Server tune-up
- Distribute database information on the Web
This is the self-paced equivalent of the instructor-led training Course #832 and will prepare students for MCP exam 70-028: System Administration for Microsoft SQL Server 7.0. The CDs include lab exercises and 120-day evaluation software for SQL Server 7.0.