Microsoft SQL 2012 - New Features for Administrators — A 1 day course
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.
On completion of this training course, delegates should be able to:
- Describe key features of Microsoft SQL Server 2012
- Describe SQL Server AlwaysOn Availability
- Implement, configure and monitor an AlwaysOn Availability solution
- Describe security enhancements
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.