| | Implementing Replication Using Microsoft SQL Server 2000 |
| Untertitel | Implementing Replication Using Microsoft SQL Server 2000 |
| zeiten | 08:30 - 17:00 Uhr |
| ort | | Das findet in der Schweiz in der Regel in Zürich statt (Technopark, ideal mit Auto und ÖV erreichbar). Bei mehreren Anmeldungen aus Bern oder Basel kann der Kurs auch in unseren Schulungsräumen Bern oder Basel durchgeführt werden. Firmenkurse können in Ihren Räumlichkeiten oder in einem unserer Schulungszentren stattfinden. | Ich wünsche anderen OrtIch habe Frage zum Ort |
|
| Einleitung | This three-day instructor-led course provides students with the knowledge and skills 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. |
| Herstellerkurs | Microsoft Nr. 2591 |
| Ihr Nutzen | After completing this course, students will be able to: - Describe replication.
- Implement replication.
- Implement snapshot replication.
- Implement transactional replication.
- Implement merge replication.
- Implement replication in an Enterprise environment.
|
| Voraussetzungen | Before attending this course, students must have: In addition, it is recommended, but not required, that students have completed, or have equivalent knowledge of: |
| Teilnehmerkreis | 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. |
| Unterlagen | The student kit includes a comprehensive workbook and other necessary materials for this class. |
| Inhalt | Module 1: Exploring Replication - Understanding SQL Server Replication
- Setting up Replication
- Understanding Agents in Replication
- Securing Replication
Module 2: Implementing Replication - Understanding the SQL Server Platform for Replication
- Replicating Data and Objects
- Replicating and Executing Objects
- Designing a Replication Topology
- Troubleshooting a Replication Implementation
Module 3: Implementing Snapshot Replication - Understanding Snapshot Replication Architecture
- Replicating Snapshot Publications Efficiently
- Troubleshooting Snapshot Replication
Module 4: Implementing Transactional Replication - Understanding Transactional Replication Architecture
- Replicating with Transactional Replication
- Implementing Updatable Transactional Replication
- Facilitating Transactional Replication by Using Stored Procedures
- Troubleshooting Transactional Replication
- Tuning Transactional Replication
Module 5: Implementing Merge Replication - Understanding Merge Replication Architecture
- Implementing Conflict Resolution
- Planning and Deploying Merge Replication
- Troubleshooting Merge Replication
- Tuning Merge Replication
Module 6: Implementing SQL Server Replication in an Enterprise Environment - Planning for Disaster Recovery in a Replicated Environment
- Upgrading and Applying Service Packs in a Replicated Environment
- Understanding Enterprise Options in a Replicated Environment
- Understanding Replication with Heterogeneous Database Systems
|
| Teilnehmerbeitrag | Der Teilnehmerbeitrag versteht sich rein netto. Das ZFI ist (gemäss MwSt-Gesetz) nicht Mehrwertsteuerpflichtig und erhebt somit keine MwSt. Bei länger als einen Monat dauernden Lehrgängen ist die Zahlung des Teilnehmerbeitrages in mehreren Raten möglich (pro rata temporis). |
| | Zentrum für Informatik,  Schweiz, Basel, Bern, Zürich
Zentrum für Informatik,  Deutschland, Berlin, Frankfurt, Hamburg, Köln, München, Nürnberg, Stuttgart
Zentrum für Informatik,  Österreich, Wien |
