SQL Profiler tutorials for newbie
Try this free book from redgate:
http://www.sqlservercentral.com/blogs/aloha_dba/archive/2009/01/21/mastering-sql-server-profiler-e-book-available-for-free.aspx

Brad McGee also has some videos on his website:
http://www.bradmcgehee.com/videos/

This video on technet:
http://technet.microsoft.com/en-us/sqlserver/ee861095

This site also has more general SQL Server video tutorials (and a few profiler ones)
http://www.sqlshare.com/channel.aspx?cat=96b0a352-6498-dd11-bebd-001143eb4af9