Actually new to the video edit game period

Im tired of waiting on someone to put a clip together for me so i can send it to sponsors and so on... so im gonna learn the game myself.
Btw... im completly clueless.. ive got the computer to do it... also all the software... photoshop cs2 for picture editing ( clueless on that too ) vegas 6 and adobe after effects.. im all clueless.. ive been searching online for video tutorials found some on vegas.. but the guy is just... lame?? i dunno hes smart and all but its like that faris beuler movie... Beuler.. Beuler... not learning much..
i dont even know how to get the video from the camera to the computer.. i know i know... its gonna be rough but im gonna learn it someway.
got the cable and all. When i go to file and capture video it does nothing.. im doing something wrong??
help guys
Thanks.