Free Video Training (3DBuzz)

There's free video training on 3dbuzz.com for the following:

Half Life 2 Level Design
PHP + MySQL
Unreal Technology
Concept Art Design

There's quite a lot of training you can pay for on the site such as :
C++
Maya
3DS Max
XSI
Houdini
Photoshop
Lightwave
Quake III editing
Far Cry editing
and more....

There's also a very good forum for all of the systems mentioned above, and more.