Sacred Heart University Senior Programmer Analyst interview questions

Applied through the university's website. Got a phone call to schedule an interview early in the morning. I was interviewed by the hiring manager and he gave me a short SQL test: left/right joins, pivot tables and select records from one table that do not exist in the other. If you had a good interview with the hiring manager, you get to be interview by the IT director which basically goes over your resume with no technical questions. After this interview, if they believe you're a potential candidate you will be interview by the VP of Information Technology.