MCSA SQL Server Administering Exam Objective

Module 01: Install and Configure

Module 02: Maintain instances and databases

Module 03: Optimize and troubleshoot

Module 04: Manage data

Module 05: Implement Security

Module 06: Implement high availability

Detailed Syllabus:

Module 01: Install and Configure

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

Module 02: Maintain instances and databases

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

Module 03: Optimize and troubleshoot

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

Module 04: Manage data

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

Module 05: Implement Security

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

Module 06: Implement high availability

Implement AlwaysOn
Implement replication

If You Like What We Do Here On DatabaseConcept, You Should Consider:

Stay Connected to: Twitter | Facebook

Subscribe to our email updates: Sign Up Now

 

We are thankful for your support.