Tutorials for mappers also check this topic and try to watch the performance of the map, enter your name, music etc. Place proper lighting/textures and watch the bsp!
(Ice) textures (effects)
A lot of tutorials(tip: get The Complete Unreal Ed Reference Guide (TCUERG))*
Basic shape tutorial->recommended*
Tutorial: Unreal1 terrain
Tutorial: rolling screenshots
Playlist of vid tutorials for Unealed2.0
Many tutorials at BB Drac
Wav to .umx (music coverting)
Building Geometry BSP
Building Geometry BSP 2
UDN: the shape editor
hourences book about Gameplay, Lighting and more
For stats/debugging/console commands etc.
Usefull links for any kind of development (scripting/modelling etc.!)
As for the rest you have to search for yourselves and ask on ut99.org they are pretty helpfull.