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