What are good resources to learn USEFUL mandarin?

Although Rosetta Stone teaching methods are very good, the material there is not useful unless you can talk about, your black dog that eats bread.
Therefore I’d like to once again emphasize USEFUL resources.