|
|
 |
Microsoft SQL Server 2000
Implementing Replication Using Microsoft SQL Server 2000 (2591)
|
|
|
Who Should Attend
| This course is intended for experienced database administrators and system architects who want to improve their skills and the replication capabilities of their systems. Students should be proficient in the design and administration of SQL Server 2000 systems. |
Prerequisites
| Students must have completion of courses (2071) Querying Microsoft SQL Server 2000 with Transact-SQL, and course (2072) Administering a Microsoft SQL Server 2000 Database, or have equivalent knowledge. Knowledge of Microsoft Windows 2000 basic and Window networking fundamentals is also required. In addition, it is recommended, but not required, that students have completed, or have equivalent knowledge of course (2073) Programming a Microsoft SQL Server 2000 Database. |
Course Objectives
| This course provides students with the necessary knowledge and skills required to plan, deploy, administer, manage, and troubleshoot complex replication designs over a variety of communication topologies. The course reviews SQL Server replication and then focuses in detail on snapshot, transactional, and merge replication as well as topics related to Enterprise-level replication.
|
|
|
| Students primarily learn how to describe replication, implement replication, implement snapshot replication, implement transactional replication, implement merge replication and implement replication in an enterprise environment . |
Course Content
| 1. Exploring Replication
|
| 2. Implementing Replication
|
| 3. Implementing Snapshot Replication
|
| 4. Implementing Transactional Replication
|
| 5. Implementing Merge Replication
|
| 6. Implementing SQL Server Replication in an Enterprise Environment |
|
|
|
|
Top