Managing Data Between Servers and Databases

This course is included in our On-demand training solution.

Overview

To recognize how to manage change, configure and work with linked servers, and manage and tune replication in SQL Server 2005

Target Audience

Professionals pursuing a career as a Database Administrator

Prerequisites

Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005.

Expected Duration

150 min.

Course Objectives

Managing Data Between Servers and Databases

  • identify considerations for managing change in the SQL Server 2005 environment, given a scenario.
  • determine the appropriate change control strategy for a given scenario.
  • recognize how to configure a linked server in a given scenario.
  • recognize how to query data on a linked server in a given scenario.
  • work with linked servers in a given scenario.
  • recognize how to monitor replication in a given scenario.
  • recognize how to modify replication configuration and resolve replication conflicts in a given scenario.
  • tune a replication configuration in a given scenario.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?