Here's a list of tutorials for your use. If you to post a tutorial of something you've made or find a website with tutorials, please post in this thread and I will post a link to it here!
Techniques
Piping tutorial by fabric_addict
BurdaStyle - free sewing patterns (some are not free) and step-by-step photo tutorials (under "how tos")
Savvy Seams - free sewing patterns and technique tutorials
Threads Tips and Tricks
Free Patterns (also tutorials with no pattern needed)
Twirl Skirt tutoral from Sews4kate
BurdaStyle - free sewing patterns (some are not free) and step-by-step photo tutorials (under "how tos")
Write, mama, write - many tutorials and patterns for clothing and craft items
Savvy Seams - free sewing patterns and technique tutorials
Other
http://www.embroiderylibraryprojects.com/ - embroidery designs