MENU
Introduction
CoursesCourses
Maintaining a Microsoft® SQL Server® 2008 R2 Database
Archive Interest in course

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ázeMicrosoft SQLMS 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 or phone +420 543 533 610.