Written Tutorials
Here are links to various written tutorials which I hope will be of interest for those who prefer that format. Thank you for the contributions. If you have some interesting links which would fit here, perhaps add a comment.
Modelling / Rendering
A beginner friendly guide to making some objects for a still life scene and rendering in cycles
Modelling / UV Mapping
Modelling and unwrapping a Low poly T-Rex
http://cg.tutsplus.com/tutorials/blender/modeling-uvmapping-and-texturing-a-low-poly-t-rex-in-blender-part-1/
Particles
Quite a nice dissolve effect
http://blenderdiplom.com/index.php/en/tutorials/item/78-tutorial-dissolve-your-logo-in-blender-262
A collection of video and PDF tutorials.
http://gryllus.net/Blender/3D.html
Some tutorials on using mechanics in Blender. Although some for older versions of Blender (2.49) the concepts should be portable to newer versions.