Microsoft SQL Server 2012: Managing Databases and Automating Tasks

Overview/Description
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

Prerequisites
n/a

Expected Duration (hours)
2.0

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