Brian Knight, one of the brain children behind SQL Saturday and one heck of a SQL guru has a video on the basic use of SQL Server Management Studio. If you’re new to SQL as part of an implementation of Dynamics GP, this video is worth a look. You’ll definitely learn some SQL Studio basics.
SQL Server Management Studio for Beginners
SQL & DataInstall, Upgrade & Admin
Archived post from 2009. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.