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.
| Der Kurs ist der Kategorie zugeordnet: |
Databáze → Microsoft SQL → MS SQL 2005/2008 Microsoft |
Kursstufe: Fortgeschritten
Course duration: 5 days
Kursinhalt:
- 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
Erforderliche Kenntnisse: 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.
.Kurstermine:
Das ist natürlich nicht mehr in unserem Angebot. Für weitere Informationen oder wenn Sie Interesse an der Durchführung kontaktieren Sie uns unter skoleni@pcdir.cz oder Telefon +420 543 533 610.