Topics

Topics:

  • SQL Server Security

  • Assigning Server and Database Roles

  • Authorizing Users to Access Resources

  • Protecting Data with Encryption and Auditing

  • Recovery Models and Backup Strategies

  • Backing Up SQL Server Databases

  • Restoring SQL Server 2016 Databases

  • Automating SQL Server Management

  • Configuring Security for SQL Server Agent

  • Monitoring SQL Server with Alerts and Notifications

  • Introduction to Managing SQL Server by using PowerShell

  • Tracing Access to SQL Server with Extended events

  • Monitoring SQL Server

  • Troubleshooting SQL Server

  • Importing and Exporting Data

  • Azure SQL Database