MOC 6231 (B) Maintaining a Microsoft SQL Server 2008 R2 Database

    

Summary:
This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to maintaining a database.

Duration:
5 Days/Lecture & Lab

Audience:
The primary audience for this course is individuals who administer and maintain SQL Server databases. This course can also be helpful for individuals who develop applications that deliver content from SQL Server databases.

Topics:

• Introduction to SQL Server 2008 R2 and its Toolset
• Preparing Systems for SQL Server 2008 R2
• Installing and Configuring SQL Server 2008 R2
• Working with Databases
• Understanding SQL Server 2008 R2 Recovery Models
• Backup of SQL Server 2008 R2 Databases
• Restoring SQL Server 2008 R2 DatabasesThis module describes the restoration of databases.Lessons
• Importing and Exporting Data
• Authenticating and Authorizing Users
• Assigning Server and Database Roles
• Authorizing Users to Access Resources
• Auditing SQL Server Environments
• Configuring Security for SQL Server Agent
• Monitoring SQL Server 2008 R2 with Alerts and Notifications
• Performing Ongoing Database Maintenance
• Tracing Access to SQL Server 2008 R2
• Monitoring SQL Server 2008 R2
• Managing Multiple Servers
• Troubleshooting Common SQL Server 2008 R2 Administrative Issues

Prerequisites:
-Basic knowledge of the Microsoft Windows operating system and its core functionality.-Working knowledge of Transact-SQL.-Working knowledge of relational databases.-Some experience with database design.-Completed Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Last Update: February 7, 2012