Maintaining a Microsoft® SQL Server® 2008 R2 Database (MOC6231)

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 product features and tools related to maintaining a database.

Náročnosť kurzu: pokročilý

Délka kurzu: 5 dní

Náplň kurzu:

• 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 Databases
• Importing and Exporting Data
• Authenticating and Authorizing Users
• Assigning Server and Database Roles
• Authorizing Users to Access Resources
• Auditing SQL Server Environments
• Automating SQL Server 2008 R2 Management
• 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

Predpokladané znalosti: 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.

Termíny kurzu: