For card tricks, start off with either Royal Road to Card Magic or Card College. You'll have a few months of practice material right there, from the two best beginner's card magic books around, period.
For Flourishes, try Xtreme Beginners DVD, I don't know about Showoff with Cards, but you can also get The Encyclopedia of Playing Card Flourishes, possibly the most comprehensive out there.