• 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.