It sounds like a custom job application technical test, are you able to post the job description for the role you're applying for please? That may shed some light on the skills required (and we can all weigh in with book suggestions and URLs)...
---
Note to developers:Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.