Automating Administrative Tasks in Microsoft SQL Server 2008 (E-Learning)

Printer-friendly version
Vendor: 
Microsoft
Subject: 
Database
Overview: 

Length:2.00 hours - Excluding labs and assessments
Published:Aug 25, 2009
Language:English
Audiences:IT Professional
Level:Advanced
Technology:Microsoft SQL Server 2008
Type:Course
Delivery method:Self-pace Course

Course Contents: 

This two-hour course provides you with the skills and knowledge required to automate administrative tasks in SQL Server 2008. You will learn how to configure SQL Server Agent and use the maintenance wizard and plans to create jobs. You will also learn how to automate tasks in a multi-server environment and configure SQL Server security.

Topics covered in this course include:

Automating Administrative Tasks
Configuring SQL Server Agent
Creating Jobs and Operators
Creating Alerts
Managing Multiple Servers

Objective: 

Automate administrative tasks in SQL Server 2008.
Configure SQL Server Agent.
Create jobs and operators.
Create alerts.
Manage multiple servers..

Prerequisites: 

To benefit from this course, the learner must be familiar with using Microsoft Windows. They must have knowledge of basic relational database concepts and querying data by using Transact-SQL. They must be familiar with the role of a database administrator.

For more information on Automating Administrative Tasks in Microsoft SQL Server 2008 (E-Learning) please feel free to contact us online or call us at 416-513-1535.