My Brother has had traumatic events with alcohol in the past. He said he quit (over a year now) by reading Allen Carr's Easy Way to Quit Drinking. Specifically the self-hypnosis audio at the end, he said he did it once while going to sleep.
He'll have a non-alcoholic beer rarely but I don't pry.