Learn Basic SQL in 10 Minutes

[@machinelearninginterview]

If you need a gift this year, check out my lil side project: quickandeasygifts.com! Video coming eventually on how to build an income-generating website.

[@adityagarg2185]

Hey, has this website generated you any significant income? I clicked on it and so far it seems a little janky... (React App and favicon in the tab window)

[@machinelearninginterview]

@@adityagarg2185 no, it made a few bucks but since then Amazon has implemented an identical feature. I'd like to do a video sometime bc the backend was rather neat and it cost nothing (uses lambda). Also - I'm not a great designer as you can see!

[@dollykumari4456]

Bro did you got selected?😂😂

[@centrumsaiyan7623]

Have interview in 2hours, good video for recall my computer science lessons.

[@TheDanieBoiPHOfficial]

Real Helpful buddy! created in August 5, 2017. but still useful in January 5, 2020. Thumbs up!

[@machinelearninginterview]

You got it! So glad it helped!

[@kilickerem066]

​@Andrei C MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY MANY YEARS.

[@thunderdrake13]

Ah January 5, 2020, what an innocent time

[@codycherrington2314]

I love the way you visualize what the code is actually doing, great work.

[@machinelearninginterview]

Thanks man. For whatever reason YT has seriously hit the brakes on recommending it. If you know anyone else who might like it please share 😀

[@themaggattack]

This visual explanation makes it possible for my newb brain to actually understand what the commands are doing. Thank you!

[@l34052]

I started a new job today and part of their requirements are that I learn basic sql queries, this video will help me out so many thanks.

[@machinelearninginterview]

That's great to hear. Good luck!!

[@yajan6650]

"Or a bunch of columns smashed together!! No one knows" Never Subscribed so fast!!

[@aaronwilliams5515]

Love it. Wish I didn't have so much trouble telling your blue from purple, but I can still follow.

[@smorisch]

I've been building SQL in Access for a little bit and I've never seen it explained this way. I needed help with syntax though. Thanks. I'm sure it's a benefit.

[@machinelearninginterview]

Let me know if there's other areas these videos could touch on :)

[@Asparuh.Emilov]

This video is great! Explaining visually how SQL understand the commands is just the most effective way! Thank you a lot for the job!

[@ryanyoung6689]

Such a helpful video. Explained it better than most other KZbin videos i've watched.

[@ashrafchawila]

very good tutorial for a beginner. i am loving how you take it step by step. i tried other youtubers and i was almost giving up until i stumbled into your tutorial, thats what motivated me, thanks James Vance. I just subscribed for more.

[@machinelearninginterview]

What a great comment. It always feels impossible before its finished! Good luck on your learning journey!

[@inktea256]

Thanks, man! I am thinking of taking some online classes to learn a new skill but I was worried I might not understand how this works. But with this visual walkthrough I think I should be able to get a firm grasp on it.

[@shriraamr1763]

Very good explanation. Anyone does not teach like this.

[@David-lr5ls]

OMG THANK YOU SO MUCH, my professor has the most confusing powerpoint on SQL's and this video made me understand the logic so easily !!!

[@machinelearninginterview]

Thanks! I was inspired by a similar situation where someone was explaining UNION statements and making it way harder than it had to be. Glad it helped!

[@CrazyHalo203]

This is such an eloquently simple explanation of SQL basic concepts.

[@machinelearninginterview]

Merci :)

[@mum3655]

God bless u bro for giving all this knowledge out for free

[@samueltabor6597]

Awesome job man! I actually feel like I can wrap my head around SQL now. Thanks a million!

[@machinelearninginterview]

Thanks a lot!

[@kevinclarke3485]

Great explanations of the purpose and execution of UNION and GROUP BY statements. They can be a bit confusing, even for experienced SQL writers.

[@machinelearninginterview]

Kevin Clarke thanks a lot! When Unions first clicked for me I realized it was easier to just visualize it and that inspired the video

[@nesstoj]

Thank you. That was a good introductory video. It gave me a good understanding of SQL.

[@voiceofreason5893]

This was a great introduction. Thanks for posting. Look forward to seeing more of this, particularly for analysts.

[@machinelearninginterview]

What type of analytical topics?

[@abdu2s]

finally an accent that is clear and understandable! Thank you so much

[@machinelearninginterview]

Glad it helped!

[@kosbebot6360]

This is brilliant. I'll use similar examples to teach others and I'll refer them to this video as well.

[@egs8075]

Realyl useful thank you lol . My database class is coming up this morning and now I'll be slightly ahead than the rest of the class.

[@cantona7449]

Fantastic demonstration/explanation/introduction! Thank you! This is personally very helpful for me.

[@machinelearninginterview]

Thats awesome to hear!!!

[@mezmerizer9422]

Exam is in about 9 hours, so that's ~540min, that means that I can watch this video 54 times but if I speed it up to 1.5, I can watch it about 80 times... yeah, I got this.

[@machinelearninginterview]

I hear if you leave it on while you sleep you'll remember the next day :p

[@throwaway.mp4931]

@@machinelearninginterview ommelette du fromage

[@Semphortune]

@@throwaway.mp4931 Dexter’s Laboratory 😱

[@Daniel-hh9gg]

This video is so underrated! Great job!!!

[@machinelearninginterview]

Thanks that's very kind!

[@Trysomieflexntjes]

I got my job after just watching this video!!

[@machinelearninginterview]

That is awesome! Congrats! :p

[@Noname23489]

ya right! stop joking around u serious?

[@machinelearninginterview]

@@Noname23489 I think it's a joke based on other comments about passing tests, acing interviews and getting dates :p

[@brooklynohio518]

You are so lucky

[@SH-ix4rl]

I hope this is me!!!!!

[@JacobAndJamal]

Thanks , Trying to take my MTA 98-361 and needed a crash course in SQL

[@shawnbutlerjr]

I like your approach to teaching thank you!

[@dylanburris9593]

Thanks for the video! My professor is an idiot and I'm really glad that this great video was made for desperate fools with exams in the morning like me.

[@machinelearninginterview]

That's what its here for :) Good luck!

[@claytoncolleran]

I think this was an awesome brief overview. I'll know more after further research, but great start right here. Thanks

[@machinelearninginterview]

It's great to hear that! Good luck on your learning!

[@jeffreycohen7139]

This is great overview. Nicely done.

[@benedictbagang9803]

Awesome explanation in an easy to grasp manner. Well done!

[@Drea730]

Thanks James Vance! So clear and easy to understand.

[@machinelearninginterview]

☺

[@machinelearninginterview]

Parts 2 and 3 of this series are coming this weekend 2/25/18. Stay tuned!

[@kewlsid05]

This ever come out?

[@machinelearninginterview]

A little behind with another project. Coming very soon!

[@machinelearninginterview]

Here we go: kzbin.info/www/bejne/rqHadoyZos2ngdU

[@hasantarek6521]

please keep it up. you have the potential to make good and helpful videos.

[@tymothylim6550]

Thank you very much, James, for this video! It was really simple to understand and I learnt a lot!

[@thecodingmentor7701]

Thanks for the free and useful Tutorial!

[@naderreda2020]

Simple and Clear ..... Thank you

[@DevlogBill]

I've recently viewed a couple of other youtube channels and so far from the couple of videos I've watched none of them don't break it down to the bare bones of what SQL really is? its usually a youtuber instructing you to download my "mysql" or or some other application to download, then they provide a poor tutorial on the subject by over explaining the subject. I appreciate the simplicity of how you introduce the subject matter. The video was simple and to the point and wasn't over elaborate, thank you.

[@machinelearninginterview]

Dude, that's awesome. That's all I was trying to do

[@jeffreynewball]

Love the visualizations

[@victorecarma4307]

Great intro course. Would recommend it to beginners

[@machinelearninginterview]

Thanks so much! More visual-based vids coming soon!

[@ucfknight239]

James Vance!! Vance Refrigeration!! I'm sure you've never heard that one before. In all seriousness, thanks for the video. Very informative!

[@machinelearninginterview]

Haha yup I get that all the time!

[@superdude512]

6:26 Thank you, this visualization really helped joins click with me. And, uh, I got a job as a Senior SQL Engineer after watching it...

[@machinelearninginterview]

Congrats! I expect nothing less from my viewers :p

[@johnreynolds4473]

Thanks for this James. Very helpful!

[@techconcepts1318]

Very good , keep it up

[@themistoclesnelson2163]

Thanks for the video! Very helpful.

[@Jerrel.A]

Game changing SQL explanation.

[@AmericanKoba7]

This is very helpful! As someone who is green and looked at other resources, you did a great job....hopefully you made more!

[@machinelearninginterview]

Thanks! More coming soon!

[@age_of_reason]

It's ok if you're green. We're all about diversity and inclusion here.

[@saskiaseia8779]

Thank you so much for doing these videos. 🙏

[@machinelearninginterview]

You're quite welcome!

[@whowhat8613]

Thank you James, awsome idea to teach sql basic

[@machinelearninginterview]

Sure thing! Thanks a lot

[@magtazeum4071]

Very useful..Thank you hun..You earned a new subscriber..

[@machinelearninginterview]

Thank you! More vids coming next year!

[@magtazeum4071]

@@machinelearninginterview Aww..looking forward to those x

[@ChrisGugliuzza]

I have a final on SQL in 40 minutes. Hopefully this video gets me an A!

[@machinelearninginterview]

Go get 'em!!

[@Artwojzx110]

how did it turn out?

[@ChrisGugliuzza]

Kristian Scharff C lol

[@Artwojzx110]

ChrisG- I actually watched it too right before my exam. I did ok i guess

[@Artwojzx110]

ChrisG- I got a 5.7 btw. Not bad.

[@aliosman0]

Very good tutorial!

[@wasteoftimegames]

I HAVE A JOB INTERVIEW TOMORROW AND HAVE NO IDEA WHAT THIS IS ALL ABOUT! I HOPE THIS VIDEO HELPS

[@machinelearninginterview]

Good luck!!!

[@TheDarkEthereal]

OMG, I thought I was the only one! Same here!

[@dannywithnuggets]

Same here! Ahaaha..aaaaaa...Did you get the job?

[@machinelearninginterview]

lmao

[@akwaabab8504]

I have one on Friday. how did yours go?

[@retrofutur1st]

The last one confused me, only the dark red/green were added up why?

[@planetrocket4255]

10/10 thank you friend!

[@ronaldabellano5643]

You’re a genius!

[@garrybellnz]

Uses normal english, really useful lthanks

[@thomasvanderstaay5863]

Thanks, really helpful.

[@discman15]

Put the volume a little higher when you export plz

[@jsguitargeek1432]

This is brilliant .. really

[@brigoose7945]

ive been learning sql, i worked in a transport office where they used access and excel and it just didnt work, so I thought id have ago at building a full transport and warehouse db, which so far works easier and better. However with the db built, would you have to build a gui or some software to use it externally? As ppl who cant use sql wont know how to do it, however if they had a simple userface, it would just need inserting and would update itself

[@machinelearninginterview]

Theres actually some tools where you could pre-load excel macros to pull or update data connected to the SQL database. A connection like ODBC can help hook up excel to your database

[@machinelearninginterview]

There are also gui tool like alteryx, microsyrategy and cognos if your company will pay for licensing

[@alcast7444]

Amazing video for beginners. Do you have a series?

[@machinelearninginterview]

Thanks a lot! I do have more videos in progressively more advanced SQL: * Intermediate SQL (kzbin.info/www/bejne/rqHadoyZos2ngdU) * Deep dive on joins (kzbin.info/www/bejne/qqeweKKuoratnbM) * Fill out your knowledge (kzbin.info/www/bejne/iX6yXnxojs2Cmrc) Hope it helps!

[@eugeniaarzaga3058]

THANKS FOR THE BASICS!

[@BenMueller]

great video

[@devinh.9683]

Thank you for this amazing tutorial!

[@hugokornelis6840]

What a perfect video, will be using it !

[@guaguago2583]

Very helpful to beginners!

[@subrahmanyaam]

Awesome Beginning

[@ShiroAustin]

2:25 Did I just get vibe checked by an SQL tutorial?

[@machinelearninginterview]

Don't doubt your vibe ;)

[@tzetzo_tzetzov]

@@machinelearninginterview awful reference. I hate it. Thanks for the vid tho

[@ste11an2]

Legit pfffd with a smile at that intro about the fancy logo :)

[@alexandermoritz4937]

New to SQL but why does the RED values get filtered in the other columns aswell? Since you only specified where Blue column RED

[@machinelearninginterview]

RED shouldn't get filtered in other columns but I could have made a mistake in my graphic. Do you have a timestamp?

[@alexandermoritz4937]

@@machinelearninginterview thanks for answering so quickly. Yeah its around 4.45 ish.

[@machinelearninginterview]

@@alexandermoritz4937 hmm I think it might just be the x marks that are too big. I see 2 rows with red in the blue column and they disappear after the where statement

[@alexandermoritz4937]

@@machinelearninginterview Well maybe im missunderstanding something simple. But at 4.47 there is 6 "rows" in every column ( column_blue, column_orange, column_yellow and column_green). Then at at 4.50 all columns now have only 4 "rows", not just the blue column that you specified.

[@leoyuanluo]

best sql tutorial thus far

[@machinelearninginterview]

Thank you 😀

[@lewislyles1064]

Would this video help for QA tester?

[@machinelearninginterview]

Definitely. Being able to query sql to understand the state of a system is crucial for a qa tester

[@freeforallnews1890]

Great video! It even helped me understand the Join Tables function in ArcGIS! I really appreciate the visual here. Trying to get traction teaching myself GIS and indexing has not been easy. There are so many amazing open source programs and free education tools out there, but so much of it doesn't start with properly orienting the student. Context, application examples, and visuals are really helpful. :) Quick question: What language would you suggest I learn for library/museum indexing? I want to be able to sort collections, extract data I can put into tables, and then use those tables to potentially create visual representions of the data through ArcGIS. I am working on learning Python right now. I am not sure that will be enough, though.

[@machinelearninginterview]

Thanks a lot :) If you're working on Python I'd really recommend the sentdex channel. Not a ton of GIS but great stuff. Best of luck!!

[@machinelearninginterview]

Oh and to your question, I would definitely recommend Python if you're asking about languages. Its user friendly, it integrates into things like Excel and you can literally do anything in it. I've gone from basic data analysis to building my own website in not much time. Bon fortuna!

[@freeforallnews1890]

@@machinelearninginterview Awesome! It is nice to know I am on the right track.

[@ramanjeet1111]

can u suggest any sql software to download which we can practise at home

[@machinelearninginterview]

I'd suggest Postgres since its easy to load data and comes with the PGAdmin editor. Or you could play around in the browser www.w3schools.com/sql/trysql.asp?filename=trysql_asc

[@ramanjeet1111]

@@machinelearninginterview thx

[@peilin552]

Thank you 🙏

[@richluke24]

I'm a data analyst just learning SQL if I want to practice this at home what do I need to download? How and where do I access the platform to enter the SQL code. Also with the tables how to I name them, I assume it's easy if they are in Excel. First off?

[@machinelearninginterview]

Yes, you can load excel data into a SQL database for practice. However, there are a lot of datasets already in sqllite format that would be easier to import. I'd recommend downloading sqlite and sqlite studio and then using a Kaggle dataset. Here's an example with food reviews from Amazon: www.kaggle.com/snap/amazon-fine-food-reviews. You can use sqlite studio to import the data

[@johng.6129]

thank you, this was a useful vid

[@lucforme]

I got a date with a hot girl in 30 min. Hope this video helps !! kappa

[@machinelearninginterview]

Uhh...better watch it twice?? :p

[@lucforme]

Guess ill do that then. Maybe ill get the 2nd date. kappa

[@quicksilver5253]

HAHAHAHA You won the internet

[@Yoakemaee]

It's not twitch, please don't say kappa. And this was also 9 months ago, holy...

[@blo0m1985]

if you get nice job because of knowing that, she will be very glad to be with you

[@StefanDevito]

very useful, thank you!

[@teddytechilo]

James, i am new to IT field i have no experience at all, can you give me a guidance as to how and where i should start, as i am planning to get certified in DBA. Thanks in advance!

[@machinelearninginterview]

Well there are many, many paths and I am not an expert on IT careers. However if you would like to become a certified DBA I would say some sort of cloud certification would be an excellent companion. Many companies are in the cloud and many more are transitioning. I subscribe to acloud.guru which I've found helpful passing AWS certs

[@ghitapaints91]

Thank you very much.

[@siddvideos]

please leave a link to examples and other references to your website in the description....

[@machinelearninginterview]

Will do, and thanks for your suggestion

[@rnph7]

Thanks 👍👍👍👍👍

[@Mosin54r]

Excellent!

[@machinelearninginterview]

Thanks!

[@lavinaagarwal5609]

really good. thanks a lotttt

[@machinelearninginterview]

Appreciate it!

[@michaelezeagwula9592]

how can i Learn this; do you have a tutorial you can refer to me?

[@machinelearninginterview]

The free Codeacademy one works very well www.codecademy.com/learn/learn-sql

[@HeadingForTomorrow]

Group By looks for same values in Blue column right? I wish you used names or other ways to indicate the blue column, for example maybe it was warehouse numbers warehouse 1, warehouse 2, warehouse 3, warehouse 1, and you somehow had two of these (maybe because you used Union) so now you are combining two warehouse 1 stock quantity reported by different workers. I love your simple explanation but we to explain to people how SQL or basic database can be utilized on day to day operation. Most people have no clue how to utilize sql. They think it's complicated and requires a lot of investment, while it's just a fancy excel.

[@machinelearninginterview]

Yeah, that's fair. Sometimes trying not to be specific makes it more confusing. And agreed on the utilization point. Soon I'm hoping to make more technical videos but also some less technical concept videos for data & analysis. Stay tuned!

[@HeadingForTomorrow]

@@machinelearninginterview please incorporate forms and design in access, I've been trying to do this so I can enter info to excel with autocomplete that completed other cells when you type one in another. If I put x in cell A1, I want it to put Z in A2, for example...

[@TomasMendes]

Thank you :)

[@machinelearninginterview]

You're welcome!

[@ruchir6614]

Love you dude

[@machinelearninginterview]

;)

[@klonrymeryme5293]

this video age like a fine wine

[@icerook1560]

SQL is just crap going into a certain order, the obtaining the good data is the hard part.

[@karatkdj9]

Thank you for making such a great video

[@swagataroy7230]

I am color-blind so what I saw was different shades of grey columns and grey dashes... 😩 Nice job... Although good tutorial...

[@machinelearninginterview]

Yes I will not make this mistake again!! Tried to be too abstract, sorry. Glad you liked it despite :)

[@swagataroy7230]

@@machinelearninginterview to be honest your tutorial was so good I managed to complete a problem in a live competition.. I am subbed and on board....

[@rogerh2694]

Still fuzzy for a beginner. Wtf did the last one mean

[@machinelearninginterview]

Yeah 'Group By' is not an easy concept to grasp right away, and it doesn't lend itself to visualization well. Another way to think about it would be "per". In the last example if we had items in the blue column and quanitities sold in the green column, we could sum up the green column and group by the blue column to get the total (summed) quantity sold "per" item

[@armaneduniya2674]

Fancy logo James :d

[@ToddWaters_tw]

Thanks

[@kelvinwilliams2908]

The colours are not clear but otherwise good