Keywords or no keywords?

On the one hand I hear about how meta keywords are no longer needed; then all the SEO talk is about keywords. From what I read I get the impression that now we are talking about keywords in <title>. Is that it?