I have recently completed the development of a new fundamental course about SQL Server 2008. If you are doing your first steps this is the course you want to take. You will learn the basic SQL commands and you will learn how to execute them when using the SQL Server 2008. The course is available for free personal usage at www.abelski.com and it includes slides, video clips, forums and assignments.
The video clips that were developed for this course are available for free personal usage in my SQL Server dedicated YouTube play list.