Видео

Coding question 4 makes no sense to me. I wrote the following and got the wrong answer, and different output to your solution, even though they look identical in what they are doing? SELECT ac.name FROM actor ac JOIN casting ca ON ac.id = ca.actorid GROUP BY ac.name HAVING COUNT(CASE WHEN ca.ord = 1 THEN 1 ELSE 0 END) >= 15 It should be essentially the same, since in your solution you are counting the name, because it was already filtered to only include ord = 1 and grouped by name. In mine we grouped by name, and counting the occurences of ord=1, it should return the same value, and the same names, why doesn't it?

hi, the coding question5 list the people who have worked with.... may I ask you why don't we direct write" where name=...." not sub query?

Thanks for this. I attempted the last one before watching your solution. I didn't need to go to the movies table since the movie ids were already on the casting table. But I really like how you explained generally. Great video. Please make more. :)

Walker Kevin Garcia Eric Martin Larry

thank you

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

I don't know why but i find you sexy talking about no sexy things gosh.

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

In the 4th question shouldn't it be count(movieid) since we are counting the number of movies they starred in?

Thank you for the advice

I'm waiting for the next parts.

Perfect and Best web scraping tutorials that I've met. Thank you Bro.

R is best !!!

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

thank you

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

Matlab, best of both worlds..!

Intro to statistical learning now has exercises in Python as well!

Much Appreciated!

20 seconds in and my boy is cutting deep with that question 🫡

Incredibly helpful video! Thanks Aaron :)

Dude you are cool definitely subscribe

R is a secret power, Python is cool but R levels you up

Thank you for your guidance God bless you brother ❤❤❤❤❤❤

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

In 2023 (or 2024), learn Julia! It's come a long way in the last few years. R and Python are still great choices but they're far from the only options these days for data science.

cool video)

I know this video is old, but like when you mentioned jupyter notebooks for python, it's kinda baffling that you didn't mention the fact that R should be fully support in jupyter, since the idea with those is mixed code blocks. So you can have markdown blocks and python blocks and R blocks, Julia and even c blocks if you hack it enough. I watched this video because I'm already fairly proficient in python and was thinking should I learn R and when you mentioned both, Jupyter is the first thing that comes to mind

I have been working with R for a year now and i been concluded, go with python. It does matter when it comes to technicality

Name one (1) of the top 25 department of statistics in the world that use Python to analyze data? I'll wait. What do "you" (impersonal) now about data analysis that statisticians do not know? Python wastes a lot of time to do some simple data analysis tasks.

18:16

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

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.

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

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

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.

Why in 2023 Python is still behind R for data analysis and visualization?

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.

Why do you start something which you can't finish...its over 3 months now

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

i started R almost 1,5 years and am enjoying the tool. however many colleagues only use Python and seem to be annoyed with the R code. this is due to the fact that my company is working with MS tools, and microsoft decided to go all in with Python. i feel the pressure to learn coming closer.

Amazing video! Many thanks!

I already know both languages, and this still feels like a roast.

Love the way how you start the video !😄

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

When is the next video coming out ? Its been more than 4 weeks and we already have started forgetting about the first part

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.

Hey Aaron I just found your channel and have really enjoyed your last few videos. As a newbie, I have a lot of questions to ask and the overwhelming desire to learn everything is killing me. I'm trying to build a strong portfolio but don't know to how to start with it.

Thanks Aaron, really good and clear tutorial!