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

____________________________________
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:

SQL:

R:

____________________________________
✴ Attributions ✴
Graphics:

[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!

[kristall]

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 😅

[juugro]

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

[shahzainahmed]

so helpful and calming rather than overwhelming

[AlimamyConteh-ketq]

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.

[drivetrainerYT]

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

[timurnurlygayanov]

Man, this is great video, detailed, simple and covers all basic SQL patterns! Thank you!

[aidanthompson]

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

[aidanthompson]

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.

[aidanthompson]

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

[kavinsuresh]

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.

[aidanthompson]

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.

[bhuvanmohinidevi]

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

[aidanthompson]

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

[LA-swgv]

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

[NathanSStorey]

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

[JongeloEntertainment]

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

[jiigyj]

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

[owdengodson]

Joins can be used to combine rows from two OR MORE tables!!

[ezhankhan]

Incredibly helpful video! Thanks Aaron :)