It's different with every department. Where I grew up, the police got regular training and were able to deal with things sensibly. They all had hand-to-hand training as well, and the knowledge that they could break all the bones in your fingers with their little key-chain thingy kept you from talking back. Since I've lived in L.A. city, it's either just nasty attitude or deadly force. And they can't unholster in any reasonable time (zero training or practice), so they usually have their iron out and ready to go when they should just be talking, or observing. We've lived in
Rampart Division since 1989, so I know more than I wish I did about our local boys in black.
Try joining an online cop forum - You will be disgusted by the crap they are willing to share when they think only brother officers are looking. Anyway, all you need to do is watch cops shooting when they are at the range to know how much (very little) training they get.