Anyone interested in any aspect of Microsoft Business Intelligence should frequently visit (better yet pin to your favorites) these great (FREE!) training resources:
Pragmatic Works Training on the T's
A live interaction every Tuesday and Thursday at 11am EST. Previous webinars are also cached for your enjoyment as well:
Blue Granite's CTO Rock Star Rob Kerr
A cornucopia of over 100 video snippets ranging from 3-10 minutes each in an easy to find page with how-to's on everything from a SQL UPDATE statement to step-by-step installation of an entire VM environment.