Course Topics

• Plan installation
• Install SQL Server and related services
• Implement a migration strategy
• Configure additional SQL Server components
• Manage SQL Server Agent
• Manage and configure databases
• Configure SQL Server instances
• Implement a SQL Server clustered instance
• Manage SQL Server instances
• Identify and resolve concurrency problems
• Collect and analyze troubleshooting data
• Audit SQL Server instances
• Configure and maintain a back-up strategy
• Restore databases
• Implement and maintain indexes
• Import and export data
• Manage logins and server roles
• Manage database security
• Manage users and database roles
• Troubleshoot security
• Implement AlwaysOn