Profile


e-Catalog


Contact

Search

Cart
Microsoft SQL Server 2000 Database Administration II: Transferring and Transforming Data in SQL Server 2000

Course Status: Released Courseware Features
Course Language: English  
Course Duration: 5 Hours  
Deployment Options: Online, Interactive CDs, Network, Downloads, Intranet  

Audience
Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
Prerequisites
Experience working in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition; at least one year?s experience administering SQL Server; at least one year?s experience implementing relational databases in environments that contain heterogeneous databases, SQL Server security integrated with Windows Authentication, client/server configurations of 50 to 50,000 or more users, web configurations that use Internet Information Services (IIS) or COM+, databases as large as 2 TB, and multiple installations of SQL Server 2000
Course Aim
This learning path describes in detail the basic configuration and administration of Microsoft SQL Server 2000.
Learning Objectives
To enable students to extract and transform data in SQL Server 2000
Topics Covered
Data Transformation Services
SQL Server 2000 data transformation overview
Creating a linked server using SQL Server 2000
SQL Server 2000 data transformation tools
Transferring data in SQL Server 2000
Creating DTS packages in SQL Server 2000
Transforming data with DTS in SQL Server 2000
SQL Server 2000 BCP and BULK INSERT
Transferring data with BCP in SQL Server 2000


About Eno.com | Help | Terms of Use | Site Search | Contact Us | Site Map
Copyright © 1996-2002 E&A Inc. All rights reserved.