|
Provided by: 123-CBT Computer Based Training SQL Server 2000 Database Admin Part 4 Managing Data |
 |
Course Overview
This course deals with transferring data, managing replication services, and maintaining high availability.
Learn To
- 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.
Audience
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).
|
|
||||||||||
