GK4396A Administering a SQL Database Infrastructure (20764_C)

0% of 23 hours and 45 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. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

This course incorporates material from the Official Microsoft Learning Product 20764: Administering a SQL Database Infrastructure and can assist you in preparing for the 70-764: Administering a SQL Database Infrastructure exam

After completing this course, you 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
  • 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
1 hour 40 minutes 26 Activities: Article  (0)  |  Lab  (6)  |  Video  (20)
0%
Assigning Server and Database Roles
1 hour 32 minutes 24 Activities: Article  (0)  |  Lab  (6)  |  Video  (18)
0%
Authorizing Users to Access Resources
1 hour 33 minutes 25 Activities: Article  (0)  |  Lab  (6)  |  Video  (19)
0%
Protecting Data with Encryption and Auditing
1 hour 53 minutes 34 Activities: Article  (0)  |  Lab  (6)  |  Video  (28)
0%
Recovery Models and Backup Strategies
1 hour 36 minutes 24 Activities: Article  (0)  |  Lab  (6)  |  Video  (18)
0%
Backing Up SQL Server Databases
1 hour 36 minutes 24 Activities: Article  (0)  |  Lab  (6)  |  Video  (18)
0%
Restoring SQL Server Databases
1 hour 27 minutes 25 Activities: Article  (0)  |  Lab  (6)  |  Video  (19)
0%
Automating SQL Server Management
1 hour 32 minutes 26 Activities: Article  (0)  |  Lab  (6)  |  Video  (20)
0%
Configuring Security for SQL Server Agent
1 hour 9 minutes 20 Activities: Article  (0)  |  Lab  (6)  |  Video  (14)
0%
Monitoring SQL Server with Alerts and Notifications
1 hour 44 minutes 27 Activities: Article  (0)  |  Lab  (6)  |  Video  (21)
0%
Introduction to Managing SQL Server Using PowerShell
1 hour 45 minutes 28 Activities: Article  (0)  |  Lab  (6)  |  Video  (22)
0%
Tracing Access to SQL Server with Extended Events
1 hour 9 minutes 24 Activities: Article  (0)  |  Lab  (6)  |  Video  (18)
0%
Monitoring SQL Server
1 hour 35 minutes 29 Activities: Article  (0)  |  Lab  (6)  |  Video  (23)
0%
Troubleshooting SQL Server
1 hour 1 minute 15 Activities: Article  (0)  |  Lab  (6)  |  Video  (9)
0%
Importing and Exporting Data
1 hour 54 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)