SQL Server 2005 E-Learning Courses
If you are looking at a quick resource to get you started on core SQL Server 2005 topics, then this site could be for you. Microsoft has a series of 9 E-Learning courses around SQL Server 2005 that are free and can be accessed from here. Basically, you can view the courses either online or offline (although offline did not work for me, since the download just got stuck in-between). The online version is pretty good, except that the labs require connection to hosted environments which did not work for me. I also did not really expect them to work, since the performance may be a bit slow and I can anyways replicate the exercise on my local build of SQL Server 2005.
Overall, the content is good (with a few typos here and there :-)), but it is worthwhile for the content coverage and will serve as a quick start guide to getting upto speed on SQL Server 2005 (I just finished around 50% of the .NET Integration course). Have fun!