What is the afterlife belief of Judaism?

I know there is an "afterlife" because King David himself says so in Psalm 23 "...I will dwell in the house of the Lord forever". So can someone explain to me what is the jewish view of life after here on Earth, according to Judaism?