|
|
 |
Microsoft SQL Server 2005
Maintaining a Microsoft SQL Server 2005 Database (2780)
|
|
|
Who Should Attend
| This course is intended for IT professionals wanting to become skilled on SQL Server 2005 features and technologies to maintain a database. |
Prerequisites
| Before attending this course, students must have basic knowledge of the Microsoft Windows operating system and its core functionality. They should also have working knowledge of Transact-SQL and relational databases, and have some experience with database design. It is recommended, but not required, that students have completed Writing Queries Using Microsoft SQL Server Transact-SQL (2778), and Implementing a Microsoft SQL Server Database (2779). |
Course Objectives
| This course provides students with the knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.
|
|
|
| After course completion, students will be able to install and configure SQL Server 2005, manage database files, and security, and perform administrative tasks. Additionally, students will be able to backup and restore databases, monitor and troubleshoot SQL Servers, transfer data and maintain high availability. |
Course Content
| 1. Installing and Configuring SQL Server 2005
|
| 2. Managing Databases and Files
|
| 3. Managing Security
|
| 4. Disaster Recovery
|
| 5. Monitoring SQL Server
|
| 6. Transferring Data
|
| 7. Automating Administrative Tasks
|
| 8. Maintaining High Availability
|
| 9. Introduction to Replication |
Dates Europe
To book a course, please click on the required city name.
Germany
|
|
|
|
Stuttgart