For $800, get 2 pistols. A pistol in 22LR like a used Ruger MK and something in a SD caliber like a S&W M&P or SD series in 9mm. Practice a lot with the 22LR and keep up the skills with the SD caliber.
"You haven't lived until you've died." - various