Back To Microsoft Training Courses

System Administration for Microsoft SQL Server 7.0 Training CBT Suite

Price: $645.00

CBT Course Overview:

The Self Study Store Computer Based Training System Administration for Microsoft SQL Server 7.0 is designed for IT professionals responsible for installing, configuring, administering and troubleshooting Microsoft SQL Server 7.0. Skills taught in this series include Learn the main components of the SQL Server; upgrade to SQL Server 7.0; understand the basics of SQL Server databases and how to create databases and other objects; Learn the concepts, interfaces and fixed roles involved in performing backups; automate SQL Server 7.0 administrative tasks; and Learn the methods and attributes of SQL Server 7.0 replication.

Total Training Duration:

40 hours

CBT Course Modules:

• Microsoft SQL Server 7.0: System Administration - Part 1 Training
• Microsoft SQL Server 7.0: System Administration - Part 2 Training
• Microsoft SQL Server 7.0: System Administration - Part 3 Training
• Microsoft SQL Server 7.0: System Administration - Part 4 Training
• Microsoft SQL Server 7.0: System Administration - Part 5 Training

Total Course Topics:

• Learn the main components of the SQL Server.
• Understand the properties of SQL Server Architecture, including the underlying technical details.
• Understand the components of SQL Server installation, including hardware and software requirements, types of installations, and installation options.
• Work with Microsoft SQL Server 7.0, its architecture, security, and database structure.
• Understand the basics of SQL Server databases and how to create databases and other objects.
• Modify databases; manage data on multiple disks; assess database size requirements and to plan for growth.
• Learn the concepts, interfaces and fixed roles involved in performing backups.
• Gain a working knowledge of database, transaction log and filegroup backups and perform these backups as a system administrator.
• Restore damaged or incomplete databases.
• Automate SQL Server 7.0 administrative tasks.
• Learn and use the SQL Server 7.0 tools for transferring and transforming data.
• Learn and use the tools for monitoring and maintaining SQL Server 7.0.
• Learn the methods and attributes of SQL Server 7.0 replication.
• Learn and apply techniques for planning and setting up SQL Server 7.0 replication.
• Learn the procedures for replication maintenance.
• Much more.