The most important thing is to shake the notion that "it can never happen here." That train of thought more than anything else on the part of the victims, gets people killed. Those who refuse to accept the possibility of such situations leave themselves on autopilot when they occur, not bothering to think for themselves and adapt to the situation.
Ayoob is a good idea. Another is DeBecker.
https://www.gavindebecker.com/index.cfm
His book The Gift of Fear is a good analysis of many different types of threats, with valuable space given to rampage killers (your main fear). While he has some definite anti leanings (not for his trained employees mind you...) he is worth taking in for what he can offer. Since even the idea of armed resistance is out of the question with SUNY he may be your best choice.