We have interviewed a lot of candidates and found out that SQL is still something which is very less explored by people who want to get deep into this domain.
Remember – Data Science is not about all about SQL, but it’s a bread and butter for most of the jobs irrespective of your profile.
This is a small post which will cater around the ways to master your SQL skills.
I am assuming that you are a complete noob in SQL, skip according to your expertise
1. Start with either w3school or tutorials point.
It should not take more than 8-10 hours for you to complete the tutorial(irrespective of your Engineering branch/ current domain)
2. Go for SQLZoo. Solve all the questions.
If you get stuck, then try this link which have all the solved questions. Should take you somewhere 15 hours
3. Once this is done, create an account on HackerRank and try there SQL course.
Try all the easy questions first and then slowly move to the medium level questions. It should not take you more than 20 hours, earn a 4 star at least before moving ahead and do follow the discussion panel
If you are good with the above 3, then do try our four pages(This is not a self promotion, but we have hand picked some of the important questions which you should definitely solve before your interview)
https://thedatamonk.com/day-3-basic-queries-to-get-you-started/
https://thedatamonk.com/day-4-sql-intermediate-questions/
https://thedatamonk.com/day-5-sql-advance-concepts/
https://thedatamonk.com/day-6-less-asked-sql-questions/
You are already interview ready, send me a mail at nitinkamal132@gmail.com or contact@thedatamonk.com to get a free copy of our ebook or purchase it on Amazon
https://www.amazon.in/Questions-Crack-Business-Analyst-Interview-ebook/dp/B01K16FLC4
https://www.amazon.in/Write-better-queries-interview-Questions-ebook/dp/B076BXFGW1
You are not done yet, complete that HackerRank Hard Questions as well.
This will suffice the knowledge which you need to crack any Data Science SQL interview round.
For Python,R, and statistics we will have separate post.
Keep Learning 🙂
The Data Monk
