Automating SQL Server 2012

Can’t find the right date? Consider a self study option. Get immediate access to online training videos, course materials and exam prep guides. Check out our Microsoft Self Study Courses >>>.

All Prices Are in Candian Dollars

Price : CAD

Description

 

Module 13: Automating SQL Server 2012 Management

This module covers SQL Server Agent, jobs and job history.

Lessons

  • Automating SQL Server Management
  • Working with SQL Server Agent
  • Managing SQL Server Agent Jobs

Lab: Automating SQL Server Management

  • Create a Data Extraction Job
  • Schedule the Data Extraction Job
  • Troubleshoot a Failing Job

After completing this module, students will be able to:

  • Automate SQL Server Management.
  • Work with SQL Server Agent.
  • Manage SQL Server Agent jobs.

 

Module 14: Configuring Security for SQL Server Agent

This module covers SQL Server agent security, proxy accounts and credentials.

Lessons

  • Understanding SQL Server Agent Security
  • Configuring Credentials
  • Configuring Proxy Accounts

Lab: Configuring Security for SQL Server Agent

  • Troubleshoot job execution failure
  • Resolve the security issue
  • Perform further troubleshooting

After completing this module, students will be able to:

  • Explain SQL Server Agent security.
  • Configure credentials.
  • Configure Proxy accounts.

 

Module 15: Monitoring SQL Server 2012 with Alerts and Notifications

This module covers the configuration of database mail, alerts and notifications.

Lessons

  • Configuration of Database Mail
  • Monitoring SQL Server Errors
  • Configuring Operators, Alerts and Notifications

Lab: Monitoring SQL Agent Jobs with Alerts and Notifications

  • Configure Database Mail
  • Implement Notifications
  • Implement Alerts

After completing this module, students will be able to:

  • Configure database mail.
  • Monitor SQL Server errors.
  • Configure operators, alerts and notifications.

 

All search results