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 to prepare for Analytics Jobs?
SQL

In this post, we will try to help you by 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 basic. 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 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

The Data Monk services

We are well known for our interview books and have 70+ e-book across Amazon and The Data Monk e-shop page . Following are best-seller combo packs and services that we are providing as of now

  1. YouTube channel covering all the interview-related important topics in SQL, Python, MS Excel, Machine Learning Algorithm, Statistics, and Direct Interview Questions
    Link – The Data Monk Youtube Channel
  2. Website – ~2000 completed solved Interview questions in SQL, Python, ML, and Case Study
    Link – The Data Monk website
  3. E-book shop – We have 70+ e-books available on our website and 3 bundles covering 2000+ solved interview questions. Do check it out
    Link – The Data E-shop Page
  4. Instagram Page – It covers only Most asked Questions and concepts (100+ posts). We have 100+ most asked interview topics explained in simple terms
    Link – The Data Monk Instagram page
  5. Mock Interviews/Career Guidance/Mentorship/Resume Making
    Book a slot on Top Mate

The Data Monk e-books

We know that each domain requires a different type of preparation, so we have divided our books in the same way:

1. 2200 Interview Questions to become Full Stack Analytics Professional – 2200 Most Asked Interview Questions
2.Data Scientist and Machine Learning Engineer -> 23 e-books covering all the ML Algorithms Interview Questions
3. 30 Days Analytics Course – Most Asked Interview Questions from 30 crucial topics

You can check out all the other e-books on our e-shop page – Do not miss it


For any information related to courses or e-books, please send an email to [email protected]

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