|
Provided by: 123-CBT Computer Based Training SQL Server 7 0 System Administration - Part 4 |
 |
Training
Provided by 123-CBT Computer Based Training
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.
Content Emphasis
Skills-Based
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.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Automating Administrative Tasks
Duration: 2 - 3 Hour(s)- 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
Duration: 2 - 3 Hour(s)- 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
Duration: 2 Hour(s)- 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.
|
|
||||||||||||||
SQL Server 7 0 System Administration - Part 4
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
