Bill MacKenty


Interviewing for a data manager

Posted in Educational Tech Design Leadership on 11 - October 2010 at 10:59 AM (12 years ago). 12 views.

If you work in schools, you know this person. They enter / edit / delete information from you Student Information System. They keep the data clean, they write SQL, they run diff's, yadda yadda. We are interviewing for this position at my school and I'm asking some fairly straight forward technical questions, so I can ascertain the technical competence of the people applying for the job. 1. Using SQL, how do you select data from multiple tables? 2. Using SQL, how do you identify unique records? 3. Please look at this regular expression. [0-9] what would this find? 4. Please provide an example how you compare two different tables? 5. Do you know any shell / script programming? Give me an example of a shell / script program you've written. 6. How do you identify duplicate data in your tables? These strike me as fair questions, no "gotchas", and reasonable. Why are the applicants having such a hard time answering these questions?