MENU
Introduction
CoursesCourses
Maintaining a Microsoft® SQL Server® 2008 R2 Database
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 categories: Microsoft Official Course
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:

17.12. 21.12.2018 Praha
25 450 CZK (without VAT)
17.12. 21.12.2018 Bratislava
1 000 EUR (without VAT)
31.12.2018 04.01.2019 Brno
25 450 CZK (without VAT)
07.01. 11.01.2019 Bratislava 1 000 EUR (without VAT) Order
14.01. 18.01.2019 Praha 25 450 CZK (without VAT) Order
21.01. 25.01.2019 Brno 25 450 CZK (without VAT) Order