Learn about basic OS X applications
Solution 1:
David Pogue's book Switching to the Mac: The Missing Manual, Snow Leopard Edition is highly recommended. As you can tell from the title, it's designed to explain Snow Leopard to people who are coming from Windows. It's 650 pages.
There is a second, larger (900 pages), and more comprehensive book from David Pogue called Mac OS X Snow Leopard: The Missing Manual which is not aimed at Windows users and goes into greater depth about how to use Snow Leopard's features.
Solution 2:
The Mac 101 on Apple website seems like a good place to start.
And of course, Ask Different.
Solution 3:
Mac OS X is a Unix based system. Most Linux command line tutorials will work for Mac. Here is a really good one that I used. You could search for Bash, Shell, Mac command-line, etc.