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

Learning plans and classroom training

Prep resources by objective

1  Install and Configure

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>>

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

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

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>>