Course Details

Previous Page

Microsoft SQL Server 2012: Managing Databases and Automating Tasks

Target Audience
Expected Duration
Lesson Objectives
Course Number

Database maintenance is an ongoing task for SQL Server 2012 administrators. This requires the integrity of the database to be checked, the database size to be kept to a minimum by ensuring the files are the correct sizes, and maintenance tasks to be run regularly. SQL Server 2012 Transact-SQL provides DBCC, which is a command that provides statements to maintain the database and database files. An administrator can also create jobs using SQL Server Agent to automate administrative tasks in the SQL Server Database Engine and throughout the enterprise by having the jobs run on multiple SQL Server servers throughout the enterprise using a master server. SQL Server 2012 provides the Database Mail feature which allows e-mails to be sent from SQL Server to users through applications. These e-mails can be anything from alerts to query results and files from any network resource using SMTP. This course demonstrates how to confirm the integrity of a database and manage the size of the database files. It also demonstrates how to configure Database Mail and SQL Server Agent jobs for a single server and for multiple servers. This course also discusses the database architecture and how to create and configure a database. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

Target Audience
Professionals typically pursuing a career as a Database Administrator; individuals who do not work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators among others; Database Administrators who as part of their daily task perform installation, maintenance, and configuration tasks


Expected Duration (hours)

Lesson Objectives

Microsoft SQL Server 2012: Managing Databases and Automating Tasks

  • recognize how to perform database management tasks using the DBCC CHECKDB command
  • alter the size of a database
  • describe the features of Database Mail
  • use the Database Mail Configuration Wizard to configure Database Mail
  • manage a SQL Server 2012 database
  • configure and manage Database Mail
  • identify the steps to configure SQL Server Agent to automate SQL Server administration
  • create a SQL Server Agent job
  • describe the characteristics of automated server administration in SQL Server 2012
  • set up servers to facilitate administrative job automation
  • recognize how to manage SQL Server Agent Jobs
  • recognize how to manage target servers
  • use SQL Server Agent to automate SQL Server administration
  • manage servers and jobs
  • Course Number: