Тёмный

MySQL Crash Course | Learn SQL 

Traversy Media
Подписаться 2,3 млн
Просмотров 474 тыс.
50% 1

Опубликовано:

 

17 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 381   
@TraversyMedia
@TraversyMedia 5 лет назад
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
@kreshnikpalushi1587 5 лет назад
Pin this comment
@holachinazori1591
@holachinazori1591 5 лет назад
can you please stop posting tutorials , i can't just watching your videos . 2017 2018 2019 ...
@taariqq
@taariqq 5 лет назад
@@holachinazori1591 .. lol
@taariqq
@taariqq 5 лет назад
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
@sodiqoyedotun3185 5 лет назад
Can you post a link to the MySQL cheat sheet you are using
@jlambert12013
@jlambert12013 3 года назад
This was so much easier than I anticipated. Brad is the only person who can explain programming to beginners on RU-vid
@mikec360
@mikec360 5 лет назад
Just as I was looking for a competent MySQL tutorial your video pops ups.Brad you are always right on time. Be blessed
@francishalloun7531
@francishalloun7531 5 лет назад
Same here
@balimerouane8341
@balimerouane8341 5 лет назад
Bruh! same.
@quanganhvu4231
@quanganhvu4231 5 лет назад
Same here :)
@taariqq
@taariqq 5 лет назад
He's got the finger on the pulse. No doubt.
@superxereu
@superxereu 5 лет назад
I've been doing SQL for 20 years and MySQL for 18, this crash course is simply superb!!!
@jameskamonga6233
@jameskamonga6233 5 лет назад
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
@koggism
@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.
@baussier134
@baussier134 7 месяцев назад
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
@MrPDTaylor
@MrPDTaylor 5 лет назад
The day I decide to learn MySQL Brad uploads this video. It's definitely a sign.
@kamilka-visuals
@kamilka-visuals 5 лет назад
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!
@taariqq
@taariqq 5 лет назад
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.
@bulcub
@bulcub 5 лет назад
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.
@Burak-pl1jl
@Burak-pl1jl 5 лет назад
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
@JayPatel12928 5 лет назад
Paused the vid, came in the comments section, to comment the same :)
@NickHope
@NickHope 4 года назад
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.
@stevepatterson3822
@stevepatterson3822 5 лет назад
You uploaded this a day before my Database Systems exam, this is why you're my favorite channel!
@apurvak9057
@apurvak9057 4 года назад
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.
@elijahromer6544
@elijahromer6544 3 года назад
Brad, I consider you to be the person who taught me everything. Thank you for all that you do.
@kramseyart7663
@kramseyart7663 5 лет назад
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!
@mikeycates4989
@mikeycates4989 3 года назад
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
@Dumpstermonkey19
@Dumpstermonkey19 5 лет назад
Really needed this refresher after having used NOSQL databases for so long. It made my day when I saw this in my notifications.
@nat.serrano
@nat.serrano 3 года назад
Great tutorial, no bullshit, no ego, not pretending to be smarter/superior, clear, concise, etc
@brenthearn2578
@brenthearn2578 2 года назад
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!
@AndresGarcia-lo4yr
@AndresGarcia-lo4yr 5 лет назад
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.!!
@tadakuniyasuda8214
@tadakuniyasuda8214 2 года назад
This channel is the best thing that ever happen to me.
@gavin_z28
@gavin_z28 4 года назад
i have been struggling with sql for so long and this is just what I needed to get started thank you so much!
@emmanueleze3028
@emmanueleze3028 5 лет назад
Thanks Brad, God bless you. Love from Lagos, Nigeria.
@RonnieLutaro
@RonnieLutaro 4 года назад
This is one of the best SQL crash courses on the web I think.
@CODINGISEASY
@CODINGISEASY 5 лет назад
*Nice MySQL tutorial.* I have forgotten lots of this since using laravel eloquent
@cytuber
@cytuber 5 лет назад
Ohhh yeah!! I'd love a course on MySQL Workbench (just had to stop and say that... now back to the video...)
@LatinoWebStudio
@LatinoWebStudio 3 года назад
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.
@balimerouane8341
@balimerouane8341 5 лет назад
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.
@BruceMbayoPanda17
@BruceMbayoPanda17 5 лет назад
Brad please i really like all your works, could you make a course for PostgreSQL
@harshshastri6099
@harshshastri6099 3 года назад
Just a Massachusetts Developer helping other Massachusetts Developers out LOL. Thanks for a wicked awesome comprehensive video bud
@yayo685
@yayo685 4 года назад
Dear Traversy Media, After having an infection and being hospitalized I was behind on my database class by a little over 2 weeks. I wasn't able to get caught up with a lot of websites that were given and the other students recommended to me. With this tutorial and probably a few more, I am confident that I can get the gist of MySQL and hopefully start to get caught up. Thank you!
@unknownman1
@unknownman1 4 года назад
were you corona infected?
@yayo685
@yayo685 4 года назад
@@unknownman1 No it was a infection on a different part of my body caused by stress. Thanks for asking though.
@unknownman1
@unknownman1 4 года назад
@@yayo685 take care man. BTW nice name "Hayabusa" my dream bike
@ruchiragarwal4741
@ruchiragarwal4741 3 года назад
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 !!
@debadipti
@debadipti 5 лет назад
Great time Brad! I just finished SQL yesterday! Happened 2nd time after React JS
@jariftanjimmm
@jariftanjimmm 4 года назад
1.2 million is still not enough for you... Your video worth over 5 million❤️
@MyReviews_karkan
@MyReviews_karkan 5 лет назад
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
@MyReviews_karkan 4 года назад
@KENAN AMIRLi Mosh is really good, but he always limits his free courses so you buy his paid ones.
@taariqq
@taariqq 4 года назад
5:15 valuable info. Puts the mind at ease. [edit] Sorry, 50:15 - he note about join types and "inner joins".
@kecc
@kecc 5 лет назад
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!
@devinmitchell2226
@devinmitchell2226 5 лет назад
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.
@adamjamiu6764
@adamjamiu6764 2 года назад
Thanks Brad. you are a game changer. please can you do a video on "deploying MySQL" tutorial. thanks will really appreciate
@bilalhussain5916
@bilalhussain5916 3 года назад
Brad thanks for always being able to thoroughly explaining every aspect of the new tutorials you post.
@kimokimo-se3ur
@kimokimo-se3ur 2 года назад
a very clear course ! the theory , the practice and a real life use case ! thank you brad for such a great content !!
@lokmanhossainpappu5096
@lokmanhossainpappu5096 7 месяцев назад
Thanks Brad. such a informative beginners friendly course
@JTexCasino
@JTexCasino 5 лет назад
Using this as interview prep. Thanks!
@kateasusual4511
@kateasusual4511 5 лет назад
You came to my rescue as always Brad! You truly have the best tutorials.
@WendyLiving
@WendyLiving 3 года назад
Thanks for this crash course, it really gave me an in-depth understand on MySQL.
@eggxecution
@eggxecution Месяц назад
finished nice! Easy to learn well it'll take time to remember
@kebincui
@kebincui 3 года назад
Very clear explanation👍
@marggames98
@marggames98 5 лет назад
If anybody else is having issues going through mysql downloads like i was, i went ahead and dowloaded xampp and it was a lot easier to get through on the command line
@rugmaable
@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.
@antonioaraujo6042
@antonioaraujo6042 3 года назад
Helping me in the new job a lot.... tks brad
@aneuroticdog
@aneuroticdog 4 года назад
It is a Relational Data base because the central construct is a table with rows and columns. In mathematics, where Relational Database theory originated, A table with rows and column is called a Relation.
@joshsmusicshow9360
@joshsmusicshow9360 5 лет назад
Thank you for changing my life with your videos, appreciate you Traversy
@evanilsonp.8183
@evanilsonp.8183 Год назад
Hey man thanks for the tutorial on MySql. It was pretty amazing.
@piezoelectric100
@piezoelectric100 5 лет назад
support Brad on Patreon if you can, he makes all this amazing content for free. least we can all do is pledge one dollar a month
@rogdex24
@rogdex24 5 лет назад
yeah man
@skhubs
@skhubs 5 лет назад
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.
@Hemmohammad
@Hemmohammad 5 лет назад
Friend, brother, teacher Brad thank you. ❤
@klaus6178
@klaus6178 3 года назад
Uhhhhhh...
@josevivas4902
@josevivas4902 2 года назад
Hi, I Greatly appreciate your tutorials @Traversy Media
@911madza
@911madza 5 лет назад
Props for doing it hard way and NOT using phpMyAdmin :)
@jjgillian3567
@jjgillian3567 5 лет назад
Clicked like even before I watch the video. I already knew this course will be awesome. Thank you Brad. :)
@eljanabbasov6953
@eljanabbasov6953 5 лет назад
the best tech teacher ever
@basil_b_vegan
@basil_b_vegan Год назад
Great video. I am excited to develop and harness these various tech skills and technologies to better the world and myself. Thank you for your leadership in helping others and being responsible for the outcomes of our lives
@ryann7741
@ryann7741 3 года назад
yayy soo happy I found this ..thank you
@PooriyaA-m8f
@PooriyaA-m8f 4 месяца назад
You'r the best, thank you!!
@puja6964
@puja6964 4 года назад
Thanks Brad,I learnt so much from you,just completed the video.
@hiranhasanka2164
@hiranhasanka2164 4 года назад
Dude Your crash courses are awesome! Keep it up!!
@bhavukgarg3619
@bhavukgarg3619 4 года назад
You gave me more information than my professor could ever give me.😁👌
@danielc4267
@danielc4267 4 года назад
thanks for telling us to do research on join (inner, left, right). I am glad I did. :D
@TheSafar
@TheSafar 5 лет назад
that's been of great help! People do appreciate your efforts
@princemusole6225
@princemusole6225 5 лет назад
Gosh Brad is amazing. So I'm wondering, the people who have disliked this video, why are you even subscribed?
@KRoc
@KRoc 5 лет назад
As always, really loved the video. Everybody should check out his Udemy courses. It has really improved my understanding of web development.
@its_maalik
@its_maalik 5 лет назад
This tutorial would have been a lot unique if you took a dive intro Procedures, Cursors, Triggers, Views and Transactions rather than these basic concepts. Don't get me wrong, the video is still great but there are very very few QUALITY videos on those 5 topics so I was expecting you to cover them..love from india
@dwarikaprasad5836
@dwarikaprasad5836 Год назад
Awesome Video.Really great kickstart indept learning of mysql
@kardashevr
@kardashevr 5 лет назад
Brad, I desperately need an ngrx course. I've watched countless tutorials and courses about ngrx and almost understood nothing. Please please please provide us with a clear and well paced one. Thanks in advance.
@sportsfiesta25
@sportsfiesta25 4 года назад
Brad you are such an inspiration. Thanks a lot for this video
@rubensmailbag
@rubensmailbag 5 лет назад
Great tutorial. Made everything crystal clear for me.
@indiansoftwareengineer4899
@indiansoftwareengineer4899 5 лет назад
nice course sir. waiting for next video- SQL project with NodeJS.
@soulaimane3729
@soulaimane3729 5 лет назад
I like your accent brad , i'm from morocco and my accent is almost like you hahaha , love uuu
@MysticalMamba
@MysticalMamba 5 лет назад
Instead of doing INSERT INTO users(keys names) values (entered values), we can directly do INSERT INTO users VALUES(values for the keys). No need to type the keys again and again just to save you some time.
@michellewilliams1090
@michellewilliams1090 5 лет назад
This is exactly what I needed. Thank you my hommie
@yalikunisaierdar8948
@yalikunisaierdar8948 5 лет назад
Thanks Brad. This course came just on time.
@philbrk8750
@philbrk8750 2 года назад
When I learn a Topic I watch multiple tutorials to gain different explanations and views on it. Basically ist always the Same Pattern: Fireship for general/broad overview Your Explanations/Channel is great for getting a detailed overview of a more in depth functionality and then there is Codeevolution/Freecodecamp for in-depth understanding which would overload you and make you loose the bigger picture if you only did that. Thank you for being part of my learning journey, your ability to teach this stuff is incredible.
@sibral8413
@sibral8413 4 года назад
Hello! Please tell me, I can get a job if I know only MySQL? Or do you have to learn something else, and if so what? What would be a learning strategy? Languages, tools, etc? Thank you very much
@allex3842
@allex3842 5 лет назад
This is exactly what I need. Thanks Brad!
@katendenicholas4052
@katendenicholas4052 4 года назад
Am were am I now because of Brad thanks man
@hotubetv975
@hotubetv975 5 лет назад
Brad you are great! I love your videos
@joshuamuotoh6218
@joshuamuotoh6218 5 лет назад
alaye wad up
@wasiquehaider4727
@wasiquehaider4727 5 лет назад
my man Brad is back
@JohnWickXD
@JohnWickXD 3 месяца назад
Thank you so much for such an awesome course
@mogli3leo
@mogli3leo 5 лет назад
Thanks mate, great video. It helped me a lot to get a grasp on the basics.
@benjaminsujith
@benjaminsujith 5 лет назад
Thank you so much Brad for being such a wonderful teacher..
@jariftanjimmm
@jariftanjimmm 4 года назад
I am not sure. but i heard that mysql is not secure..mysqli is the uodates version of mysql. If so,Should I still learn these?
@mouhcineoussama5532
@mouhcineoussama5532 3 года назад
You have been such a tremendous help to me during this time. Thank you so very much!
@fernandes1431
@fernandes1431 4 года назад
Can MySql not be downloaded from the website as opposed to using the terminal? Thank you.
@ActionParsnip
@ActionParsnip 4 года назад
Awesome video with simple examples. Great style
@inversion_media
@inversion_media Год назад
jason is my favorite data type
@cedvlogs7087
@cedvlogs7087 5 лет назад
Thanks for making this course!!!
@eligbuefelix7988
@eligbuefelix7988 5 лет назад
Thanks a lot
@Aisap77
@Aisap77 2 года назад
I followed your videos. I can connect to server and i create database and tables. But unfortunately when I run my workbench it can connect to the server by checking the status, the problem I noticed is the displayed details is different, I can't find the option of administration and schemas to find my tables and database. It shows only the objection panel and session panel. How is it work?
@saddietaylor9857
@saddietaylor9857 2 года назад
Do you know why when I try to add it to my PATH permanently it won't work, but the current session one will?
@NedumEze
@NedumEze 5 лет назад
Hi, Brad, I created a column to store text intended for use as content for the title attribute for my anchor tags. But when I try to display them in the title=" $title"; attribute, only one word shows in the pop up!! The rest of the text are treated as other attributes without values! Please, what can I do enable the entire title text display in the popup?
@marciomafideju1775
@marciomafideju1775 5 лет назад
Wow!!! Right on time!!!!
Далее
MongoDB Crash Course
36:43
Просмотров 759 тыс.
Full SQL Crash Course - Learn SQL in 90 Minutes
1:28:09
СТАЛ КВАДРОБЕРОМ
00:34
Просмотров 112 тыс.
SQL Tutorial for Beginners [Full Course]
3:10:19
Просмотров 11 млн
MySQL Full Course for free 🐬
3:00:00
Просмотров 2 млн
Learn SQL In 60 Minutes
56:24
Просмотров 2,1 млн
Что такое SQL?
7:11
Просмотров 337 тыс.
Learn SQL Basics in Just 15 Minutes!
16:57
Просмотров 160 тыс.