Register Now

Login

Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Login

Register Now

It will take less than 1 minute to register for lifetime. Bonus Tip - We don't send OTP to your email id Make Sure to use your own email id for free books and giveaways

How to prepare SQL for Analytics Jobs in 15 days?

Which is the most important concept you need prepare for Analytics Jobs ?
SQL

In this post we will try to help you on providing all the resources needed to cover SQL from very basic to advance level.

How to prepare SQL for Analytics Jobs?

Total time required to prepare – 15 days
Daily time to invest – 3 to 4 hours

prepare SQL for Analytics Jobs

SQL Topics to cover

  • All the basic syntax
  • Window functions
  • Complex queries
  • Interview questions

SQL resources

  • SQLZoo
  • Tutorials Point
  • The Data Monk
  • Youtube videos
  • Hacker Rank

Day wise schedule

Day 1 and 2 – Go to Tutorials Point and cover the complete tutorial in 4-6 hours, as quickly as you can

Day 3 and 4 – Using the same knowledge, go to SQLZoo and solve at least 30-40 questions, these questions are very basics. It will enhance your knowledge

Day 5,6 and 7 – Go through any video on Youtube for advance questions. We felt that there are not a lot of videos in a sequential order, so we have created one (Check the videos which you have not prepared till now, mostly window functions) – Cover 6-8 videos per day

List of videos

  1. Fetch Duplicate Rows in SQL – https://youtu.be/MGHNrxsHKcg
  2. Like Operator in sql – https://youtu.be/IqMMbH6Jw0w
  3. Substring and Replace in SQL – https://youtu.be/Pzb9tBdXKyc
  4. Aggregate Functions in SQL – https://youtu.be/6H5neKpUz9E
  5. Cumulative Sum in SQL – https://youtu.be/COEEGPXjNbk
  6. Row number() in SQL – https://youtu.be/1actE8UL4yM
  7. Ntile() – https://youtu.be/xbjyXk7oSdY
  8. Rank vs Dense Rank – https://youtu.be/f32Yne_4G00
  9. Where vs Having – https://youtu.be/rtZpbyyQtVk
  10. Lead and Lag – https://youtu.be/U_OQD3XpagQ
  11. Joins – https://youtu.be/_V38OgS1s5M
  12. Keys – https://youtu.be/yPZG6qurO_Q
  13. 1NF and 2NF – https://youtu.be/7CyxIOj9zTs
  14. 3 NF and BCNF – https://youtu.be/VuJ7gnaas5k
  15. Most Asked Interview Questions – https://youtu.be/UGTsPRUIkYg
  16. Odd even rows – https://youtu.be/-tLTAuvHAU0
  17. Delete vs Truncate vs Drop in SQL – https://youtu.be/cSM86aZRhMo
  18. SQL Tricky Analytics Interview Questions – https://youtu.be/MRgZKeYx1NY
  19. Binary Tree in SQL – https://youtu.be/oAD-YUafmB8
  20. Joins Advance Interview Questions – https://youtu.be/pf_RdiCBQw4
  21. Facebook SQL Interview Questions – https://youtu.be/LDYdcH82IO0
  22. Tricky SQL Interview Questions  Part 2 – https://youtu.be/B8Zy9bcqai0

Day 8 and 9 – Go to Hacker Rank and solve Medium difficulty problems (15-20)

Day 10,11 and 12 – Solve as many questions as possible from our list of interview questions
List of 200+ questions

Day 13,14 and 15 – If you feel you need to practice more then get our 10 e-books bundle and solve as many questions as possible from the SQL book, also go through Python and Statistics to revise the concept.
This is completely optional and you can revise it even before your interview, but its always better to start early and beat the race

Link to the 10 e-book bundle



We assure you that if you spend 15 days as mentioned above, you will turn into a really good candidate in any SQL interview

About TheDataMonkGrand Master

I am the Co-Founder of The Data Monk. I have a total of 6+ years of analytics experience 3+ years at Mu Sigma 2 years at OYO 1 year and counting at The Data Monk I am an active trader and a logically sarcastic idiot :)

Follow Me

Leave a reply