MySQL Crash Course | Learn SQL

Sponsor: DevMountain Bootcamp

MySQL Cheat Sheet:

💖 Become a Patron: Show support & get perks!

Website & Udemy Courses

Follow Traversy Media:

[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

[jlambert]

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

[mikec]

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

[superxereu]

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

[jameskamonga]

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

[MrPDTaylor]

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

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

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

[stevepatterson]

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

[Burak-pljl]

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';

[baussier]

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

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

[emmanueleze]

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

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

[CODINGISEASY]

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

[BruceMbayoPanda]

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

[kramseyart]

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!

[Hemmohammad]

Friend, brother, teacher Brad thank you. ❤

[devinmitchell]

In mysql > 5.0.3, VARCHAR has the same max length as a TEXT Field, just fyi
The difference is, is VARCHAR requires you to set the length, whereas TEXT doesn't have a length set.

[elijahromer]

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