Here are a few links that provide video training on SQL Server. PluralSight is very well known for it’s quality videos. However there is another site that has SQL Server training videos that you can download to your iPod or iPad or Android device that will allow you to watch them completely offline:
The best one I’ve found so far is on SQLSkills.com: Free Online SQL Server MCM / MCSM Training Videos
also:
Free SQL Server Video Tutorials and Training
Views – 1896