This forty hours instructor-led course provides students who administer and maintain SQL Server databases with 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.
| Audience(s): | IT Professionals |
| Technology: | SQL Server 2016 |
| Duration: | 40 hours |
Module 1: SQL Server Security
Module 2: Assigning Server and Database Roles
Module 3: Authorizing Users to Access Resources
Module 4: Protecting Data with Encryption and Auditing
Module 5: Recovery Models and Backup Strategies
Module 6: Backing Up SQL Server Databases
Module 7: Restoring SQL Server 2016 Databases
Module 8: Automating SQL Server Management
Module 9: Configuring Security for SQL Server Agentwith Alerts and Notifications
Module 11: Introduction to Managing SQL Server by using PowerShell
Module 12: Tracing Access to SQL Server with Extended events
Module 13: Monitoring SQL Server
Module 14: Troubleshooting SQL Server
Module 15: Importing and Exporting Data
