The KZbin 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
@TheCollectiveHexagon3 ай бұрын
Did you manage to do it?
@DefinedCmajor3 ай бұрын
@@TheCollectiveHexagon >she already has one i found out >only helping with bugs >proceed to pursue music
@gopeshsharma20593 ай бұрын
@@DefinedCmajor great man , all the best for your music thing
@MythicalBrew3 ай бұрын
W son/daughter 💯💯
@groundzero822 ай бұрын
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 ❤
@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 Жыл бұрын
So do you finish the python course?
@HeadGenCSGO7 ай бұрын
Hey are you still on 4th hour of Python course?
@purplevanilla7 ай бұрын
@@HeadGenCSGO probably not. The comment was almost 1 year ago lol
@rabihanaveed.7 ай бұрын
@Kei-in7od completed or not 😂
@cathupapa66433 ай бұрын
I finished the whole python course and it was worth it....
@princeakinolaoluwagbemigag1750 Жыл бұрын
I started this 5 days ago. Now you've made the full compilation. Thank you BRO!!!
@omotoshoabimbola7911 Жыл бұрын
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.
@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.
@samyakhp43532 ай бұрын
Where do you go from here? Can you share some links or what to do specifically?
@JohnWickPotter2 ай бұрын
@@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.
@hamzagohar204819 күн бұрын
yeah onay gae shimass
@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!
@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!
@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 Жыл бұрын
Exactly, facing similar issues , Thanks Dude
@MohammedAhmed-yn4oj Жыл бұрын
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 Жыл бұрын
@@MohammedAhmed-yn4oj on MySQL workbench ?
@jessi5226Күн бұрын
@@MohammedAhmed-yn4oj You saved my brain from "wtf" I appreciate it
@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
@diaal-emad68567 ай бұрын
He is definitely the GOAT, he saved me in midterms, and now in the final. What a great guy.
@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.
@joaovictorbrum_7 ай бұрын
Thank you for all of your courses that you have been posting here on KZbin. 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. ❤️
@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!!!!
@Wisdawms6 ай бұрын
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!
@derb180911 ай бұрын
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
@HeadGenCSGO7 ай бұрын
My MySQL with Bro Code: Day 1 1:28:31 Day 2: Done
@Hiteshoot6 ай бұрын
Me who completed in a single day 🗿
@akibahmed2294 ай бұрын
@@Hiteshoot I completed it in one shot.
@Eli_Pinheiro3 ай бұрын
I completed it in one and a half hour. I put the speed in 2x.
@galaxy15754 күн бұрын
MySQL with green Day 1 :done
@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😊
@KM-ne1ft Жыл бұрын
this is just for me thanks xx #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
@KM-ne1ft Жыл бұрын
#16 01:19:52 JOINS
@KM-ne1ft Жыл бұрын
01:48:37 SELF JOINS
@xen00766 ай бұрын
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.
@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.
@ivanchow47526 күн бұрын
This is GOLD!! I am taking Intro to Database at Week 8 out of 12, and I can tell you lecture class are pretty confusing. I am now halfway through this full course and it taught in such a simple manner that when I look refer back to my lecture slides, everything finally clicked. I am now convinced my lntro class are not really designed for beginners.
@sanaalam_ Жыл бұрын
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.
@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!
@murtal10 Жыл бұрын
Your courses are fantastic. Thank you for your dedication and time, you make the difference. Hug man!
@khadijakh81306 ай бұрын
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.❤
@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💪.
@franciscogaius94425 ай бұрын
been having trouble finding the perfect mysql tutorial video till i came across yours. you're a f*cking legend!
@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!
@widny31 Жыл бұрын
same
@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 !!
@MessyMasyn4 ай бұрын
just say thank you now
@k.h.p.9862 Жыл бұрын
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.
@bad_writer04 Жыл бұрын
Good job in teaching! I learned a lot from this video. Three days straight and just finished the course today. thanks :)
@adamquttb Жыл бұрын
You are a Real Chad BRO❤❤
@user-og7de8ih4f Жыл бұрын
Indeed ❣️❣️, Thanks BRO Code
@csjaybit Жыл бұрын
He is not chad HE IS GIGACHAD!
@karthikvijentra20169 ай бұрын
@@csjaybitthat's true
@FactFeedDaily_Dose5 ай бұрын
what chad bro means?
@gamerguy82613 ай бұрын
bro you are a CHAD i have been struggling with sql because its a little different than typical programming languages but u made it simple
@reemmehio7223 Жыл бұрын
You're a legend. I learned java python and now MySQL for free
@huytrant Жыл бұрын
MySQL Full Course very helpful video, i learned a lot from here. Looking forward to the next videos
@FBI-UIU Жыл бұрын
Happy new year!! Thank you for teaching us!! We wish you staying healthy!!
@sonya55689 ай бұрын
Yes..........stumbled on your youtube. Thanks for teaching/sharing. Definitely going to share your channel. I'm ready to change careers.
@nhicao3438 Жыл бұрын
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.
@waifucodes8 ай бұрын
Thank you Bro for another BRO-tastic video tutorial !! Life saver
@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
@oogway4894 Жыл бұрын
Dude, it's the best channel which i have ever seen, i swear
@my-trending Жыл бұрын
Hello Bro Code, I have watched one or two of your KZbin tutorials, and I should give you credit for your style of tutoring and very clear and concise explanations.
@mr_frost659 ай бұрын
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!
@tulinaltnoluk5696 Жыл бұрын
I fell in love with the detail of Mr.Krabs giving a pay reduction to his workers (not an increase!! )
@user-bv2qd5wt1q6 ай бұрын
Hi! Thanks a lot for this amazing tutorial. I understand the subqueries but I always have difficulties understanding/applying correlated subqueries. A video about it would be so helpful. Thank you and I really appreciate your work
@hardikchawhan63465 ай бұрын
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.
@sarathsarabrozz65932 ай бұрын
2:26:00 Roll up is not only Giving the aggregate value if it was count() it will give count of counts. if it was avg() it will give avg of avgs if it was min() it will give min of mins so on Small correction any way thanks for the quality class
@matthewmurdock7329 Жыл бұрын
I was waiting for this! You’re a real hero, thank you 💪
@amine_jbz6 ай бұрын
I've just finished your MySQL course, thank you a lot for all your works !!
@zohaibhassan83953 ай бұрын
Is this complete course? or does it just teach basic stuff?
@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!
@jawbreakingcandy836 Жыл бұрын
Thank you! I’m doing SQL in uni soon this video was great to get a head start!
@globalgrowth343 Жыл бұрын
I followed you in Python and there you are again. I am super excited to watch this 3hrs. Thank you
@muskanfathimaworld5 ай бұрын
That was an amazing, informative and good explanation I have come across, thanks for helping 💕
@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!!!
@hasansahin25617 ай бұрын
I finished the entire course in 1 sitting. You're style is so easy to follow and making it way easier to learn. Thanks a bunch bro!!! Much appreciated!
@NatnaelTeklemariamdev7 ай бұрын
Ow , In one setting, Let me ask you some thing, Have you grabbed it all?
@arturcamposcamara6772 Жыл бұрын
I'm from Brazil and i love yout tutorials, you make something hard in something simple. I use your videos tô learn more
@maturiarun326711 ай бұрын
neymar jr
@zb2747 Жыл бұрын
Bro literally RIGHT ON TIME - thank you brother!
@DoorKnobblerClarkson6 ай бұрын
you are a fucking god. best tutorial of anything ive ever come across.
@seraph7536 Жыл бұрын
It's finally here lets go, you are goated
@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 🙏
@keerthansj8453 ай бұрын
This is one of the few tutorials that I completed on KZbin. Highly recommended to anyone who wants to get started with MySQL. Thank you so much Bro Code.
@salim-gc9ui Жыл бұрын
The best course of MySql
@CJeyakumarR Жыл бұрын
Great Tutorial!, Never Got Bored at any point!!!
@redhotchillipeper-v1 Жыл бұрын
day 1-22:34
@yoma-lw3fq2 ай бұрын
The whole video is amazing, everything was explained clearly.🤩 Thank you!!!!!
@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.
@user-ds6vy9py4e8 ай бұрын
I do not often comment on youtube videos but you made me do , you are an incredible teacher!
@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. 🙏🙏🙏
@OleksandrProkopenko_ua Жыл бұрын
Thanks very much!
@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.. 🤟
@samdjtime722 күн бұрын
at 34.00 while practicing the update make sure go to edit preferences sql editor deselect the safe mode
@jeelkumarpatel4479 Жыл бұрын
Bro i cannot thank you enough for this video. I hope God blesses you and you reach 10M subscribers.
@grahamward284717 күн бұрын
Brilliant and simple tutorials. Thank you!
@josuetorres3281 Жыл бұрын
This is my first time watching one of your videos and is AMAZING! I cannot thank you enough for your effort
@Cipher6i83 ай бұрын
This was such a beautifully well-done video. Took a course on Database management systems in my last semester of college. We covered a million concepts plus SQL at the end, but this really helped hammer everything home! Thanks, bro!
@niz1001 Жыл бұрын
0:36 Quest Whhhhat 😳😳💀
@-Corvo_Attano Жыл бұрын
Thanks a lot Bro :)
@antoniob.6546 Жыл бұрын
Amazing course!!! Definitively quality content as always 👌
@rachit.6110 Жыл бұрын
WAITING FOR THIS SIR, LOVE YOU CHAD!!
@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 Жыл бұрын
kzbin.info/www/bejne/sIuZp6yYiZZ7h9U
@asemyamak3984 Жыл бұрын
he did it
@Urien. Жыл бұрын
PHP is ass but yeah he made one already
@jesc1007 ай бұрын
As an (Oracle) DBA for many years, I've lost count of the number of training courses I've attended, tutorials and videos I've watched, blogs I've followed, and books I've dipped into. I'm also aware that it's rare to find a 'technologist' with a gift for pedagogy. I'm currently expanding my DBA skills to include MySQL, PostreSQL, and MongoDB and, for MySQL, this was the perfect introduction. It was clear how much thought had gone into planning the order of the different chapters and exercises, the pace was fine, and, having completed all of the exercises (and documented) them, I've learnt a lot!! Thanks so much for taking the time to plan and present this.
@windz6434 ай бұрын
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.
@hopecelebre3083 Жыл бұрын
Shared it 3x! You rock! ❤❤❤
@developerritesh Жыл бұрын
Your teaching style is very crazy ✨🎉❤️
@vedothesinger7319 Жыл бұрын
That's sooooo true like no one :)
@brylontoc6140 Жыл бұрын
very clear! you got my subscription. 👍🏻
@amarjeetpaul5418 Жыл бұрын
Happy New Year, bro! Thank you for all the informative videos!
@tejaswirupa5377 ай бұрын
one of the best tutorials i came across. I was struggling with my assignment and then I found this video
@shubhamsoni8084 Жыл бұрын
It's a new year gift for us Thanks professor 😁☺️🐱🙂😊
@hocuspocus008 ай бұрын
one of the best courses on MySQL on the internet, kudos!
@mrmineguy41149 ай бұрын
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
@EzrDev Жыл бұрын
you are severely underrated. great videos. could you Lua next? thanks :)
@udaykiran6201 Жыл бұрын
Hey, we are waiting for React() Bro
@2ru2pacFan Жыл бұрын
Same bro
@tharunreddy28119 ай бұрын
THANK YOU BRO.
@noah77 Жыл бұрын
hello hello long time, hows life been?
@MarioA-gx8ch11 ай бұрын
May God bless you!
@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.)
@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!
@user-ur9oy7zw3d7 ай бұрын
i just cant imagine watching any other channel for introduction to any tech at this point,,, cant appreciate you enough Bro.