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.
"With great power, there must also come great responsibility." - Stan Lee
"All that is necessary for evil to triumph is for good men to do nothing." - Edmund Burke