Microsoft SQL 2012 - New Features for Administrators — A 1 day course

contact usEnquire about this course

Course Synopsis

Please note that this course has been retired and is no longer available. Please see the RETIRED page for courses currently available in this subject area. This one-day instructor-led course teaches students how to implement high availability and security enhancements from Microsoft SQL Server 2012. This course is intended for MCTS and MCITP SQL 2005/8 Administrators.

Course Objectives

On completion of this training course, delegates should be able to:

Course Prerequisites

Before attending this course, students must have: Exposure to SQL Server 2005 / 2008 as administrators dealing with high availability (clusters, mirror, log shipping) and have designed and implemented SQL Server security.


This course has been retired and is no longer available.

Outline Course Contents

Section 1: Overview of Microsoft SQL Server 2012

Review the key features of SQL Server 2012.

Section 2: Improve Application Availability Using AlwaysOn

Introduction to the AlwaysOn Availability Group solution that improves the availability for application databases to help you achieve your production service-level agreements (SLAs)

Section 3: AlwaysOn Hands-on Lab

Learn how to set up, configure, and monitor high availability in SQL Server 2012 using the new SQL Server AlwaysOn high-availability (HA) solution.

Section 4: AlwaysOn HA DR Design Patterns

Learn how to use the AlwaysOn technologies of SQL Server 2012 and how they fit together for end-to-end solutions for HA and disaster recovery (DR) using lessons learned from early customer engagements.

Section 5: SQL Server 2012 Security Enhancements

Overview of security enhancements to SQL Server database engine and how they can help you satisfy your security objectives for storage and access control.

Section 6: Contained Databases and Security Hands-on Lab

Learn how contained databases work along with other new security features, including user-defined server roles, user-defined audit and audit filtering, and default schema assignment for Windows groups.