Maintaining a Microsoft SQL Server 2008 Database

Seminarziel

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

Zielgruppe

This course is intended for IT Professionals who administer and maintain SQL Server databases.

Seminarinhalte

Module 1: Installing and Configuring SQL ServerModule 2: Managing Databases and Files
Module 3: Disaster Recovery
Module 4: Managing Security
Module 5: Transferring Data
Module 6: Automating Administrative Tasks
Module 7: Implementing Replication
Module 8: Maintaining High Availability
Module 9: Monitoring SQL Server
Module 10: Troubleshooting and Performance Tuning

Voraussetzungen

o Basic knowledge of the Microsoft Windows operating system and its core functionalityo Working knowledge of Transact-SQL
o Working knowledge of relational databases
o Some experience with database design