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.
The course is included in the following category: |
Databáze → Microsoft SQL → MS SQL 2005/2008 Microsoft |
Difficulty of the course: Advanced
Course duration: 5 days
Contents of the course:
- 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
Expected knowledge: 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.
.Course dates:
This course is no longer in our offer. For more information or if you are interested in contact us at skoleni@pcdir.cz a > or phone +420 543 533 610.