After completing SQL Server 7 Admin: Loading Databases the user should be able to:

	Load data using the INSERT statement
	Load data using the SELECT INTO statement
	Load data using the BCP Utility
	Load data using the Data Transformation Services (DTS)
	Load data using the BULK INSERT command

The INSERT and SELECT INTO Statements

	The INSERT Statement
	The SELECT INTO Statement

Bulk Copying Data

	BCP
	Bulk copying out a table
	BCP format files
	BULK INSERT

Importing and Exporting Data with DTS

	Data Transformation Services (DTS)
	Importing data
	Exporting data
	Transforming data

Managing DTS Packages

	Using DTS packages
	The DTS package designer

This course has the following features:

	Exercises that allow users to practice in SQL Server 7.0
	A file containing the text of the exercises
	Simulations that allow users to practice course skills even if they don't have access to SQL Server 7.0
	A glossary
	A Skill Assessment

	Courses on Relational Database Management Systems or equivalent experience
	Courses on Windows NT administration or equivalent experience
	Courses on Database Concepts or equivalent experience
	Courses on SQL or equivalent experience
	SQL Server 7 Admin: Security Strategy (LA7C01)
	SQL Server 7 Admin: System Requirements (LA7C02)
	SQL Server 7 Admin: Migration Planning (LA7C03)
	SQL Server 7 Admin: Replication Plans (LA7C04)
	SQL Server 7 Admin: Installing the Server (LA7C05)
	SQL Server 7 Admin: Other Installations (LA7C06)
	SQL Server 7 Admin: Configuring (LA7C07)
	SQL Server 7 Admin: Security Management (LA7C08)
	SQL Server 7 Admin: Managing Accounts (LA7C09)
	SQL Server 7 Admin: Managing Permissions (LA7C10)
	SQL Server 7 Admin: Database Management (LA7C11)

Microsoft® is a registered trademark of Microsoft Corporation.