MOC 10775 A Administering Microsoft SQL Server 2012 Databases

    

Summary:
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database. Also this course helps you prepare for the Exam 70-462.

All the labs for this course can be performed using the provided virtual machines. However, if you have a Microsoft Windows Azure account and the classroom virtual machines connect to the internet you may be able to connect to your Azure server and database from the classroom. Many of the labs in this course are enabled for you to perform the lab while connected to your own Azure database in the cloud. Your instructor should be able to provide a current list of Azure enabled labs.

Duration:
5 Days/Lecture & Lab

Audience:
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

Topics:

• Introduction to SQL Server 2012 and its Toolset
• Preparing Systems for SQL Server 2012
• Installing and Configuring SQL Server 2012
• Working with Databases
• Understanding SQL Server 2012 Recovery
• Restoring SQL Server 2012 Databases
• Importing and Exporting Data
• Authenticating and Authorizing Users
• Assigning Server and Database Roles
• Authorizing Users to Access Resources
• Auditing SQL Server Environments
• Configuring Security for SQL Server Agent
• Monitoring SQL Server 2012 with Alerts and Notifications
• Performing Ongoing Database Maintenance
• Tracing Access to SQL Server 2012
• Monitoring SQL Server 2012
• Managing Multiple Servers

Prerequisites:
Students should have:
Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of Transact-SQL.
Working knowledge of relational databases.
Some experience with database design.
Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills:
0774A: Writing T-SQL Queries for Microsoft SQL Server 2012

Last Update: May 21, 2013