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

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]