Automating Administrative Tasks in Microsoft SQL Server 2008 (10156)


Description:

This two-hour course provides you with the skills and knowledgerequired to automate administrative tasks in SQL Server 2008. You willlearn how to configure SQL Server Agent and use the maintenance wizardand plans to create jobs. You will also learn how to automate tasks ina 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


Student prerequisites:

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

 

Objectives:

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



User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-AATM-S208
  • Duration: 2 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend