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
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
- Fetch Duplicate Rows in SQL – https://youtu.be/MGHNrxsHKcg
- Like Operator in sql – https://youtu.be/IqMMbH6Jw0w
- Substring and Replace in SQL – https://youtu.be/Pzb9tBdXKyc
- Aggregate Functions in SQL – https://youtu.be/6H5neKpUz9E
- Cumulative Sum in SQL – https://youtu.be/COEEGPXjNbk
- Row number() in SQL – https://youtu.be/1actE8UL4yM
- Ntile() – https://youtu.be/xbjyXk7oSdY
- Rank vs Dense Rank – https://youtu.be/f32Yne_4G00
- Where vs Having – https://youtu.be/rtZpbyyQtVk
- Lead and Lag – https://youtu.be/U_OQD3XpagQ
- Joins – https://youtu.be/_V38OgS1s5M
- Keys – https://youtu.be/yPZG6qurO_Q
- 1NF and 2NF – https://youtu.be/7CyxIOj9zTs
- 3 NF and BCNF – https://youtu.be/VuJ7gnaas5k
- Most Asked Interview Questions – https://youtu.be/UGTsPRUIkYg
- Odd even rows – https://youtu.be/-tLTAuvHAU0
- Delete vs Truncate vs Drop in SQL – https://youtu.be/cSM86aZRhMo
- SQL Tricky Analytics Interview Questions – https://youtu.be/MRgZKeYx1NY
- Binary Tree in SQL – https://youtu.be/oAD-YUafmB8
- Joins Advance Interview Questions – https://youtu.be/pf_RdiCBQw4
- Facebook SQL Interview Questions – https://youtu.be/LDYdcH82IO0
- 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
- 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 - Website – ~2000 completed solved Interview questions in SQL, Python, ML, and Case Study
Link – The Data Monk website - 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 - 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 - 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]