![]() |
Profile |
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 |