Microsoft e-Learning offers a lot of free online courses for Visual Studio 2005 and SQL Server 2005 until November 8th and 1st 2005 respectively. There is a lot of content there, so go ahead and check it out. All you need is a Microsoft PassPort to be able to login. The requirements for your pc are relaxed.
The material comes with videos, stuff to read, tests and progress overviews. One of the coolest things is the virtual labs that you can take, where you do exercises in a Virtual Server session. You connect to this session with an ActiveX control rather like a Terminal Server/Remote Desktop session. You definitely need to check that out!