MySQL Crash Course | Learn SQL

In this video we will look at installing mysql, creating users, writing SQL queries via the shell and Workbench and even implementing MySQL into Node.js at the end.
Sponsor: DevMountain Bootcamp
goo.gl/6q0dEa
MySQL Cheat Sheet:
gist.github.com/bradtraversy/...
💖 Become a Patron: Show support & get perks!
/ traversymedia
Website & Udemy Courses
www.traversymedia.com
Follow Traversy Media:
/ traversymedia
/ traversymedia
/ traversymedia

[@TraversyMedia]

Slides - 1:00 Download & Install Info - 9:34 MySQL Path Info - 11:40 Shell Login - 13:48 CREATE USER - 14:43 GRANT PRIVILEGES - 16:36 CREATE DATABASE - 18:23 CREATE TABLE - 19:08 MySQL Workbench - 22:50 INSERT - 25:20 SELECT - 28:50 DELETE - 31:21 UPDATE - 32:05 ALTER TABLE - 33:11 Update via Workbench - 34:50 ORDER BY - 36:10 CONCAT - 36:50 DISTINCT - 37:58 BETWEEN - 38:49 LIKE - 39:25 IN - 41:40 INDEXES - 43:00 Table With FOREIGN KEY - 45:00 INNER JOIN - 50:24 Table With Multiple FOREIGN KEY - 52:30 LEFT JOIN - 55:00 Aggregate Functions (COUNT, MIN, MAX) - 58:46 GROUP BY - 1:00:18 Node.js & MySQL Example - 1:03:55

[@kreshnikpalushi1587]

Pin this comment

[@holachinazori1591]

can you please stop posting tutorials , i can't just watching your videos . 2017 2018 2019 ...

[@taariqq]

@@holachinazori1591 .. lol

[@taariqq]

Brad, if you could, please share a few good sources of sites where you can download data to play with. I mean your recommendations.

[@sodiqoyedotun3185]

Can you post a link to the MySQL cheat sheet you are using

[@jlambert12013]

This was so much easier than I anticipated. Brad is the only person who can explain programming to beginners on KZbin

[@mikec360]

Just as I was looking for a competent MySQL tutorial your video pops ups.Brad you are always right on time. Be blessed

[@francishalloun7531]

Same here

[@balimerouane8341]

Bruh! same.

[@quanganhvu4231]

Same here :)

[@taariqq]

He's got the finger on the pulse. No doubt.

[@jameskamonga6233]

Thank you so so much BRAD for changing my life with your videos.. changing my career completely from working as a medical doctor to doing programming and web development has not been easy but with your videos, im progressing.. cant thank you enough bro

[@superxereu]

I've been doing SQL for 20 years and MySQL for 18, this crash course is simply superb!!!

[@koggism]

I've watched a 3 hour tutorial on MYSQL and have to say it was good, but I have learned more from this 1 hour tutorial a lot more because you are to the point, you don't repeat, you don't pad it out with irrelivance. Very well presented, quality material.

[@taariqq]

JUST as we, at the BostonPHP Meetup group, were going thru the MySQL portion of the book! Perfect! I find these videos not only very helpful and practical but they are a perfect alternative to wasting time on TV.

[@kramseyart7663]

Funny, I was JUST looking for a MySQL tutorial yesterday! Great timing. I have learned so much about web dev in just the past month alone, looking to start applying for jobs after another month or so of tutorials and trying my hand at making apps from scratch. All that you teach has been a huge help in my process, I really appreciate your hard work!

[@MrPDTaylor]

The day I decide to learn MySQL Brad uploads this video. It's definitely a sign.

[@stevepatterson3822]

You uploaded this a day before my Database Systems exam, this is why you're my favorite channel!

[@bulcub]

I learned more in 1hour then I did in forever!! trying to find someone who could explain and demystify SQL! You have given me the confidence to push forward to create a brighter future for myself. I have also purchased 5 of your classes from Udemy! Thank you and keep the tutorials coming.

[@elijahromer6544]

Brad, I consider you to be the person who taught me everything. Thank you for all that you do.

[@AndresGarcia-lo4yr]

Traversy you are truly awesome! thank you so much for these free tutorials, really help us Junior devs on a budget. I love the way you teach Programming. Every time I don't understand something, I always know that if you have a course on it or a youtube video I'm going to get it. Really appreciate everything you do.!!

[@gavin_z28]

i have been struggling with sql for so long and this is just what I needed to get started thank you so much!

[@emmanueleze3028]

Thanks Brad, God bless you. Love from Lagos, Nigeria.

[@debadipti]

Great time Brad! I just finished SQL yesterday! Happened 2nd time after React JS

[@brenthearn2578]

This video was SO HELPFUL. Very nice coverage of the basic info I needed, and *huge* props for the practical example at the end. Thanks so much!

[@Dumpstermonkey19]

Really needed this refresher after having used NOSQL databases for so long. It made my day when I saw this in my notifications.

[@balimerouane8341]

Bruh! I needed this course this week to switch my Django's project DB from SQLite3 to MySql, And it just so happened to be that my favourite web development teacher just uploaded it. Thank you so much man.

[@kamilka-visuals]

Hello everyone, just to get you started on Lux, Mint and Ubuntu: sudo apt-get update sudo apt-get install mysql-server-5.7 sudo apt-get install mysql-workbench Have fun! @traversymedia , Sir, thank you, Brad. Great help, as usual!

[@kecc]

Thanks Brad for this fantastic video. I needed a quick refresher and this video came along at the perfect time. Extra thumbs up for the quick Node example at the end. Keep up the excellent work and thank you!

[@mikeycates4989]

I just want to say that you are one of the key factors in my quick growth in coding and things like html css and javascript as well as this and multiple others and its been really nice to be able to have your knowledge out here and be abel to use that as a base for me and then i can grow from that. So thank you and i look forward to being able to watch your future videos

[@kateasusual4511]

You came to my rescue as always Brad! You truly have the best tutorials.

[@joshsmusicshow9360]

Thank you for changing my life with your videos, appreciate you Traversy

[@skhubs]

Thanks Brad sir, I have been waiting for this MySQL tutorial for several days. Your all tutorial best explanation. So I eagerly look forward to every single video. Thanks Brad sir.

[@bilalhussain5916]

Brad thanks for always being able to thoroughly explaining every aspect of the new tutorials you post.

[@kimokimo-se3ur]

a very clear course ! the theory , the practice and a real life use case ! thank you brad for such a great content !!

[@michellewilliams1090]

This is exactly what I needed. Thank you my hommie

[@jjgillian3567]

Clicked like even before I watch the video. I already knew this course will be awesome. Thank you Brad. :)

[@ruchiragarwal4741]

Thank you so much Brad. The video really helped me brush up the sql commands well enough while quickly learning in how to consume mysql in my node js application. Very informative !!

[@MyReviews_karkan]

Man, you make everything so easy to learn. My two favorite so far are you and Mosh. I've learned so much from you two. Thank you so much, man.

[@MyReviews_karkan]

@KENAN AMIRLi Mosh is really good, but he always limits his free courses so you buy his paid ones.

[@CODINGISEASY]

*Nice MySQL tutorial.* I have forgotten lots of this since using laravel eloquent

[@apurvak9057]

You are God. I almost finished the course and was thinking about how to implement it in a project and you even helped with that in the last segment. impressed as always.

[@baussier134]

Thank you! I learned it properly at college, but it has been so many years untouched, until I found your course! You really helped me

[@cytuber]

Ohhh yeah!! I'd love a course on MySQL Workbench (just had to stop and say that... now back to the video...)

[@allex3842]

This is exactly what I need. Thanks Brad!

[@wasiquehaider4727]

my man Brad is back

[@TheSafar]

that's been of great help! People do appreciate your efforts

[@JTexCasino]

Using this as interview prep. Thanks!

[@yalikunisaierdar8948]

Thanks Brad. This course came just on time.

[@puja6964]

Thanks Brad,I learnt so much from you,just completed the video.

[@hiranhasanka2164]

Dude Your crash courses are awesome! Keep it up!!

[@benjaminsujith]

Thank you so much Brad for being such a wonderful teacher..

[@rubensmailbag]

Great tutorial. Made everything crystal clear for me.

[@Burak-pl1jl]

First of all, thank you for all the tutorials you've been making. They helped me a lot! At 42:26, If we wanted to write the same query without using IN(...) Then it would've been ... WHERE dept = 'sales' OR dept = 'design';

[@JayPatel12928]

Paused the vid, came in the comments section, to comment the same :)

[@NickHope]

Correct. The IN operator allows you to determine if a specified value matches ANY value in a set of values or returned by a subquery, not ALL the values, as the video implies.

[@tadakuniyasuda8214]

This channel is the best thing that ever happen to me.

[@princemusole6225]

Gosh Brad is amazing. So I'm wondering, the people who have disliked this video, why are you even subscribed?

[@WendyLiving]

Thanks for this crash course, it really gave me an in-depth understand on MySQL.

[@harshshastri6099]

Just a Massachusetts Developer helping other Massachusetts Developers out LOL. Thanks for a wicked awesome comprehensive video bud

[@antonioaraujo6042]

Helping me in the new job a lot.... tks brad

[@abdirahem221]

Friend, brother, teacher Brad thank you. ❤

[@klaus6178]

Uhhhhhh...

[@studyabroad4free19]

Brad you are such an inspiration. Thanks a lot for this video

[@cedvlogs7087]

Thanks for making this course!!!

[@eligbuefelix7988]

Thanks a lot

[@ryann7741]

yayy soo happy I found this ..thank you

[@nat.serrano]

Great tutorial, no bullshit, no ego, not pretending to be smarter/superior, clear, concise, etc

[@mogli3leo]

Thanks mate, great video. It helped me a lot to get a grasp on the basics.

[@BruceMbayoPanda17]

Brad please i really like all your works, could you make a course for PostgreSQL

[@LatinoWebStudio]

awesome video! Something I found interesting is how to select all you use the asterisk (*) which is the same as in CSS. So it amazes how they relate to each other even tho they're different type of languages.

[@bhavukgarg3619]

You gave me more information than my professor could ever give me.😁👌

[@rediet6620]

you the best brad thank you so much. love & respect

[@7XStriderX7]

Awesome video, as always! Thanks!

[@lokmanhossainpappu5096]

Thanks Brad. such a informative beginners friendly course

[@kebincui]

Very clear explanation👍

[@evanilsonp.8183]

Hey man thanks for the tutorial on MySql. It was pretty amazing.

[@dwarikaprasad5836]

Awesome Video.Really great kickstart indept learning of mysql

[@RonnieLutaro]

This is one of the best SQL crash courses on the web I think.

[@ahmed_mansour5]

Very helpful as usual. Thanks so much !!

[@DanielK48]

Great video, Brad! Would love to see a tutorial on MySQL Workbench :)

[@josevivas4902]

Hi, I Greatly appreciate your tutorials @Traversy Media

[@ActionParsnip]

Awesome video with simple examples. Great style

[@avinashmaggidi9749]

Love u brad and for this amazing stuff always..stay blessed❤️.Everytime we keep waiting to learn from your videos when you are uploaded ..

[@pbo8896]

you my boy helped me a loooottttttt! thanks man

[@jariftanjimmm]

1.2 million is still not enough for you... Your video worth over 5 million❤️

[@danielc4267]

thanks for telling us to do research on join (inner, left, right). I am glad I did. :D

[@atiqure2000]

Great Work!!! Learned a lot. Thanks...

[@bassguitarist2686]

Thanks Brad for the tutorial!

[@marcostrevinorodriguez1254]

Amazing video man, thanks a lot for this

[@indiansoftwareengineer4899]

nice course sir. waiting for next video- SQL project with NodeJS.

[@locksfamily]

Right on time Brad, as usual.

[@soulaimane3729]

I like your accent brad , i'm from morocco and my accent is almost like you hahaha , love uuu

[@mohedul]

Thank you! Excellent explanation!

[@zt.5677]

Thank you Brad. The video and the sheet as well.

[@InfinyTravel]

Great lesson, thank you!

[@antonioaraujo6042]

Thank you Brad, your courses rocks!

[@mohdhasnain3812]

bro i have an interview 2 days ahead is this tutorial enough for answering basic sql commands and all???

[@mohammedal-haifi6037]

This is awesome, Thank you very much, great course.

[@hotubetv975]

Brad you are great! I love your videos

[@joshuamuotoh6218]

alaye wad up

[@fam.tuturu]

Great video! Very helpful.

[@marciomafideju1775]

Wow!!! Right on time!!!!

[@Equipois3]

This was wonderful, thank you

[@petrmach8677]

Well done! Thanks for the video!

[@tijani3141]

Brad u are the man, I love you man

[@Ashkou623]

Seems like a good tutorial, going to watch it

[@adamjamiu6764]

Thanks Brad. you are a game changer. please can you do a video on "deploying MySQL" tutorial. thanks will really appreciate

[@KRoc]

As always, really loved the video. Everybody should check out his Udemy courses. It has really improved my understanding of web development.

[@aanfcnig]

i love your tutuorials !!!

[@hashaamzahid3319]

Thanks Brad, For boosting my Skills

[@pitchblackc0d314]

Love learning from your Chanel, awesome voice I can hear every word, I love it wen u make a funny noice when your not talking lol but it's really difficult to type it out, I'm gonna try any way lol Here we go... "Chu chu chu" Watch Crash course of html and css your going hear it if you haven't.... peace ✌✌✌ learners, I'm also one lol..... Thanks Brad your the best ever .....

[@mauriciosotoa8130]

as always very good content, carefully explained.

[@lattesu_]

awesome tutorial, thank you!

[@rugmaable]

Thanks for the informative video. I have never worked with mysql or any database, I am learning the basics. Anyways this video will help me build on and keep learning.