Administering a SQL Database Infrastructure (20764)

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of 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