Create databases, tables, indexes, views, stored procedures, triggers, and database diagrams.

Run queries directly in the database with the query analyzer.

Duplicate and distribute data through merge and transactional replications.

Create data warehouses using the OLAP Manager, and learn about the features of this tool.

Transform data using Data Transformation Services.

Learn Proper backup and restoration procedures.