6231 - Maintaining

Duration:40Hour


Description:

Module 1: Introduction to SQL Server 2008 R2 and its Toolset
Module 2: Preparing Systems for SQL Server 2008 R2
Module 3: Installing and Configuring SQL Server 2008 R2
Module 4: Working with Databases
Module 5: Understanding SQL Server 2008 R2 Recovery Models
Module 6: Backup of SQL Server 2008 R2 Databases
Module 7: Implementing Replication
Module 8: Importing and Exporting Data
Module 9: Authenticating and Authorising Users
Module 10: Assigning Server and Database Roles
Module 11: Authorising Users to Access Resources
Module 12: Auditing SQL Server Environments
Module 13: Automating SQL Server 2008 R2 Management
Module 14: Configuring Security for SQL Server Agent
Module 15: Monitoring SQL Server 2008 R2 with Alerts and Notifications
Module 16: Performing Ongoing Database Maintenance
Module 17: Tracing Access to SQL Server 2008 R2
Module 18: Monitoring SQL Server 2008 R2
Module 19: Managing Multiple Servers
Module 20: Troubleshooting Common SQL Server 2008 R2 Administrative Issues