i used two books:
1. Getting Started with Stata for Windows, by STATA
2. Statistics with Stata (Updated for Version 10). Lawrence C. Hamilton. I personally think this is still the best guide so far.
As mentioned by people above, the key is to read through the books while practicing using the examples provided in the books.