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.
| Kurz je zaradený v kategóriách: |
Microsoft Official Course Databáze → Microsoft SQL → MS SQL 2005/2008 Microsoft |
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: