MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition

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