Born To Learn

Training and Certification Community

Reminder: Some of the content contained on these wiki pages is contributed by members of the community and Microsoft provides no specific endorsement for any third party resources listed here. Please review the Code of Conduct and Terms of Use for detailed guidelines.

Database Certification Exam Prep Resources

Please select an exam below to see or share exam prep resources.

Rate This:

462: Administering Microsoft SQL Server 2012 Databases

Preparation Tools and Resources

Search here for prep resources for specific exam topics and add any exam prep resources that you have found helpful in preparing for this exam.

General preparation material

Skills Measured (Microsoft Learning)
<<Add your resources here>>
Exam Prep Video

Learning plans and classroom training

10775A: Administering Microsoft SQL Server 2012 Databases (5 Days)

Microsoft Press books

70-462 Training Kit: Administering Microsoft SQL Server 2012 Databases

Prep resources by objective

1 Install and Configure

1.1 Plan installation

1.2 Install SQL Server and related services

<<Add your resources here>>
<<Add your resources here>>

1.3 Implement a migration strategy

<<Add your resources here>>
<<Add your resources here>>

1.4 Configure additional SQL components

<<Add your resources here>>
<<Add your resources here>>

1.5 Manage SQL Server Agent

<<Add your resources here>>
<<Add your resources here>>

2 Maintain Instances and Databases

2.1 Manage and configure databases

<<Add your resources here>>
<<Add your resources here>>

2.2 Configure SQL Server instances

<<Add your resources here>>
<<Add your resources here>>

2.3 Implement a SQL Server clustered instance

<<Add your resources here>>
<<Add your resources here>>

2.4 Manage SQL Server instances

Manage Resource Governor (MSDN)
Resource Governor in SQL Server 2012 (White Paper)
Resource Governor Resource Pools (MSDN)
Resource Governor Workload Groups (MSDN)

3 Optimize and Troubleshoot

3.1 Identify and resolve concurrency problems

<<Add your resources here>>
<<Add your resources here>>

3.2 Collect and anaylyze troubleshooting data

<<Add your resources here>>
<<Add your resources here>>

3.3 Audit SQL Server instances

<<Add your resources here>>
<<Add your resources here>>

4 Manage Data

4.1 Configure and maintain a back up strategy

<<Add your resources here>>
<<Add your resources here>>

4.2 Restore databases

File Restores (MSDN)
<<Add your resources here>>

4.3 Implement and maintain indexes

<<Add your resources here>>
<<Add your resources here>>

4.4 Import and export data

<<Add your resources here>>
<<Add your resources here>>

5 Implement Security

5.1 Manage logins and server roles

<<Add your resources here>>
<<Add your resources here>>

5.2 Manage database permissions

<<Add your resources here>>
<<Add your resources here>>

5.3 Manage users and databse roles

<<Add your resources here>>
<<Add your resources here>>

5.4 Troubleshoot security

<<Add your resources here>>
<<Add your resources here>>

6 Implement High Availability

6.1 Implement AlwaysOn

Virtual lab Always on https://cmg.vlabcenter.com/lab/6f5ac2a3-33cc-4431-b43f-e6cce61d1f8e
<<Add your resources here>>

6.2 Implement database mirroring

<<Add your resources here>>
<<Add your resources here>>

6.3 Implement replication

<<Add your resources here>>
<<Add your resources here>>

70-462, database certification, Exam Prep, study group