MENU
Úvod
Kurzy
Maintaining a Microsoft® SQL Server® 2008 R2 Database
Archiv záujem o kurz

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órii: DatabázeMicrosoft SQLMS 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:

Tento kurz už nie je v našej ponuke. Pre viac informácií alebo ak máte záujem o realizáciu nás kontaktujte na skoleni@pcdir.cz alebo telefónu +420 543 533 610.