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