
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