Back to Search Results

Training Course Summary:

This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot Microsoft SQL Server™ client/server database management system version 7.0.

Pre-Requisites:

Course 922, Supporting Microsoft Windows NT 4.0 Core Technologies, or equivalent knowledge
An understanding of basic relational database concepts
Knowledge of basic Transact-SQL syntax (SELECT, UPDATE, and INSERT statements)
Familiarity with the role of the database administrator

Training Course Overview/Content:

At the end of the course, students will be able to:

Describe SQL Server architecture.
Plan for a SQL Server installation.
Install SQL Server.
Configure SQL Server; manage files and databases.
Choose a login security method.
Configure login security.
Plan and implement database permissions.
Back up databases.
Restore databases.
Automate administrative tasks using SQL Server Agent.
Import, export and transform data.
Monitor and maintain SQL Server performance.
Replicate data from one SQL Server to another.

Qualifications:

This course will help the student prepare for the following Microsoft Certified Professional exam:

Exam 70-028, System Administration for Microsoft SQL Server 7.0