GK4396A Administering a SQL Database Infrastructure (20764_B)

0% of 30 hours and 52 minutes completed.

In this course, professionals who administer and maintain SQL Server databases and who develop applications that deliver content from SQL Server databases will gain the knowledge and skills to administer a SQL server database infrastructure.

This course incorporates material from the Official Microsoft Learning Product 20764: Administering a SQL Database Infrastructure.

After completing this course, you will be able to:

  • Authenticate and authorize users.
  • Assign server and database roles.
  • Authorize users to access resource.
  • Protect data with encryption and auditing. Recovery models and backup strategies.
  • Back up SQL Server databases.
  • Restore SQL Server databases.
  • Automate database management.
  • Configure security for the SQL Server agent.
  • Manage alerts and notifications.
  • Manage SQL Server using PowerShell.
  • Trace access to SQL Server.
  • Monitor a SQL Server infrastructure.
  • Troubleshoot a SQL Server infrastructure.
  • Import and export data.
There are no resources available.
0 attachments
0%
SQL Server Security
2 hours 2 minutes 25 Activities: Article  (0)  |  Lab  (6)  |  Video  (19)
0%
Assigning Server and Database Roles
2 hours 24 Activities: Article  (0)  |  Lab  (6)  |  Video  (18)
0%
Authorizing Users to Access Resources
2 hours 1 minute 25 Activities: Article  (0)  |  Lab  (6)  |  Video  (19)
0%
Protecting Data with Encryption and Auditing
2 hours 23 minutes 35 Activities: Article  (0)  |  Lab  (6)  |  Video  (29)
0%
Recovery Models and Backup Strategies
2 hours 5 minutes 24 Activities: Article  (0)  |  Lab  (6)  |  Video  (18)
0%
Backing Up SQL Server Databases
2 hours 4 minutes 24 Activities: Article  (0)  |  Lab  (6)  |  Video  (18)
0%
Restoring SQL Server 2016 Databases
1 hour 54 minutes 25 Activities: Article  (0)  |  Lab  (6)  |  Video  (19)
0%
Automating SQL Server Management
2 hours 26 Activities: Article  (0)  |  Lab  (6)  |  Video  (20)
0%
Configuring Security for SQL Server Agent
1 hour 37 minutes 20 Activities: Article  (0)  |  Lab  (6)  |  Video  (14)
0%
Monitoring SQL Server with Alerts and Notifications
2 hours 12 minutes 27 Activities: Article  (0)  |  Lab  (6)  |  Video  (21)
0%
Introduction to Managing SQL Server Using PowerShell
2 hours 13 minutes 28 Activities: Article  (0)  |  Lab  (6)  |  Video  (22)
0%
Tracing Access to SQL Server with Extended Events
1 hour 38 minutes 24 Activities: Article  (0)  |  Lab  (6)  |  Video  (18)
0%
Monitoring SQL Server
2 hours 13 minutes 33 Activities: Article  (0)  |  Lab  (6)  |  Video  (27)
0%
Troubleshooting SQL Server
1 hour 29 minutes 15 Activities: Article  (0)  |  Lab  (6)  |  Video  (9)
0%
Importing and Exporting Data
2 hours 22 minutes 32 Activities: Article  (0)  |  Lab  (6)  |  Video  (26)
0%
Course Conclusion: GK4396A Administering a SQL Database Infrastructure
1 minute 1 Activity: Article  (0)  |  Lab  (0)  |  Video  (1)
0%
End of Course Questions
25 minutes 25 Activities: Article  (0)  |  Lab  (25)  |  Video  (0)
0%
Survey
5 minutes 1 Activity: Article  (1)  |  Lab  (0)  |  Video  (0)