This course shows users how to load data from other sources into SQL Server databases.
Objectives:
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
Topics:
The INSERT and SELECT INTO Statements
Bulk Copying Data
Importing and Exporting Data with DTS
Managing DTS Packages
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
