SQL interview questions and answers | Entry level data analyst interview

0:00 Intro
0:36 Interview question 1
1:38 Interview question 2
3:17 Interview question 3
4:13 Coding question 1
7:16 Coding question 2
9:13 Coding question 3
12:14 Coding question 4
16:41 Coding question 5
So you're preparing for an entry level data analyst / data science role and you want to brush up on your SQL. Or you want to practice some realistic questions that might come your way. Well you've come to the right place. I've got 3 oral questions and 5 coding questions to help you prepare. And as always, if you want even more practice, check out sqlzoo.net
____________________________________
If this video helped you please SUBSCRIBE so we can learn together! This channel is all about what I did to learn the necessary skills and tools to get an internship in data science, and how to turn that into a career, so if you're interested in data science/python/r or productivity/career advice in general, stick around!
____________________________________
FREE resources:
PYTHON:
My video on how to learn python: • Learn Python fast | Ho...
Automate the boring stuff with Python: automatetheboringstuff.com/
Official Python website: www.python.org/about/gettings...
SQL:
SQLZOO: sqlzoo.net/
R:
My video on how to learn R: • Learn R fast | 30 day ...
SWIRL (learn R using R): swirlstats.com/
ISLR: www.statlearning.com/
____________________________________
✴ Attributions ✴
Graphics:
www.pexels.com/

[@AaronMOliver]

If you want to skip ahead to the coding questions they begin at 4:15! Thanks for watching, and let me know if this is helpful, I will do more example interview questions!

[@munir8310]

Thank you very much for this wonderful video, however I have one question. In question 15 why did you do join with movie table in the main query? We don't need anything from movie table. Below I did it without that join SELECT a.name FROM actor a JOIN casting c ON a.id=c.actorid WHERE c.movieid in (SELECT m.id FROM actor a JOIN casting c ON a.id=c.actorid JOIN movie m ON m.id=c.movieid WHERE a.name='Art Garfunkel') AND a.name!='Art Garfunkel'

[@AaronMOliver]

@@munir8310 great catch you’re right! No need to join on movie since we can just use the movie ID from the casting table

[@philipkubiak6041]

Thanks for such a useful video, just liked and subscribed! I know this is a random question lol but I loved the background music so much, do you know if I can find it on KZbin? Thanks Aaron

[@juugro]

I usually don't comment on KZbin videos but this was so well put together, awesome stuff thank you :)

[@drivetrainerYT]

Definitely subbed. Definitely a fan now. Please do more videos in your calm and clearly structured manner. Thanks!

[@shahzainahmed6851]

so helpful and calming rather than overwhelming

[@gabiscarabel]

Amazing video! Many thanks!

[@bhuvanmohinidevi194]

That was so helpful! Thank you so much big brother!

[@NathanSStorey]

Thanks for the upload. Great video. Hope it helps with my interview tomorrow!

[@jackma9049]

Thanks Aaron, really good and clear tutorial!

[@JongeloEntertainment]

Straight to the point and simplified... very interesting 👌 👍

[@kristall5390]

Ty! I’m applying for my first data analytics job and this help me verbalize topics that I knew but didn’t know how to say 😅

[@AaronMOliver]

Happy to help, good luck!

[@jiigyj11]

the music was a nice touch and helped me stay focused. Keep doing what you are doing bro. thanks

[@ezhankhan1035]

Incredibly helpful video! Thanks Aaron :)

[@LA-sw1gv]

Thanks for sharing this. It is really helpful in showing how to think logically and work through the question.

[@kavinsuresh5468]

For the interview question 2 ( 9:00 ) wouldn't it be >= instead of just > because the problem says 'at least' which is inclusive of the given number too.

[@AaronMOliver]

Good callout! That's correct, yeah. It just so happens in this case you get the correct results anyway, but there are a lot of times that wouldn't be the case, so good catch thanks!

[@agirmaus-lh9zi]

Thanks so much .. great and relevant content

[@yashgala7556]

Great video, thanks!

[@proxyands.b6003]

Loved it. very useful. highly recommended.

[@AnilAnvesh]

Thanks for this video.

[@naamas6153]

Hi, thanks for the video! Where do you get these questions? (I went to the SQLzoo site and couldn't find questions) I would be happy if you can send me a link! Thanks

[@aidanthompson5053]

A join us a function in SQL that allows a user to combine 2 different tables based on a set of logic and the columns from those tables that the user defines

[@clarafang6398]

nice video! I will have junior data analyst tech interview next week , and the interviewer said he will give me a case study and test my sql and powerBI skill, I have no idea how it could be. do you have any suggestion for data analytics case studies?

[@smolboyi]

Thank you 🙏

[@TheStubLord]

this is great

[@mynameis211]

Lovvvvvve it make more like these

[@kc7818]

For the last problem, wouldn't it make sense to include "GROUP BY name" at the end of the query, since an actor could have appeared in multiple movies with Art Garfunkel, causing them to be listed multiple times? That didn't happen in this case, so the solution is correct either way, but if you take out the "AND name != 'Art Garfunkel'" at the end, his name shows up three times in the output, one for each movie he was in, so this would be a problem if an actor appeared in multiple movies with him.

[@AlimamyConteh-ke1tq]

Wow!!!! I just had a 1st round interview for an entry-level Data Analyst position and just received an update back from the recruiter for a 2nd round interview that I am currently preparing for. Thank you so much for this video. It really helped me to understand how to create proper SQL queries I am currently learning from DataCamp.

[@AaronMOliver]

Amazing! Glad it was so helpful!

[@AlimamyConteh-ke1tq]

Most definitely! I had my 2nd interview last week Monday & waiting to hear back from them by the end of this week.

[@markvilla7796]

Hi! I want to know more about your initial interview.

[@pzeid48]

How did it go?

[@fireinthehole2272]

@@AlimamyConteh-ke1tq DID YOU GET THE JOB?

[@aidanthompson5053]

There are 4 main types of joins: Inner, outer, left, right An inner join retrieves records that have matching values in both tables involved in the join An outer join retrieves records where there is a match in either the left or right table Left join retrieves records from the left table and the matched records from the right table Right join retrieves records from the right table and the matched records from the left table

[@aidanthompson5053]

SQL is an abstraction; a language - there’s no implementation involved, just coding syntax MySQL is a piece of software, a relational database management tool that allows you to: use a graphical interface to update schemas, to define data types to give users permissions or revoke them etc.

[@rajeevsarkar5315]

Hey Aaron can you tell me where I can find the practice sql question except hackerrank

[@aidanthompson5053]

A primary key is a unique, non-nullable identifier for each record in a table and it can be either 1 column or multiple columns. However, each table can only have one primary key.

[@user-lc9uv6mm6n]

cool video)

[@princemontanaa9704]

bro im trying to be an analyst and im learning pandas, sql, python, tableau, matplotlob and I think this is too much. i didnt know interviews will just ask me simple things like sql

[@aidanthompson5053]

SQL is a coding language used to interact with relational databases MySQL is a software used to implement those relational databases

[@mikeygrey9855]

Big up yourself

[@achilleconte4385]

Thanks for sharing your knowledge, was really helpful. Just a quick question: is it common to alias without writing the AS statement?

[@AaronMOliver]

Hey good question. It is common to alias tables without using "AS" but I don't believe you can do that for aliasing variable names in the select statement.

[@achilleconte4385]

@@AaronMOliver got it, thanks. Have a nice one 💪

[@user-fi9rw4vx2b]

There are three join types - INNER, OUTER and CROSS, not four. You missed the latter one. And you missed FULL OUTER join. Also LEFT, RIGHT and FULL joins are different kinds of OUTER join.

[@sayakdas4612]

sir, can you please upload a video on how to work on SQL from an excel data project. can you please show a demo project? @AaronMOliver

[@Zuranthus]

don't know if you have figured it out yet but you need to import the excel csv into a SQL database manager (ssms, mysql, postgre, oracle, access etc)

[@markvilla7796]

is this really the interview question? or the assessment? I'm sorry don't have an idea but want to learn. Please no bad comment. Thank you so much.

[@ayushsrivastava9997]

It should be >= 10 million coz its atleast right?

[@lablondekalalizi9502]

Yooooh, I'm typing your questions in chatGPT and it giving me the same answers without event presenting it with tables. This is awesome

[@aidanthompson5053]

18:16

[@sunnygawande5283]

cte would be better for last question

[@Steven-up9ds]

And there are gap's

[@Paid2Live17]

And there are illogical apostrophes on plural nouns

[@AzzDesignHD]

The music is distracting bro, great vid but litterally if it's a education video then make it raw, you don't need to make entertaining as in putting in music. Thanks for the info tho 🙂

[@OmariTube]

Brub what, I was able to understand with that music in the background. It's not bad really

[@Paid2Live17]

Lmao the music is so low you can barely hear it, always someone trying to find something to complain about...

[@ShawnFX]

@@OmariTube man called him "brub"😂

[@funnytime7143]

thank you