Administering Microsoft SQL Server Databases

Exam 70-462 Administering Microsoft SQL Server 2012/2014 Databases

This course is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.

Course Content

Install and configure (20–25%)

• Plan installation
• Install SQL Server and related services
• Implement a migration strategy
• Configure additional SQL Server components
• Manage SQL Server Agent

Maintain instances and databases (15–20%)

• Manage and configure databases
• Configure SQL Server instances
• Implement a SQL Server clustered instance
• Manage SQL Server instances

Optimize and troubleshoot (15–20%)

• Identify and resolve concurrency problems
• Collect and analyze troubleshooting data
• Audit SQL Server instances

Manage data (20–25%)

• Configure and maintain a back-up strategy
• Restore databases
• Implement and maintain indexes
• Import and export data

Implement security (15–20%)

• Manage logins and server roles
• Manage database security
• Manage users and database roles
• Troubleshoot security

Implement high availability (5–10%)

• Implement AlwaysOn

Implement replication