SQL Interview Questions and Answers for Beginners | Data Analyst Interview Questions
ฝัง
- เผยแพร่เมื่อ 4 ก.ค. 2024
- Take my Full MySQL Course Here: bit.ly/3tqOipr
Today we look at some SQL Interview Questions. The first questions we look at are Phone interview questions which are generally more broad questions. Then we look at In-Person interview questions which are typically more technical and specific.
You may get some technical questions during your interview or none at all! It all depends on the position and the people interviewing. This is by no means an exhaustive list, but are ones that I have personally been asked or I have heard have been asked from other colleagues and redditors.
I hope these really do help you try to see what kind of questions you may be asked and what things you may need to prepare for to be ready for your next interview!
Link to All Questions and Answers:
github.com/AlexTheAnalyst/SQL...
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
Google Data Analyst Certification: coursera.pxf.io/5bBd62
Data Analysis with Python - coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
Python for Data Analysis and Visualization- bit.ly/3hhX4LX
Statistics for Data Science - bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
Websites:
GitHub: github.com/AlexTheAnalyst
____________________________________________
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for
As a recent graduate that’s trying to get a entry job/internship as a data analyst, I appreciate you making these helpful videos
Absolutely! I'm so glad that you've found them helpful! Good luck on the job hunt - feel free to email or message me on LinkedIn if there is anything I can help with!
How did the job search go?
How'd it end up going?
Please do a Python Q & A for Data Analyst roles. Your videos are INCREDIBLE!
Design IsOrion that’s a good idea! And thank you so much! That means a lot! 😁
I'm so glad people like you exist! As someone who's currently trying to do a career, this right here is like finding treasure. Love your content and the great work you've done to help all of those who are aspiring Data Analysts!
Thanks for including video of yourself as you talk. This makes the video much more enjoyable and engaging. I've had companies ask me questions for a Data Engineer type role and get into DBA level stuff. LOL It was painful. You just never really know what some companies are going to throw at you.
I was searching for a mentor and guess what, I've found one. You are a blessing. Thank you so much for such clarity. As a self-starter data analyst, I have been facing imposter syndrome since quite a long time, but watching this has motivated me to keep working.
I'm so glad to hear that Abhilash! When I was starting out I really didn't have anyone to help me (in-person or through TH-cam). I started this channel with the hope I could be that person for someone else. Feel free to reach out to me if you have any specific questions!
Alex The Analyst Thanks for your reply. It means a lot. I will be looking forward to learning more from you.
Honestly, same here
He such a blessing 😍
I'm just starting out, but In just few months, I feel very proud of myself
This is really helpful since I've been meaning to get my hands on some "real world" interview questions to evaluate myself. Thanks for doing this.
Brwsk of course! I remember being exactly where you are - always good to have help 👍
I was so relieved when I heard the entry level questions.. I took a course on Google sheets where they used some queries so the answers mostly made sense to me . Faith restored!
Glad to hear it!
Thanks a lot for your great contents. I am a newbie in the data analytics world, so happy that i found your videos. 😊
This is a really good video to watch if you have an interview coming up. I appreciate your efforts in making this video Alex and it would be great if you could also add some broad questions about databases.
Thanks for watching and for the suggestion!
This is really helpfuI! I was trying to gauge my sql for entry level data analyst jobs and this has given me a good idea. Thanks for sharing.
fleur rubbani glad it was helpful! Thank for watching!
Thanks for the video. As an analyst that is just starting to use SQL I feel better about my skills since I was able to answer all your questions.
That's fantastic! This is definitely not an exhaustive list, but if you're able to answer them all you're off to a great start! Thanks for watching :D
Thank you for this. Grt videos and tutorials. I have been watching and learned so much already.
Totally incredible. Love the document
I saw this video 2 days ago and I can proudly say that I am already able to understand and answer the basic questions. And I understand little of the intermediate questions. And the difficult questions I still don't understand much but I do understand enough but I am unable to answer them without taking a while to think
Thanks Alex! I will be interviewing next week, fingers crossed
thank you sir its really helpful and am sure that it's really helpful in my upcoming interview... your simply great I just like the language that you explain about any topic.. just go ahead and thank you very much again..
Very useful info mate. I am starting to process of changing carrers and you have been incredibly useful :) Thanks
That's awesome! Glad to hear it!
I have an upcoming interview for a data analyst role and these videos are great! I'm brushing up on SQL and BI tools, still a bit nervous getting into the interview for a dynamic role. Would appreciate any tips on interview prep, core skills and analytical skills to practice, thanks!
That's awesome! Good luck on your interview! I do have a few videos on Interview Prep - which it looks like you're watching now :) My main tip is to do research on the company you're interviewing for and try to find out what type of data they use and what systems and softwares they use. This is great to know so you can talk to this in your interview and highlight those softwares to make sure they know that you have those skills. There's just so much to go over, but that's one tip!
This is much more accurate compared to the other interview video
Hey Alex, I guess this will also work. Please let me know if I'm wrong. Cheers.
select drugname from drugstable where drugprice = (select max(drugprice) from drugstable) ;
Hello Alex,
Thanks for great video and Q&A for SQL, those where very helpful. And thank you for all the great content regarding data analytics :)
You mentioned at this video that you could make another video about Python interview questions. I could not find it on your channel, so I wanted to ask you if you can maybe direct me to it or, if not, could you maybe recommend some good video somewhere else which, in your opinion, covers well this topic?
Once again, thanks for great videos and keep up with good work!
Found you through a sub on Reddit! Your videos have been very helpful in evaluating my tech skills as a data analyst. While I’ve been in a BI/analyst role for 9 years using SQL, Business Objects, Tableau and Excel of course. I think I’m a mid-level/intermediate SQL. Not sure I have the aptitude to be advanced or learn programming like Python.
Thanks for watching and supporting the channel! It means a lot! It doesn't hurt to start learning Python and see how it goes - that's what I did and I ended up loving it.
Hope you learned python buddy. It's really not that hard
@@benjamindavis2475 - got a new job 2.5 years ago without it. Now we’re using Snowflake and will likely learn Python.
Thanks Alex this insightful
Thank you Alex, this has been very helpful
You’re most welcome! Thanks for watching!
So helpful. Thank you.
Would love a part 2 to this video
Thank you dearly, Alex.
Alex. Can you post the most asked interview computer coding assessment for healthcare data analyst for claims.
Informative & useful clip. Please also create Python Interview Q & A. Thanks Alex.
Alex, in Q3 I am assuming that Drug_name would be a unique value. So how would we group a unique value? I was thinking of using order by drug_price desc and select top 1
7:15 why select dispensed drug from patient table? It exists in drug table
Alex, this is awesome material. I'm currently in a position where part of my job is doing data analyst work and the other more of a business analyst. I will like to move more towards the data analyst role. As far as SQL goes, what is a list of things we must know for a mid-level position. Things such as joins, unions, stored procedures, etc. There is so much to SQL but will like to know if there are areas that you would recommend where one should be really strong in for a mid-level position. Thank you!
That's a great question. I consider where I'm at to be pretty mid-level position and here's what I would say are mid-level SQL things to know how to use - Sub-Queries, Partitioning, Temp Tables, Joins, Self-Joins, Unions, and all the basics. I also need to have a working knowledge of CTEs and Stored Procedures.
@@AlexTheAnalyst Thanks for your reply. I'll will definitely put some focus on those areas and will try focus on python as well. Thanks again!
Thanks...alex I was looking for this answare since very long....I am done with the all basics topics and need more command on this topics that u mentioned here ...Can u plz suggest me the best resource and course for this particular topics so that I can sharpen my knowledge..on this mid level day analyst topics... I m done with khan's acadmy course for basic level.. already
I like the selection of questions you shared. 😊
TheInteractiveLearning thank you! And thanks for watching!
Thank you for the video. This is super helpful. Please make a Python interview question for data analyst interview too.
I think I will - I've had a few others say that as well. Thanks for the feedback and thanks for watching!
Yes! Please make python questions!
Thank You very much!
You are the best !
Hi Alex, thanks for all you do but it would have been very helpful for you to give examples of how you would amswer the questions.
Hi Alex its a great video on SQL interview questions.Really Appreciate your efforts it will be great if you make Python Data Analyst interview questions as well....
Akash Rai I’ll have to do that! Thanks for the feedback!
If only the questions during the interviews I've attended were so simple! Nevertheless, thank you Alex.
Hi Alex!
Thank you so much for all the content you're putting out here! I wanted to ask how one could further their experience in using SQL? I'm currently learning SQL through DataCamp--I now know how to query data, how to window functions, and the likes. Though I believe that I'm ahead than my previous self, I seriously believe that execution is where I can truly further it, are there any platform where I could execute and practice on it? And I'm also curious about the first question, what knowledge should I have for it to be a 10? I hope to learn more from you!
I have a series on my channel called "SQL Basics" and it shows you how to download a local copy of SQL Server. I would highly recommend doing that and using it. That's what I actually use for work and it is great to get hands on practice within the actual system instead of some online platform.
@@AlexTheAnalyst Thank you so much for your response, Alex! Ill definitely check it out! 🤞🏼🔥👌🏽
Hi Alex, would you be able to make a similar video to this for Python questions? Thanks again for these videos!
Aneesh Patel I plan on it!
Alex the epic!
nice one alex.
This is so helpful. What's ur linkedIn name..couldn't find it
thanks alex
Hey have you ever thought about doing a VBA tutorial ?
This video is really helpful. Thank you. Is there a python interview video for beginners too?
Hey Sena, I haven't made that yet, but I think I will when I get the chance.
Good video 👍
Thank you for the video!
I was wondering If I knew how to do all the intermediate queries.
is it enough to do a real world business data analysis in Tech companies?
Maybe, but I'm finding that more and more companies want cloud experience these days like AWS and Azure.
omg i just switched to data science as a management graduate i thought i didnt have what it takes but i practically answered 80% of these questions right , i think it might be just time to start interviewing for jobs , i also know excel , tableau and have a large knowlege of python ( pandas , numpy , matplotlib) i cant code yet but i know most of the models and grand lignes , what do you think i should do ?
If you think you're ready, the only way to know is to get interviews and see how you do! You can always test your skills on websites like Leetcode.
Are these questions still relevant or do they ask difficult questions for an entry level data analyst role ?
Wait i just started learning sql a month ago, are data analyst questions going to be this easy?
Given that question about the drug that costs the most. What would you do with the answer? Would you report the answer to your boss or something?
I have no experience in the data analytics world yet. Im finishing my bootcamp and i am on a job hunt. Some of the broad questions I cant even answer since I have no experience in Data analysis projects except the ones in the bootcamp.
Alex, your video came to my mind on where do you see jobs by 2030? What percentage of the industry will be related to data analytics? 50% or more? This is just a reality check for me.
I think in 10 years this will still be a very in-demand job. I don't think it will explode like Data Science has (since that's been exploding the past few years), but it will increase 2-10 percent per year as it normally does. I think this field is still a very safe bet for long term employment. Hard to say the overall percentage so I won't even try.
@@AlexTheAnalyst Thanks, i was just have this conversation with my friend talking about our office jobs in 10 years such accounting jobs, commercial real estate lending jobs, banking jobs, law jobs, customer service jobs. I just feel they all can be replaced in 10 years (2030) with AI
Ravi I personally don’t think AI will replace most data analysts, but I’m not an AI expert. I think that may be 50+ years off, but not any time in the near future will there be mass layoffs of data analysts due to AI. Just my thought!
can Q3 be done using the below query?
select Drug_name,Drug_price
from table
group by drug_name,Drug_price
having max(Drug_price)
Hi Alex , I'm in first year of my graduation right now and looking for an entry level internship but I don't know what experience should I put into my resume as a fresher. Please tell !
Pragati Tomar hey Praganti, I actually have a video that talks about this (th-cam.com/video/Ns-8Jsa3mEM/w-d-xo.html) - let me know if that helps! But to answer your question - if your right out of college you can put any internship experience. If you don’t have any you can put any past jobs. When you’re right out of college you aren’t really expected to have that much experience so don’t worry if you don’t have much.
Welcome
What if you have no experience what would you say?
Is there a Chart/Table somewhere that explains what is Beginner, intermediate, and Advanced SQL?
There has to be something out there, but nothing that I've personally seen. May have to make one myself!
i'm almost done UDACITY NANO degree .. do you think i will be able to compete and have a good chance to be a data analyst??
really need you answer
I think it definitely helps, but more important are the skills and projects you did during the nanodegree. If you can use them in your resume and be able to speak towards those skills that will help the most.
thanks
You're welcome!
Hey Alex, I'm from India. I just went through some websites telling about the salaries for Data Analyst. I observed that in India , the average salary is much low like ₹5,00,000 and in USA it is $45k. What do you think should still pursue my dream to be a data analyst? Because this salary is very less. And what are the chances that I would get job in USA?
Please reply I'm worried.
Hey Aditya, I'm not familiar with salaries in India, but salaries in the US are pretty good. 45k is more on the lower end, but definitely depends on the area you find a job. I will say that right now is not a great time to be looking at a job in the US. With mass unemployment and several industries shutting down temporarily it is going to be much more difficult to find a job right now. I would check back at the beginning of 2021 and see how the market is at that time. Let me know if there is anything else I can help with!
@@AlexTheAnalyst Thank you for your reply Alex. What about after two years like in 2022? I'm willing to go abroad for job most likely to US. What things should I learn and in which areas I should be good in that will increase my chances to get job in US?
Will it be fruitful to keep hopes for job in US in upcoming years?
Thanks,..,...but could you please slow the pace down a bit when you answer the questions ...
So for beginner question 3, why do we ORDER BY Drug_Name? Wouldn't we want to ORDER BY Drug_Price?
You aren't trying to figure out the highest price out of all the drugs combined, you're solely looking for the highest price for each drug individually I believe.
I could be hired as a senior data analyst with my sql skills right now 🙃 these questions are nothing
you should hide the ribbon in word for this.. but other it was OK..
I feel like some of these questions are worded strangely.
unnecessary to repeat question i can read myself on the screen