Learn Intermediate SQL in 20 Mins

[@kamcosmic]

You're a livesaver, so clear and concise. However, I really got caught off guard by the fact that you chose apples for the monkeys and not bananas. Like, come on man. Obviously monkeys eat bananas, not apples. I hope you enjoyed making me cry and suffer. Anyways, Have a good day.

[@machinelearninginterview]

Hahahaha you had me going for a second! I'm sorry about this egregious oversight and promise to correct it in future videos :)

[@nounder5048]

Wild monkeys don't eat many bananas. (And wild bananas aren't much like the domesticated ones we're used to - they tend to be bitter, and full of large seeds). What monkeys eat varies between species - and there are a lot of different species, living in a wide variety of different habitats. There is a monkey species which grazes on grass. Most monkeys are omnivores, and eat leaves, fruits, and insects. Twigs, inner bark, and flowers are eaten. They will not turn down an apple, and some species will use rocks and sticks to break open shellfish or nuts.

[@efciaq]

@@nounder5048 this is the comment we all needed

[@advclass9546]

@@efciaq I just knew it would be there too.. :')

[@spencerantoniomarlen-starr3069]

Please for the love of all that is good and holy, make some more of these SQL visualized videos for those of us out here who are really struggling as aspiring data analysts who have never coded before and therefore are really struggling with learning SQL. These 4 videos are head and shoulders above any of the other hundreds of SQL tutorial videos on KZbin, LinkedIn Learning and Udemy I have watched in the last 14 months without learning all that much.

[@anilbarwar007]

Hi James, your videos are really Awesome. I really like the way these videos help visualise the table content. Please make more videos. Hit 👍if you all agree.

[@machinelearninginterview]

Thanks Anil! Are there any topics you'd like to see?

[@michagibas7121]

Real life saver. I've got 2 hours until my exam, and I think I'll get a good score. Thanks! :)

[@machinelearninginterview]

Hope you crushed it!

[@TheScourgeoftheearth]

Have to learn this for my new job. Thank you for posting such a thorough walkthrough.

[@sam5nji310]

This is an excellent video, James, and precisely what I too would consider 'intermediate' topics. The visual element is brilliant. Many thanks for the refresher!

[@machinelearninginterview]

Glad you enjoyed it!

[@3288himanshu]

It was nice seeing names of South Park characters in the video

[@justincooke5888]

I love the south park reference! haha awesome video

[@timchen8992]

the page @4:30, is there any typo that need to correct it as table_1.blue = table_2.blue?

[@kylebecker5083]

Good video. Let's have some more.

[@tymothylim6550]

Wow this was really helpful for me! Thank you very much! I especially like the visualizations and they make a big difference!

[@Leopar525]

I know how to do subqueries but the explanation around 8:15 made me forget it 😂 good job on everything else though :)

[@machinelearninginterview]

Hahahaha 😆 tbh I love direct feedback like this and yes sometimes when I try to forcefully explain a concept it does not go well 😀

[@ankurghosh2387]

Hey I was wondering why we need join on single table can't we just use where clause in the 1st example of subquery

[@begumturan7148]

Could you please explain what is tthe purpose by making two sub- query? Why do we not select max(total_fruit) From CTE? I hope I could get an answer. Thank you so much

[@machinelearninginterview]

For the situation at [17:12](kzbin.info/www/bejne/rqHadoyZos2ngdU) I made a mistake here and thought we can't know the max of 'total_fruit' until they're added together. But you are correct they could be done in the same operation together in the CTE.

[@begumturan7148]

@@machinelearninginterview Thanks for reply

[@Orokusaki1986]

Good content, but definitely check a video out about splitting audio from video, cleaning the audio up with audacity, and then rejoining audio to video.

[@machinelearninginterview]

I will certainly check out audacity - thanks for the feedback.

[@Voronza]

Warning: this video covers CTE which belongs to Microsoft Server technology stack. It is not present in many other SQL dialects. For example: Oracle or ClickHouse (based on MySQL) technology doesn't use them.

[@hongeeleow7506]

4:27 Table_1.Blue_Column should be Table_2.Blue_Column right?

[@scout4u427]

These are awesome videos!!! Can you please make more and an advanced one too! Visualisation makes it sooo much better! Defo a fan

[@machinelearninginterview]

Thanks! Hmm I started one but it turned into this ('fill out your knowledge') kzbin.info/www/bejne/iX6yXnxojs2Cmrc. Is there an advanced topic you'd like to see?

[@zemichal]

Thanks for the recap man

[@alittlecoding]

WELL DONE. THANKS

[@wardhereadan1187]

DUDE YOU ARE EPIC!!!

[@Jack-fd8cx]

Oh my god he killed kenny!

[@justinsorci5998]

I’m confused by the video being theoretical. It would be clearer if we can see the real thing....where do you type these commands? What does the results look like?

[@efciaq]

Genious video. Thank you SO much for your work. :)

[@machinelearninginterview]

You're very welcome!

[@spencerhiggins5411]

Thank you for the informative videos! Nice! :D

[@tatjanaburdett2854]

It took me less than 5 seconds to figure out where those names came from. Not sure if this is something I should be proud of...?

[@machinelearninginterview]

You're a person of culture :D

[@negoego2692]

25 apples and 18 oranges make up a total of 43 fruits for Kenny, he cheated :) @12:20

[@krissicura842]

hi James, do I understand correctly, that @ 3.55 when you specify, "On Table_1.Blue_Column = Table_1.Blue_Column" this indicates that you only want ALL data from Table one?

[@machinelearninginterview]

Hi Kris! No, unfortunately that's a type-o. The line should read 'On Table_1.Blue_Column = Table_2.Blue_Column'. Sorry for the confusion :(

[@krissicura842]

Thank you for clearing that up for me!

[@camilogarcial11]

Thanks for this SQL series. Too bad I'm colour-blinded.

[@machinelearninginterview]

I've definitely become of aware of that problem from these videos - future animations won't require color distinction.

[@giancarloandrebravoabanto7091]

lm using borland database engine and subquery is no supported

[@Deoxynum]

it is quite interesting but man, sometimes your syntax is confusing, and like in 14:21, not the entire code is showing. pls consider that for your next videos, thanks

[@machinelearninginterview]

Yeah I can see what you mean, it's pretty squashed together and hard to follow. Will keep that in mind. Thanks for the input!

[@GLu-tb1pb]

it sounds like you're walking in circles around the mic :o

[@machinelearninginterview]

My mic skills were very poor. I'm working on it though!

[@fernandofajardo6359]

NICEE

[@MrEnvy999]

Your mic is kinda broken :/

[@muzammil150]

Southpark Yay!!!!!

[@Missraeraeruru]

great video..do you know why left join is called a left join

[@machinelearninginterview]

Hm it has to know which table to select all from and which to only select matched. So they call it a left join which signals to the user that the table they write first in the join clause (the one on the left since we read left to right) is the one that gets select all. That's my interpretation.

[@noelrichardt695]

Please fix your mic overlay. put a piece of tissue paper on it to keep you from popping our ears when you get too close...