Exam 70-462 Administering Microsoft SQL Server 2012 Databases
Microsoft Official Academic Course Series

This book is for students preparing to become certified for the recent Microsoft release, Exam 70-462 Administering Microsoft SQL Server 2012 Databases exam.  This exam is the second of three exams required for Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 certification. The Microsoft Official Academic Course (MOAC) lessons correlate and are mapped to The Microsoft Certified Solutions Associate (MCSA) Exam 70-462 Administering Microsoft SQL Server 2012 Databases certification exam.  Your students master installation and configuration, maintenance instances and databases, optimization and troubleshooting Server 2012, as well as managing data and implementation of security and high availability.  This certification can broaden their career opportunities in such fields as Database Professionals who perform installation, maintenance and configuration tasks as their primary areas of responsibility. These IT Professionals often set up database systems and are responsible for making sure those systems operate efficiently. They also make sure that the data they store is backed up regularly, stored effectively, and that the data is secure from unauthorized access.

The MOAC IT Professional series is the Official from Microsoft, turn-key Workforce training program that leads to professional certification and was authored for college instructors and college students. MOAC  gets instructors ready to teach and students ready for work by delivering essential resources in 5 key areas:  Instructor readiness, student software, student assessment, instruction resources, and learning validation.   With the Microsoft Official Academic course program, you are getting instructional support from Microsoft; materials that are accurate and make course delivery easy.

Part 1: Install and Configure

Lesson 1: Plan Installation

Lesson 2: Install SQL Server and Related Services

Lesson 3: Implement a Migration Strategy

Lesson 4: Configure Additional SQL Server Components

Lesson 5: Manage SQL Server Agent

Part 2: Maintain Instances and Databases

Lesson 6: Manage and Configure Databases

Lesson 7: Configure SQL Server Instances

Lesson 8: Implement a SQL Server Clustered Instance

Lesson 9: Manage SQL Server Instances

Part 3: Optimize and Troubleshoot

Lesson 10: Identify and Resolve Concurrency Problems

Lesson 11: Collect and Analyze Troubleshooting Data

Lesson 12: Audit SQL Server Instances

Part 4: Manage Data 

Lesson 13: Configure and Maintain a Backup Strategy

Lesson 14: Restore Databases

Lesson 15: Implement and Maintain Indexes

Lesson 16: Import and Export Data

Part 5: Implement Security

Lesson 17: Manage Logins and Server Roles

Lesson 18: Manage Database Permissions

Lesson 19: Manage Users and Database Roles

Lesson 20: Troubleshoot Security

Part 6: Implement High Availability

Lesson 21: Implement AlwaysOn

Lesson 22: Implement Database Mirroring

Lesson 23: Implement Replication