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áze → Microsoft SQL → MS 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) | objednať |
| 29.10. – 02.11.2018 |
Praha
|
25 450 CZK (bez DPH) | objednať |
| 05.11. – 09.11.2018 |
Brno
|
25 450 CZK (bez DPH) | objednať |
| 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ť |