Microsoft SQL Server 7.0: System Administration- Part 4 CBT Training CD

Rating:
Summary: Microsoft SQL Server 7.0: System Administration- Part 4 CBT
Review: Course Overview
This is the fourth course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.

Learn To

Automate SQL Server 7.0 administrative tasks.
Identify and use the SQL Server 7.0 tools for transferring and transforming data.
Identify and use the tools for monitoring and maintaining SQL Server 7.0.

Audience
This course is designed for IT professionals responsible for installing, configuring, administering and troubleshooting Microsoft SQL Server 7.0. Participants should have completed the first three courses in this series.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Automating Administrative Tasks 2 - 3 hours

Select the reasons for automating SQL Server maintenance tasks.
Identify SQL Server automation components.
Identify the components of automated administrative tasks.
Identify tasks to be completed in preparation for automating administrative tasks.
Perform the steps to create a job.
Perform the steps to define job steps.
Configure action flow logic for a job step.
Schedule the frequency of a job.
Perform the step to create an operator for notification.
Configure job history size.
Identify the guidelines to help isolate and solve problems.
Create an alert to respond to a specific error.
Create an alert on a user-defined error.
Define an alert response.
Identify the factors that cause looping alerts.
Identify the features of a multiserver environment.
Define a master server.
Define a target server.
Identify the facts to consider when making changes to a job in a multiserver environment.
Identify the features of SQL Server Web Assistant.
Create an HTML file.
Execute a defined Web Assistant job.

Unit 2: Transferring Data 2 - 3 hours

Identify the steps for copying data from one environment to another.
Select the tasks that are done when transforming data.
Match data transfer tool names with uses.
Identify the features of Data Transformation Services (DTS).
Identify data source and data destination types provided in SQL Server.
Match each Data Transformation Services (DTS) tool with its function.
Identify the features of restructuring and mapping data.
Select the functions that can be performed using Data Transformation Services (DTS) steps.
Identify the features of Data Transformation Services (DTS) workflows.
Create a Data Transformation Services (DTS) package.
Schedule and execute a Data Transformation Services (DTS) package.

Unit 3: Monitoring and Maintaining SQL Server 2 hours

Select the purposes for monitoring SQL Server.
Identify the factors that affect SQL Server performance.
Match the factors that can cause bottlenecks to the effects they have on the server.
Match aspects of SQL Server performance with tools for monitoring.
View the event log.
Monitor SQL Server.
View current server activity.
Create a trace to monitor and respond to server events.
Collect information on a specific table.
Start the Flight Recorder.
Identify SQL Server Maintenance tasks.
Start the Database Maintenance Plan wizard.
Automate a database maintenance plan.