MySQL Tutorial

MY UDEMY COURSES ARE 87.5% OFF TIL December 19th ($9.99) ONE IS FREE

Welcome to my MySQL video tutorial. I'll cover 95 - 98% of everything you'll ever need to know in one video.

I cover creating / destroying databases, creating / destroying tables, data types, NULL, DEFAULT, ENUM, AUTO_INCREMENT, primary keys, foreign keys, atomic data, normalized, DESCRIBE, INSERT, ALTER, SELECT, SHOW, RENAME, WHERE, logical operators, comparison operators, ORDER BY, GROUP BY, LIMIT, string operators, joins, LIKE, DISTINCT, math functions and more.

Like the channel? Consider becoming a Patreon! Check it out here:

*Watch More Learn in One Videos*

[derekbanas]

Learn in One Videos for Every Programming Language

[pabloescobanjo]

here i collect my personal bookmarks that I will use later (use them or ignore them):
3:55 create table
7:08 primary key
15:24 foreign key
26:07 concat
26:45 where & like
29:05 count
29:45 as, group by & having
30:14 math functions
30:45 built in numeric functions
33:14 alter table
34:46 update
36:00 join

[bashbrannigan]

Great video. Very concentrated, but still comprehensible. You can read all this in books, but watching someone actually do it is invaluable. Also, there must be a great job of editing done here, because I can't believe anyone could have done all this demo in one shot.

[kamaaladiin]

For those who are struggling connecting to their database( This is windows users)
Find your Xampp insallation path for me the path is C:\Xampp\mysql\bin
1- Open Command prompt and enter the followin- do not enter the list numbers :)
2- CD/ then press enter
3- C: then press enter again.
4- CD Xampp press enter again ( note Xampp is a file I stored my xampp, CD means go to this file)
5- CD mysql then press enter
6- CD bin then press enter.
7- mysql -u root -p then enter( if you made a password enter your password after -p
Then after that you are ready.

[sarfarazghulam]

Crazy Man! Explained one semester course in 40 mins LOL.
Could have been even better if procedures and triggers were covered.
Thanks a lot!

[TheDroc]

On a sidenote, Derek you win the YouTube Respond to Comments and Fans award. Thanks for always interacting with us and making great content.

[pedromoraes]

It's the best introduction to mysql i've ever seen, congratulations. Not even the programmers i've met in my previous internshipment know that much.

[cbweinermoate]

As someone who is breaking into the software developer world, I always come to your videos first whenever I need to learn a new language/framework/skill. There is nobody else doing video tutorials that are as easy to follow and informative as yours. Production quality is high, you're easy to understand. A+ work sir, please keep it up.

[maryrosepetalio]

i'm having my final interview tomorrow, and this video helped me a lot in recalling mysql after a year. Thanks a lot! this video is great. thanks for doing this.

[megaslayz]

if only my teachers were this efficient

[bobstalnaker]

Thank you for taking the time to make this tutorial. I'm an adult working student and your explantions are so much better than my teachers.

[DecaSpace]

THIS VIDEO HELPED ME LAND A SWEET JOB!!! THANK YOU,

[ChaosRevealsOrder]

This vid = 1-2 Months of study worth of info, so glad that a friend told me about it !

[vzangla]

That was awesome! I've never seen such speed and thoroughness. If it's a new concept the viewer can pause, digest, research, come back later etc. But if you already know it and you just haven't seen it in a while you can get through all of the material very quickly. You could spend YEARS being a DBA and never see the end to end installation, architecture, normalization and ETL that we just saw in less than an hour.

[tinopenhor]

rare to see a single educational content here on youtube with over 1 million views. You are simply awesome at what u do. My congrat Mr. Derek, u deserve it all.

[priyankagaekwad]

Watched entire video and its awesome. Very detailed oriented and almost all commands are covered under one video. Thats perfect.

[曲-em]

This is probably the most easily digestible MySQL refresher available anywhere! Thanks for all the time and effort you put in Derek!

[ElisandroDeLeon]

Got a job. This was the first thing I used in combination with a treehouse trial and other online challenges to land a job. Its a good quick overview / refresher.

[macadamia]

I have been watching this video over and over as I take my database class. I had an assignment that I completed yesterday where I was supposed to use GROUP BY, but unfortunately, I could not get it to work. I finished watching your video today and now I know how to use the GROUP BY. The "cheat sheet" is a great resource and I have printed it out and will refer to it as I complete the rest of the assignments.

Some say it is too fast; I disagree. I had to stop and start the video many times and even re-watch sections to make sure I understood. The nice thing is there is no minutia. Your video along with the Sams Teach Yourself SQL in 10 Minutes book, by Ben Forta, have helped me immensely! I have subscribed to your feed and plan to watch / review all of your videos.

Thank you very much for teaching me more in this hour-long video than my entire eight-week database management​ class.

[shamofengbao]

This is the best tutorial, concise, and all inclusive. I really hate those tutorials where the narrator feels very chatty and wastes 40 minutes talking about something that could've been said in 10 minutes...
You sir, are awesome! thank you very very much!