Informationen über Kurs 73478 - Microsoft SQL Server 2000 Database Administration Part 4: Managing Data - Online
-
Ziele
- Identify guidelines for importing and exporting data. - Match SQL Server 2000 tools used to import and export data with their functions. - Identify the features and functions of the Data Transformation Services (DTS) process. - Identify the features of distributed data. - Identify the different methods of distributing data. - Identify the features of the publisher-subscriber metaphor. - Identify the features of the Database Maintenance Plan Wizard. - Troubleshoot a database by using the Database Consistency Checker (DBCC). - Identify the guidelines for performing a Database Consistency Checker (DBCC) SHOWCONTIG.
-
Anforderungen
Candidates for this exam operate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. General categories include system administrators, database administrators, application developers, systems analysts, and software engineers. Students are expected to have an understanding of basic relational database concepts. Students should be familiar with basic transact-SQL syntax. (Microsoft Course 2071: Querying Microsoft SQL Server 2000).
-
Titel
Kurs 73478 - Microsoft SQL Server 2000 Database Administration Part 4: Managing Data
-
Inhalt
Course Overview
This course deals with transferring data, managing replication services, and maintaining high availability.
Deployment Options
Self-Study
Accreditation
CEU credits: 0.70 CEUs
Total Learning Time
6 to 8 hours
Objectives
Unit 1: Transferring Data 2 - 3 hours
- Identify guidelines for creating a Data Transformation Services (DTS) package.
- Import data into SQL Server 2000 by using the Bulk Insert Task.
- Import data from a Transact-SQL (T-SQL) Query.
- Modify a Data Transformation Services (DTS) package by using DTS Designer.
- Transfer SQL Server 2000 objects.
- Identify requirements for configuring linked servers.
- Identify the characteristics of XML support in Internet Information Services (IIS).
- Identify guidelines for importing and exporting data.
- Match SQL Server 2000 tools used to import and export data with their functions.
- Identify the features and functions of the Data Transformation Services (DTS) process.
- Identify the features and functions of Data Transformation Services (DTS) tools.
- Identify guidelines for managing data.
- Identify the functions of data transformation and mapping.
Unit 2: Replication Services 2 - 3 hours
- Identify the features of distributed data.
- Identify the different methods of distributing data.
- Identify the features of the publisher-subscriber metaphor.
- Identify the characteristics of publications and articles.
- Match filtering methods with their functions.
- Identify the different ways of subscribing to a publication.
- Identify the features of the different replication agents.
- Match the replication types with their characteristics.
- Identify features of merge replication.
- Identify features of different physical replication models.
- Identify features of a Central Publisher/Remote Distributor model.
- Identify features of a Central Subscriber/Multiple Publishers model.
- Identify features of a Multiple Publishers/Multiple Subscribers model.
- Register a SQL Server.
- Create a publication.
- Create a subscription.
- Verify that a change to a published article has been updated on the subscriber.
Unit 3: Maintaining High Availability 2 hours
- Identify the features of the Database Maintenance Plan Wizard.
- Troubleshoot a database by using the Database Consistency Checker (DBCC).
- Identify the guidelines for performing a Database Consistency Checker (DBCC) SHOWCONTIG.
- Identify the features of Windows clustering.
- Identify the features of SQL Server 2000 failover clustering.
- Identify the features of active/passive clustering.
- Identify the features of active/active clustering.
- Identify the considerations for failover clustering.
- Identify the features and functions of standby servers and log shipping.
- Sequence the steps to prepare the Primary and Standby servers.
- Identify the guidelines for configuring log shipping.
- Sequence the steps to configure the Primary server.
- View the log shipping pair properties.
- Identify the characteristics of the process for changing log shipping roles.
- Change the role of the Standby server.
Course Access
Each student has access to the course for a period of 6 months from the day of enrollment in the course.
