TSQL for Beginners (Redgate University)
This free course introduces you to the Transact SQL language implemented in SQL Server and takes you from newbie to a master of SELECT statements.
The course contains 8 classes with more than 7.5 hours of video content.