MySQL Full Course for free 🐬 (2023)

Подписаться 1,9 млн

Просмотров 1,7 млн

50% 1

#MySQL #SQL #tutorial
MySQL SQL tutorial for beginners 🐬
⭐ TIME STAMPS ⭐
#1 00:00:00 MySQL intro + installation
00:02:22 Windows installation
00:06:05 MAC OS installation
#2 00:10:29 DATABASES
#3 00:14:29 TABLES
#4 00:22:38 INSERT ROWS
#5 00:28:32 SELECT
#6 00:33:32 UPDATE & DELETE
#7 00:37:03 AUTOCOMMIT, COMMIT, ROLLBACK
#8 00:39:41 CURRENT_DATE() & CURRENT_TIME()
#9 00:42:26 UNIQUE
#10 00:47:09 NOT NULL
#11 00:50:01 CHECK
#12 00:53:58 DEFAULT
#13 01:02:16 PRIMARY KEYS
#14 01:07:41 AUTO_INCREMENT
#15 01:11:36 FOREIGN KEYS
#16 01:19:52 JOINS
#17 01:24:55 FUNCTIONS
#18 01:28:40 AND, OR, NOT
#19 01:34:37 WILD CARDS
#20 01:38:55 ORDER BY
#21 01:41:31 LIMIT
#22 01:44:24 UNIONS
#23 01:48:37 SELF JOINS
#24 01:58:39 VIEWS
#25 02:04:41 INDEXES
#26 02:11:06 SUBQUERIES
#27 02:17:52 GROUP BY
#28 02:23:00 ROLLUP
#29 02:26:50 ON DELETE
#30 02:34:20 STORED PROCEDURES
#31 02:42:22 TRIGGERS
Copyright Disclaimer:
This video is the intellectual property of Bro Code. All rights reserved. No part of this video may be reproduced, distributed, or transmitted in any form or by any means, including but not limited to recording, uploading, or other electronic or mechanical methods, without my written permission, except in the case of brief quotations embodied in critical reviews and certain other noncommercial uses permitted by copyright law.

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

30 июн 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 1,1 тыс.

@BroCodez Год назад

The RU-vid algorithm no longer cares about likes and comments Be sure to share the video with a friend if you like it Don't let my hard work go to waste 😭 ⭐ TIME STAMPS ⭐ #1 00:00:00 MySQL intro + installation 00:02:22 Windows installation 00:06:05 MAC OS installation #2 00:10:29 DATABASES #3 00:14:29 TABLES #4 00:22:38 INSERT ROWS #5 00:28:32 SELECT #6 00:33:32 UPDATE & DELETE #7 00:37:03 AUTOCOMMIT, COMMIT, ROLLBACK #8 00:39:41 CURRENT_DATE() & CURRENT_TIME() #9 00:42:26 UNIQUE #10 00:47:09 NOT NULL #11 00:50:01 CHECK #12 00:53:58 DEFAULT #13 01:02:16 PRIMARY KEYS #14 01:07:41 AUTO_INCREMENT #15 01:11:36 FOREIGN KEYS #16 01:19:52 JOINS #17 01:24:55 FUNCTIONS #18 01:28:40 AND, OR, NOT #19 01:34:37 WILD CARDS #20 01:38:55 ORDER BY #21 01:41:31 LIMIT #22 01:44:24 UNIONS #23 01:48:37 SELF JOINS #24 01:58:39 VIEWS #25 02:04:41 INDEXES #26 02:11:06 SUBQUERIES #27 02:17:52 GROUP BY #28 02:23:00 ROLLUP #29 02:26:50 ON DELETE #30 02:34:20 STORED PROCEDURES #31 02:42:22 TRIGGERS

@javohirtoirov8793 Год назад

Bro do videos about django, django rest framework, rest API.. I appreciate your work 👏

@fatimaezzahra9149 Год назад

Hello bro thank you for helping us about Data in general 👏👏👏 , please can you helping us in SQL3 i really appreciate your work 💕💕💕

@mohdshawalsidek1452 Год назад

sure

@hooradfarokh5464 Год назад

We would never let your hard work go to waste 💖💖

@hoatranminh5216 Год назад

Thank you so much for your hardword, Bro. Your works help me so much in changing to coding domain after Economics university graduation. Your work will never go to waste, Bro

@DefinedCmajor Год назад

Alright ladies and gentlemen, i am ready to make my mom a website for her coffee shop

@TheCollectiveHexagon Месяц назад

Did you manage to do it?

@DefinedCmajor Месяц назад

@@TheCollectiveHexagon >she already has one i found out >only helping with bugs >proceed to pursue music

@gopeshsharma2059 Месяц назад

@@DefinedCmajor great man , all the best for your music thing

@MythicalBrew Месяц назад

W son/daughter 💯💯

@groundzero82 19 дней назад

Why not share your mom's coffee shop website?

@omxln237 Год назад

My God you’re a saviour starting a module on sql when I return form winter break. The way you explain topics in other videos such as Java are really helpful. Definitely looking forward to this one. Thankyou ❤

@princeakinolaoluwagbemigag1750 Год назад

I started this 5 days ago. Now you've made the full compilation. Thank you BRO!!!

@omotoshoabimbola7911 10 месяцев назад

This is the first video that explains from scratch, I've come across so many and it keeps looking cryptic, but yours is perfect for a total beginner. Thank you so much.

@master11213 Год назад

thank you so much for making this mysql course. you get right into the topics without need to download files and prebuilt databases to work with. this course is helping me get onto the path of cloud computing.

@Arichanice Год назад

i went to school, graduated on came across your videos and WOW! you made these videos seem so easy and very detailed i wish i knew about your channel before getting into school because just one video i've learned way more than i did in my paid courses.. you are amazing thank you so much!

@k.h.p.9862 10 месяцев назад

Thanks for this tutorial. Also learned a lot from your older Python tutorial. I'm a newbie to all this. Your clear explanations and very clear audio (your speaking style comes through loud and clear, an asset that most other videos don't have) are a huge plus for learning, enabling learners to focus on learning without distractions. Thanks again, Bro Code.

@JohnWickPotter Год назад

I wanted to thank you for this video. I started from ground 0 with SQL & because of you I feel like I have a foundation! Next up is more training videos to keep building upon that foundation. I will always recommend this video for anybody wanting to learn SQL with little to nothing beforehand of experience.

@samyakhp4353 18 дней назад

Where do you go from here? Can you share some links or what to do specifically?

@JohnWickPotter 18 дней назад

@@samyakhp4353 it no longer takes precedence in my line of work so I ended up needing only topical level knowledge. Enough to ask question but not enough to be effective with SQL.

@matthewmurdock7329 Год назад

I was waiting for this! You’re a real hero, thank you 💪

@FBI-UIU Год назад

Happy new year!! Thank you for teaching us!! We wish you staying healthy!!

@bad_writer04 Год назад

Good job in teaching! I learned a lot from this video. Three days straight and just finished the course today. thanks :)

@luisalbertovillarortiz7424 Год назад

What a relief That I came across to/with your swift but in-depth and doable way to teach. Even better your accent is clear and clean, thanks so much!!! At last I no longer scary about SQL... my best regards from Mexico!! Many thanks Bro Code!!!!

@Kei-in7od Год назад

I'm on the 4th hour on your 12 hours Python course (excellent), I was willing to learn SQL after it, and there you are posting an SQL Full course. Thank you for the work you're doing you helped a lot of people.

@SA-fy8th 11 месяцев назад

So do you finish the python course?

@HeadGenCSGO 5 месяцев назад

Hey are you still on 4th hour of Python course?

@purplevanilla 5 месяцев назад

@@HeadGenCSGO probably not. The comment was almost 1 year ago lol

@rabihanaveed. 5 месяцев назад

@Kei-in7od completed or not 😂

@cathupapa6643 Месяц назад

I finished the whole python course and it was worth it....

@jawbreakingcandy836 Год назад

Thank you! I’m doing SQL in uni soon this video was great to get a head start!

@antoniob.6546 Год назад

Amazing course!!! Definitively quality content as always 👌

@brunomocellin Год назад

I didn't watched yet but i know it will the best SQL course. All my 4 Thumbs up for you, keep being a Master Bro.

@yourgamingspot6754 Год назад

I was just looking for the video and I randomly got this video. your teaching style is unique and I will complete the whole video in a week💪.

@xen0076 4 месяца назад

What an amazing teaching, giving simple references like think database as an folder and think of tables as files inside that folder and more here and there and no unnecessary bs around, to the point teaching, This man deserves Heaven.

@joaovictorbrum_ 5 месяцев назад

Thank you for all of your courses that you have been posting here on RU-vid. It's really helping me to develop my programming skills more and more. Yesterday i finished the C Language course from this channel. Love from Brazil. ❤️

@murtal10 Год назад

Your courses are fantastic. Thank you for your dedication and time, you make the difference. Hug man!

@macshadow1682 Год назад

Bro you're pro in this job, I've learned many things with your help, even my professors don't know to teach like you. Keep going!

@user-ls3nk6cv3t Год назад

This tutorial is a life saver. I have been assigned to a backend role even though i want in a front end role in my internship. I have no clue to what back end is so this is very helpful

@Wisdawms 4 месяца назад

This is the first channel I've come across that makes learning programming truly fun. I really like your personality, my dude. Keep it up!

@neobabylone6249 Год назад

I turned my life around a year ago, found a job as dev MySQL+Java+Angular recently. My API is working thanks to you. Big up for this new course. I might get good with DB now. Happy new year Bro !

@mesaybimrew9750 Год назад

I’m trying to change my life also . Do you think just learning from this video get me job ready?

@neobabylone6249 Год назад

@@mesaybimrew9750 ... Depends on the country, the city and the job you want I'd say. From my experience, getting so good that you'll get a job on a single language is hard. It just takes time to get good. And ... That's my opinion but MySQL is more a tool towards an end rather than a career choice. Unless you're really, really good. However, (in my country at least) you can get a job being okish in a "stack" meaning a database language + backend language + frontend language. Then you're asked to get good on one of the three (usually front or back, and I choose back, java), while understanding what's happening around. I'd say that's the minimum knowledge you need to start looking for a job. It should take 6-9 months with some dedication. You should also check about DevOps Then again, by no means you'll be an expert. So you might have to do several interviews. Best of luck !

@juansalinas788 Год назад

@@mesaybimrew9750 Not my friend, but it's already a good start. Cheer up!!

@rainbownineteen9325 Год назад

If u can master programming languages with real life solutions to problems u r ready to dive into the digital world to make a huge difference

@alpheendomination Год назад

@@mesaybimrew9750 Well this video gives you most of what you need to know, but to truly learn something you have to actually do it as there is so much which you can only learn through experience. Not to mention the fact SQL on its own is useless without something that has a need for a database, such as a website which obviously requires a different set of languages. But this is certainly a step in the right direction!

@josuetorres3281 Год назад

This is my first time watching one of your videos and is AMAZING! I cannot thank you enough for your effort

@Iamagoodperson Год назад

Great video! I learned so much just by watching a couple of minutes of it. I'm glad I found this tutorial and it was offered for free. Thanks for sharing this valuable resource!

@khadijakh8130 4 месяца назад

This is really helpful I encourage everyone looking for a video to start learning SQL to watch this one. It will give all the basics you need to get started.❤

@GreciaDelgadilloTomasevich Год назад

oh Bro, thanks so much for taking the time to teach us SQL the way you do. We really appreciate your time creating such amazing videos. 🙏🙏🙏

@diaal-emad6856 5 месяцев назад

He is definitely the GOAT, he saved me in midterms, and now in the final. What a great guy.

@69nukeee 10 месяцев назад

Awesome job! Thanks a lot for sharing this, it's been a great help for me into refreshing some MySQL concepts and adding some new ones as well (such as stored procedures and triggers). Are you planning to cover cursors as well anytime? Thanks again!

@ibukunoluwafabunmi2685 Год назад

Been waiting for this thank you and happy new year ❤️

@mattg6550 Год назад

Just wanted to say this is awesome, you are awesome. All of these tutorials that cover a wide amount of programming topics AND fund-raise for good causes is really something to see. If that wasn't enough and a 6 hour video is a little daunting to new learners, you have 6 minute(!) videos that cover snippets of important programming topics, all while being the best alternative to videos covering the same topics that are at least 15 minutes long (sometimes 45+!) of filler and rambling.

@dplay6542 Год назад

Man, it was wonderful time. I really understand that i didnt waste time in vain but spent it usefully. Also English is not my first language and i dont know it good, but your speech is well delivered and every word was clear. It helped a lot! Good luck in everything and good health!

@SegunLive Год назад

Hello Bro Code, I have watched one or two of your RU-vid tutorials, and I should give you credit for your style of tutoring and very clear and concise explanations.

@franciscogaius9442 3 месяца назад

been having trouble finding the perfect mysql tutorial video till i came across yours. you're a f*cking legend!

@nhicao3438 11 месяцев назад

Not only you have an exceptional skills in teaching difficult things in a simple way that every one can understand but also you have a sense of humor that captivates the audience's/my focus. You are such a phenomenal. I donated to the good cause. Thanks a million for your exceptional work and effort.

@BrianDc-vf1og Год назад

Liked without even starting it, I am about 3 hours into your Java swing lecture and i am learning so much from it! This morning I was researching what exactly SQL and JDBC is and boom! here is a 3-hour youtube video from the best Java Channel. Thank you for what you do Bro!!!

@mr_frost65 7 месяцев назад

Thanks a lot for this course! Before it, I didn't know anything about MySQL, but now I've learnt everything you were talking about in the video. The best MySQL course!

@Vivek-dt3sr Год назад

Hey Bro, Happy New Year and thank you so much for all you hard work that you're doing for us & I hope you will gain more students/subscribers this year.

@sanaalam_ 11 месяцев назад

I usually don’t comment, but I completed 1 hour of this free course and it’s very easy to understand. Thank you Bro code.

@Victor-xx1vv Год назад

For everyone wondering why updating a row is giving you an error code of 1175 you need to set the columns in backticks example SET `employee_id` = 1 WHERE `first_name` = "Eugene" backticks are used to reference columns do turn off safe mode

@emekaotikpa2352 10 месяцев назад

Exactly, facing similar issues , Thanks Dude

@MohammedAhmed-yn4oj 10 месяцев назад

The backticks you've mentioned are used in MySQL to quote identifiers, such as column names. They can be particularly useful if your identifier names include spaces, hyphens, or other characters that might otherwise cause a syntax error, If you want to run an UPDATE statement that doesn't include a key in the WHERE clause, and you're getting error 1175, you can turn off the safe update mode. You can do this by running the following command: SET SQL_SAFE_UPDATES = 0; Then, you can run your UPDATE statement

@emekaotikpa2352 10 месяцев назад

@@MohammedAhmed-yn4oj on MySQL workbench ?

@elismith6048 Год назад

Thank you very much for the video! You don't truly know how much you help with learning.

@user-gy3vl6ft6x Год назад

Great job Bro'.Your videos are awesome.Keep up the good work !

@DeyustianPxl Год назад

i really respect you dude, you made a great tutorial with detailed explanations and for free, also you open charity for helping childs... thanks for being kind like this... also keep going i really thankful for this tutorial.. 🤟

@grimjim8463 Год назад

Just got to the MySQL part of the php course.. Now I'm here to learn MySQL before going back to finish off the php course. Great content!

@1001bit Год назад

same

@zb2747 Год назад

Bro literally RIGHT ON TIME - thank you brother!

@joyanzaku6632 11 месяцев назад

Thank you, I have been watching videos on how to create database and tables in MySQL but I could not understand, thank you again for simplifying everything

@Lalmaya508 Год назад

your are a legend man 🔥🔥🔥🔥🔥🔥keep it up

@globalgrowth343 Год назад

I followed you in Python and there you are again. I am super excited to watch this 3hrs. Thank you

@sonya5568 7 месяцев назад

Yes..........stumbled on your youtube. Thanks for teaching/sharing. Definitely going to share your channel. I'm ready to change careers.

@JuanDavid-ug7hd Год назад

I love your videos, you help us immensely. Thank you.

@amarjeetpaul5418 Год назад

Happy New Year, bro! Thank you for all the informative videos!

@jeelkumarpatel4479 Год назад

Bro i cannot thank you enough for this video. I hope God blesses you and you reach 10M subscribers.

@amine_jbz 4 месяца назад

I've just finished your MySQL course, thank you a lot for all your works !!

@zohaibhassan8395 Месяц назад

Is this complete course? or does it just teach basic stuff?

@Belectraaaa 10 месяцев назад

The day when I came across your videos I got hope. I loved your Python course videos and now this one. The way you teach is amazing. Next I will be learning JavaScript from your video. 🤩

@adamquttb Год назад

You are a Real Chad BRO❤❤

@user-og7de8ih4f Год назад

Indeed ❣️❣️, Thanks BRO Code

@jayendrabhagat3607 Год назад

He is not chad HE IS GIGACHAD!

@karthikvijentra2016 7 месяцев назад

@@jayendrabhagat3607that's true

@FactFeedDaily_Dose 3 месяца назад

what chad bro means?

@Amvflix7 Год назад

Bro😭😭😭 I was looking for mysql tutorials yesterday only. How come you read my mind? God bless you with all the happiness 😊 You're a big help 🙏

@alexramos587 Год назад

Thanks, Bro. Happy New Year!

@YeaOhYeahh Год назад

Such a fun tutorial😍 Thanks Bro !!

@hardikchawhan6346 3 месяца назад

This video is like, a cheat sheet but in video format If I get stuck at anything, i can always come back and click on the timestamp, watch a 2 min video, and boom, now you are not stuck anymore.

@reemmehio7223 Год назад

You're a legend. I learned java python and now MySQL for free

@hopecelebre3083 Год назад

Shared it 3x! You rock! ❤❤❤

@waifucodes 6 месяцев назад

Thank you Bro for another BRO-tastic video tutorial !! Life saver

@luisdominguez9379 Год назад

BRO i am currently in college for programming and im learning so much more off ur videos , dude if i ever land a job i will make sure to come thank you !!

@MessyMasyn 2 месяца назад

just say thank you now

@tulinaltnoluk5696 10 месяцев назад

I fell in love with the detail of Mr.Krabs giving a pay reduction to his workers (not an increase!! )

@WitchsHutDnD Год назад

Hey! love your videos and its helping me out a ton! sometime, i hope, you could start doing tutorials on Lua?

@jianhuichua1154 Год назад

Just found this channel, TOTALLY GEM! A real Gigachad in Coding, million thanks for all the hard work you have done!

@derb1809 9 месяцев назад

MYSQL With Bro Code Day 1 42:26 Day 2 54:00 Day 3 1:19:52 Day 4 2:04:44 Day 5 2:26:50 Day 6 2:42:26 Day 7: Done

@HeadGenCSGO 5 месяцев назад

My MySQL with Bro Code: Day 1 1:28:31 Day 2: Done

@Hiteshoot 4 месяца назад

Me who completed in a single day 🗿

@akibahmed229 2 месяца назад

@@Hiteshoot I completed it in one shot.

@Eli_Pinheiro Месяц назад

I completed it in one and a half hour. I put the speed in 2x.

@akash-m Год назад

You are really great 🙂, you upload usefull videos, I'm learning masters in computer programming and I'm 16 , I find your videos helpfull for my doubts

@hil6517 Год назад

happy new year bro and thanks for your hard work!

@tejaswirupa537 5 месяцев назад

one of the best tutorials i came across. I was struggling with my assignment and then I found this video

@adamthelin1366 Год назад

My workplace requested that I Learn SQL and SOAPUI. Always thought SQL was a bit of a chore and then along Comes BroCode, what a chad of monolithic proportions. You saved me from having to learn from some other, less Bro-tastic youtubers. Seriously though. You've helped me so much with both coding and databses. I can't thank you enough.

@manojkumarpb1908 Год назад

@adamthelin1366 could you suggest a best tutorial video for SOAPUI?

@adamthelin1366 Год назад

@@manojkumarpb1908 I'm afraid I have yet to find a really decent one. The tutorials Smartbear supply on their own website are decent and there are a few courses on Linkedin learning that somewhat helped though.

@manojkumarpb1908 Год назад

@@adamthelin1366 Thanks for this😊

@arturcamposcamara6772 Год назад

I'm from Brazil and i love yout tutorials, you make something hard in something simple. I use your videos tô learn more

@maturiarun3267 9 месяцев назад

neymar jr

@yoma-lw3fq 11 дней назад

The whole video is amazing, everything was explained clearly.🤩 Thank you!!!!!

@takashiiexe 3 месяца назад

This was the best tutorial I've ever seen! you are great!

@Krishnasingh-ot5gu Год назад

Thank you very much bro for always making me the smartest person in my computer class

@Krishnasingh-ot5gu Год назад

P.S long live bro the giga chad

@salim-gc9ui Год назад

The best course of MySql

@lovieberra Год назад

posted just in time! I have my exam on wednesday. this is explained so well.

@MohamedIbrahim98 Год назад

Great Job Bro! I really love your channel and I've learned a lot from it ❤❤

@shubhamsoni8084 Год назад

It's a new year gift for us Thanks professor 😁☺️🐱🙂😊

@tsksalavisa4122 Год назад

Can you do a PHP Full Course video? It would help a lot because you are one of the best teachers in terms of teaching languages.

@internetdrew Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-zZ6vybT1HQs.html

@asemyamak3984 Год назад

he did it

@Urien. 11 месяцев назад

PHP is ass but yeah he made one already

@muskanfathima7152 3 месяца назад

That was an amazing, informative and good explanation I have come across, thanks for helping 💕

@luisrosario432 10 месяцев назад

You earned a subscriber. This information is priceless, I am getting a data analytics certificate and I am learning about SQL, and you are teaching this plus Python in such a simple way. You have my like and sub.

@developerritesh Год назад

Your teaching style is very crazy ✨🎉❤️

@vedothesinger7319 Год назад

That's sooooo true like no one :)

@windz643 2 месяца назад

Fun tip is to just write the SQL query as normal without having to capitalise each SQL statement, and then clicking on the brush icon (Beautify/reformat the SQL) to format your query.

@Helloworldcodex Год назад

Bro code you Super Saiyan ! straight to the point and concise - Thank you!

@hocuspocus00 6 месяцев назад

one of the best courses on MySQL on the internet, kudos!

@mrmineguy4114 7 месяцев назад

Use this command to Avoid the Error 1175: 34:40 SET SQL_SAFE_UPDATES=0;

@kamalmohamed6611 Год назад

Chaaad!, How did you cover all these concepts in 3 hour

@Zecknezz Год назад

I just found your channel and this is the best channel so far I have learn how to code. Thank you so much really thank you

@seraph7536 Год назад

It's finally here lets go, you are goated

@noah77 Год назад

hello hello long time, hows life been?

@udaykiran6201 Год назад

Hey, we are waiting for React() Bro

@2ru2pacFan Год назад

Same bro

@Sjlove37 Год назад

You are the best !!!.you made it easy to understand. Thank you so much❤

@NikkoBernardoTV 11 месяцев назад

Thank you so much for this tutorial. Very clear and helpful.

@hansana0 Год назад

✅Shortcut Key : Execute All or Selection -> Ctrl + Shift + Enter. Execute Current Statement -> Ctrl + Enter. (So you don't have to click that thunder icon everytime you need to run your code.)