Terms you'll need to understand:
Query Analyzer SQL Profiler System Monitor Trace Filter Execution plan Query Optimizer Techniques you'll need to master:
Viewing current activity Tracing activity over time Utilizing the System Monitor Tracing operations with the SQL Profiler Diagnosing execution plans Troubleshooting locking behavior