SQL test for job candidates

Hi! We're hiring a Database Specialist and want to be able to test job candidates' SQL experience. We found an MS SQL interview test online, but we're wondering if anyone out there in the Tessitura community has an interview test they already use successfully or has any advice to share. Thanks!

Parents
  • I may not end up being the right person for all of you!  I’m Microsoft SQL certified and draw on that training all the time.  I have given code tests to candidates before.  They usually cringe but it’s all good – their ability to tackle that problem is what I’m looking for.  I don’t even give them very hard things to do.  Certainly not certification level work (I’m not cruel)!  I get to see how they’re thinking through what’s actually a simple problem with their nerves sort of in the way.  It’s helpful to see how they communicate what they know and what they don’t know.  I’ve never seen the two as separate.  Their ability to talk under those conditions tells me a lot.  I can work with someone who is clear with their questions at that moment and can articulate and ask good questions.  I find that carries over well once they’re hired.
     
Reply
  • I may not end up being the right person for all of you!  I’m Microsoft SQL certified and draw on that training all the time.  I have given code tests to candidates before.  They usually cringe but it’s all good – their ability to tackle that problem is what I’m looking for.  I don’t even give them very hard things to do.  Certainly not certification level work (I’m not cruel)!  I get to see how they’re thinking through what’s actually a simple problem with their nerves sort of in the way.  It’s helpful to see how they communicate what they know and what they don’t know.  I’ve never seen the two as separate.  Their ability to talk under those conditions tells me a lot.  I can work with someone who is clear with their questions at that moment and can articulate and ask good questions.  I find that carries over well once they’re hired.
     
Children
No Data