Terms you'll need to understand:
BCP
DTS
OPENXML
SELECT
WHERE
GROUP BY
HAVING
ORDER BY
COMPUTE
XML
Schema
Cursor
Lock
INTO
INSERT
DELETE
UPDATE
Techniques you'll need to master:
Importing and exporting data
Manipulation of data from various sources
Data retrieval, filtering, grouping
Summarizing data
Data modifications
Utilizing XML options