MENU
Úvod
Kurzy
Maintaining a Microsoft® SQL Server® 2008 R2 Database
zájem 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 zařazen v kategoriích: Microsoft Official Course
DatabázeMicrosoft SQLMS SQL 2005/2008
Microsoft

Náročnost 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

Předpokládané 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:

17.12. 21.12.2018 Praha
25 450 Kč (bez DPH)
17.12. 21.12.2018 Bratislava
1 000 EUR (bez DPH)
31.12.2018 04.01.2019 Brno
25 450 Kč (bez DPH)
07.01. 11.01.2019 Bratislava 1 000 EUR (bez DPH) objednat
14.01. 18.01.2019 Praha 25 450 Kč (bez DPH) objednat
21.01. 25.01.2019 Brno 25 450 Kč (bez DPH) objednat