MENU
Úvod
Kurzy
Maintaining a Microsoft® SQL Server® 2008 R2 Database
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óriách: Microsoft Official Course
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:

29.10. 02.11.2018 Bratislava
990 EUR (bez DPH)
29.10. 02.11.2018 Praha
25 450 CZK (bez DPH)
05.11. 09.11.2018 Brno
25 450 CZK (bez DPH)
05.11. 09.11.2018 Ostrava 25 450 CZK (bez DPH) objednať
12.11. 16.11.2018 Košice 990 EUR (bez DPH) objednať
26.11. 30.11.2018 Praha 25 450 CZK (bez DPH) objednať
26.11. 30.11.2018 Bratislava 990 EUR (bez DPH) objednať
03.12. 07.12.2018 Brno 25 450 CZK (bez DPH) objednať
03.12. 07.12.2018 Ostrava 25 450 CZK (bez DPH) objednať
10.12. 14.12.2018 Košice 990 EUR (bez DPH) objednať
17.12. 21.12.2018 Bratislava 990 EUR (bez DPH) objednať
17.12. 21.12.2018 Praha 25 450 CZK (bez DPH) objednať
31.12.2018 04.01.2019 Brno 25 450 CZK (bez DPH) objednať
07.01. 11.01.2019 Bratislava 990 EUR (bez DPH) objednať
14.01. 18.01.2019 Praha 25 450 CZK (bez DPH) objednať
21.01. 25.01.2019 Brno 25 450 CZK (bez DPH) objednať