>

Computer Technology 

   >

Administering a SQL Database Infrastructure

Duration (Days)

5

Overview

This course is designed to provide participants the knowledge and skills to administer a SQL server database infrastructure. They will learn how to develop applications that deliver content from SQL server databases.

Objectives

• Manage users

• Assign server and database roles

• Manage users access to resources

• Apply encryption and auditing to protect data

• Recovery models and backups strategies

• Backup and restore SQL server databases

• Manage databases

• Configure SQL security

• Manage alerts and notifications

• Monitor and mange SQL server infrastructure

Course Outline

• SQL server security

• Server and database roles

• User access management

• Data protection with encryption and auditing

• Recovery and backup strategies

• SQL server databases restoration

• SQL server management automation

• SQL server agent security configuration

• SQL server with alerts and notifications

• Powershell

• SQL server with extended events

• SQL troubleshooting

• Data import and export management