|
Provided by: 123-CBT Computer Based Training SQL Server 7 0 System Administration - Part 5 |
 |
Training
Provided by 123-CBT Computer Based Training
Course Overview
This is the final course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.
Learn To:
- Identify the methods and attributes of SQL Server 7.0 replication.
- Identify and apply techniques for planning and setting up SQL Server 7.0 replication.
- Identify the procedures for replication maintenance.
Content Emphasis
Skills-Based
Audience
This course is designed for IT professionals responsible for installing, configuring, administering and troubleshooting Microsoft SQL Server 7.0. Participants should have completed the first four courses in this series.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Replication Basics
Duration: 2 - 3 Hour(s)- Identify the benefits of distributed data.
- Identify important considerations in data distribution.
- Match the distributed data method with its attribute.
- Identify the dynamic of the Publisher-Subscriber relationship.
- Choose the appropriate attributes of Articles and Publications.
- Match the data filtering method with its appropriate attributes.
- Identify the attributes of push and pull subscription methods.
- Match the replication agent with its appropriate attributes.
- Identify conflict resolution attributes.
- Analyze and label the components of the merge replication process.
- Analyze and label the components of the snapshot replication process.
- Analyze and label the components of the transactional replication process.
- Analyze and label the components of various replication models.
- Analyze and label the various types and models of replication.
- Analyze and label the components of a single publisher diagram.
- Analyze and label the components of a single subscriber diagram.
- Analyze and label the components of a multiple publisher diagram.
Unit 2: Replication Planning Considerations
Duration: 2 - 3 Hour(s)- Identify valid design considerations in implementing replication.
- Identify valid replication solutions.
- Identify the attributes of various data types.
- Identify important issues in network security.
- Perform the steps to set up a Distributor.
- Perform the steps to configure distribution database properties.
- Perform the steps to set publisher options.
- Perform the steps to enable and modify subscriber properties.
- Identify important issues in database publishing.
- Perform the steps to create publications.
- Identify the attributes of publication initialization.
- Perform the steps to set up a push subscription.
- Perform the steps to set up a pull subscription.
- Perform the steps to use the Immediate Updating Subscribers option.
Unit 3: Replication Management
Duration: 2 Hour(s)- Identify the uses of the replication monitor.
- Match the maintenance strategy with the appropriate attributes.
- Identify the benefits of using replication scripts.
- Match the replication system components with appropriate system stored procedures.
- Use the replication monitor to view agent histories.
- Use the SQL Server Query Analyzer to test connectivity.
- Identify the ODBC driver requirements for SQL Server replication.
- Use replication wizards to publish data to heterogeneous subscribers.
- Identify features of the SQL-DMO object structure.
- Perform the steps to script a replication topology.
- Perform the steps to publish on the Internet utilizing snapshot replication.
|
|
||||||||||
SQL Server 7 0 System Administration - Part 5
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
