Microsoft SQL Server Database Administration

After completing this course, students will be able to:

• Authenticate and authorize users

• Assign server and database roles

• Authorize users to access resources

• Protect data with encryption and auditing

• Describe recovery models and backup strategies

• Backup SQL Server databases

• Restore SQL Server databases

• Automate database management

• Configure security for the SQL Server agent

• Manage alerts and notifications

• Managing SQL Server using PowerShell

• Trace access to SQL Server

• Monitor a SQL Server infrastructure

• Troubleshoot a SQL Server infrastructure

• Import and export data

Admission Requirements

Applicants must possess a high school diploma or GED, or pass the ability to benefit (ATB) test. In order to determine ability to benefit, the Wonderlic Basic Skills test will be given to all students who do not have a High School Diploma or GED.

Career Opportunity

Upon successfully completing this program, the student is prepared to take the Microsoft 70-764 certification exam. For more information, see: https://www.microsoft.com/en-us/learning/exam-70-764.aspx. Successful graduates will be employable as Database Administration professionals. (DOT Code 039.162-010)