The TH-cam 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
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
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.
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 ❤
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.
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 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.
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
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
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
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.
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
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 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.
a good advice for the new people who warch this , anything you will learn in this course or any other course write it in a notebook and every part give it their unique name , because it will come a day you will forget something , in this case you found yourself writed anything that you need . i hope you understand
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!
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.
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.❤
Thank you for all of your courses that you have been posting here on TH-cam. 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. ❤️
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!!!!
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.
I have watched a lot of videos on TH-cam regarding SQL in order to understand it better, but this is the best video I have ever seen to gain a better understanding of the concept and technique for a beginner level . Thank you so much sir, may God bless you.
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.
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 !!
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!!!
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!
Hello Bro Code, I have watched one or two of your TH-cam tutorials, and I should give you credit for your style of tutoring and very clear and concise explanations.
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.
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.
I came to this video after finishing your 1 hr MongoDb course. I'm excited 😊 for this one. I trust you to teach in the best possible way as you are an awesome teacher ✌️. It is just calming and enjoyable to learn from you 😊 Even if I know most of the stuffs, it is always good to refresh your memory as you pick up bits which you were missing in your tiny brain and my brain is very tiny 😂 I need to teach it x10 times more than the average programmer 🤪🤣
I started a java fullstack course as a beginner not knowing Broski, all i have to say is that I’ve learned more by watching bro than going to the course i was paying
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.
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!
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!
literally after 1 month break, i wanted to start from 1st february back to learning java, and my step was "ok i will learn about mysql", what i see? Bro did the tutorial few weeks ago! NICE AF !
This is one of the few tutorials that I completed on TH-cam. Highly recommended to anyone who wants to get started with MySQL. Thank you so much Bro Code.
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
you are so much wonderful instructor i have ever watched on virtual platforms. I highly appreciate your clear, concrete method of teaching. Being honest my concept has been very much improved on mysql after watching this video. Thanks for your help.
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.
bro I have no words to thank u for real, im an it engineer student and I always watch your videos, the best explainer out there, you saved my semester in databases with this video
Dude, I don't know how I can to thanks you. I'm watching this video yet, but I take a look at your channel and others videos that you did and... What a amazing work you do. I feel I am not lose my time, but enjoying very well all this hours of my day. Although I don't have a so good understand in English, as a Brazilian, you help me a lot.
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.. 🤟
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!
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!
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.
Good Stuff. I did some MySQL / PHP stuff over a decade ago. It was really simple stuff. Now I need to make a DB for work to replace a crappy old access database. SQL is what I want to use but this time, it's going to be a lot more complicated. So I'm going to go through this series, take notes, and hopefully make this task less daunting.
Sure. I searched for this topic and less relevant videos showed up. I reached here by manually going to your playlist and select it from there. Your tutorial is better than all that I have seen in this topic. Thanks.
Man you are a real HERO! Not only for the knowledge you upload and share with all of us in your channel with a excellent quality but for helping kids in need! I was willing to learn MySQL and this is exactly what I was looking for! Thanks man!!! God bless you!!!
✅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.)
The TH-cam 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
Bro do videos about django, django rest framework, rest API.. I appreciate your work 👏
Hello bro thank you for helping us about Data in general 👏👏👏 , please can you helping us in SQL3 i really appreciate your work 💕💕💕
sure
We would never let your hard work go to waste 💖💖
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
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.
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 ❤
😇
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.
So do you finish the python course?
Hey are you still on 4th hour of Python course?
@@HeadGenCSGO probably not. The comment was almost 1 year ago lol
@Kei-in7od completed or not 😂
I finished the whole python course and it was worth it....
I started this 5 days ago. Now you've made the full compilation. Thank you BRO!!!
Alright ladies and gentlemen, i am ready to make my mom a website for her coffee shop
Did you manage to do it?
@@TheCollectiveHexagon
>she already has one i found out
>only helping with bugs
>proceed to pursue music
@@DefinedCmajor great man , all the best for your music thing
W son/daughter 💯💯
Why not share your mom's coffee shop website?
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.
Where do you go from here? Can you share some links or what to do specifically?
@@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.
yeah onay gae shimass
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
Exactly, facing similar issues , Thanks Dude
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
@@MohammedAhmed-yn4oj on MySQL workbench ?
@@MohammedAhmed-yn4oj
You saved my brain from "wtf" I appreciate it
Use set sql_safe_updates = off;
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
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.
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
#16 01:19:52 JOINS
01:48:37 SELF JOINS
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.
@adamthelin1366 could you suggest a best tutorial video for SOAPUI?
@@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.
@@adamthelin1366 Thanks for this😊
He is definitely the GOAT, he saved me in midterms, and now in the final. What a great guy.
a good advice for the new people who warch this , anything you will learn in this course or any other course write it in a notebook and every part give it their unique name , because it will come a day you will forget something , in this case you found yourself writed anything that you need . i hope you understand
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
My MySQL with Bro Code:
Day 1 1:28:31
Day 2: Done
Me who completed in a single day 🗿
@@Hiteshoot I completed it in one shot.
I completed it in one and a half hour. I put the speed in 2x.
MySQL with green
Day 1 :done
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!
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.
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.
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!
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.
been having trouble finding the perfect mysql tutorial video till i came across yours. you're a f*cking legend!
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.❤
Thank you for all of your courses that you have been posting here on TH-cam. 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. ❤️
You're a legend. I learned java python and now MySQL for free
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!!!!
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.
Ikr, I find that college is meant ro get access to direct internships to enhance your job experience
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!
I have watched a lot of videos on TH-cam regarding SQL in order to understand it better, but this is the best video I have ever seen to gain a better understanding of the concept and technique for a beginner level . Thank you so much sir, may God bless you.
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!
same
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.
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💪.
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
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 !!
just say thank you now
Yes..........stumbled on your youtube. Thanks for teaching/sharing. Definitely going to share your channel. I'm ready to change careers.
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 🙏
I fell in love with the detail of Mr.Krabs giving a pay reduction to his workers (not an increase!! )
Good job in teaching! I learned a lot from this video. Three days straight and just finished the course today. thanks :)
A guy with absolute zero knowledge in computer can also learn from your videos ❤❤ thank you
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!!!
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!
Ow , In one setting, Let me ask you some thing, Have you grabbed it all?
The best course of MySql
Successfully SQL 3 hours full course completed today, THANK YOU BRO CODE.💝
Hello Bro Code, I have watched one or two of your TH-cam tutorials, and I should give you credit for your style of tutoring and very clear and concise explanations.
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.
Thank you very much bro for always making me the smartest person in my computer class
P.S long live bro the giga chad
Thank you! I’m doing SQL in uni soon this video was great to get a head start!
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.
I came to this video after finishing your 1 hr MongoDb course. I'm excited 😊 for this one. I trust you to teach in the best possible way as you are an awesome teacher ✌️. It is just calming and enjoyable to learn from you 😊 Even if I know most of the stuffs, it is always good to refresh your memory as you pick up bits which you were missing in your tiny brain and my brain is very tiny 😂 I need to teach it x10 times more than the average programmer 🤪🤣
MySQL Full Course very helpful video, i learned a lot from here. Looking forward to the next videos
I started a java fullstack course as a beginner not knowing Broski, all i have to say is that I’ve learned more by watching bro than going to the course i was paying
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.
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!
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!
Just finished this SQL course! Thank you so much for helping me understand the basics. I feel better prepared for my Data Analyst role (:
Your courses are fantastic. Thank you for your dedication and time, you make the difference. Hug man!
i just cant imagine watching any other channel for introduction to any tech at this point,,, cant appreciate you enough Bro.
I followed you in Python and there you are again. I am super excited to watch this 3hrs. Thank you
Honestly, this is an exceptional, exceptional understanding of what to say to teach.
at 34.00 while practicing the update make sure
go to edit
preferences
sql editor
deselect the safe mode
thanks man
What's the reason for deselecting safe mode
literally after 1 month break, i wanted to start from 1st february back to learning java, and my step was "ok i will learn about mysql", what i see? Bro did the tutorial few weeks ago! NICE AF !
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.
th-cam.com/video/zZ6vybT1HQs/w-d-xo.html
he did it
PHP is ass but yeah he made one already
This is one of the few tutorials that I completed on TH-cam. Highly recommended to anyone who wants to get started with MySQL. Thank you so much Bro Code.
I'm from Brazil and i love yout tutorials, you make something hard in something simple. I use your videos tô learn more
neymar jr
I finished C, Java, MYSQL.... next HTML/CSS, JavaScript. Thank my man😎👍 you are awesome.
Happy new year!! Thank you for teaching us!! We wish you staying healthy!!
I've just finished your MySQL course, thank you a lot for all your works !!
Is this complete course? or does it just teach basic stuff?
You are a Real Chad BRO❤❤
Indeed ❣️❣️, Thanks BRO Code
He is not chad HE IS GIGACHAD!
@@csjaybitthat's true
what chad bro means?
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
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. 🙏🙏🙏
you are so much wonderful instructor i have ever watched on virtual platforms. I highly appreciate your clear, concrete method of teaching. Being honest my concept has been very much improved on mysql after watching this video. Thanks for your help.
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.
bro I have no words to thank u for real, im an it engineer student and I always watch your videos, the best explainer out there, you saved my semester in databases with this video
you are a fucking god. best tutorial of anything ive ever come across.
Dude, I don't know how I can to thanks you. I'm watching this video yet, but I take a look at your channel and others videos that you did and... What a amazing work you do. I feel I am not lose my time, but enjoying very well all this hours of my day.
Although I don't have a so good understand in English, as a Brazilian, you help me a lot.
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.. 🤟
Lost my job...I wanna refresh my skillset but I am new to coding...this one gives me hope bro...thanks for this...yes, I will definitely share this...
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!
one of the best tutorials i came across. I was struggling with my assignment and then I found this video
Amazing course!!!
Definitively quality content as always 👌
Dude, it's the best channel which i have ever seen, i swear
Your teaching style is very crazy ✨🎉❤️
That's sooooo true like no one :)
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!
This is my first time watching one of your videos and is AMAZING! I cannot thank you enough for your effort
one of the best courses on MySQL on the internet, kudos!
It's a new year gift for us
Thanks professor 😁☺️🐱🙂😊
I do not often comment on youtube videos but you made me do , you are an incredible teacher!
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.
Bro literally RIGHT ON TIME - thank you brother!
Happy New Year, bro! Thank you for all the informative videos!
Good Stuff. I did some MySQL / PHP stuff over a decade ago. It was really simple stuff. Now I need to make a DB for work to replace a crappy old access database. SQL is what I want to use but this time, it's going to be a lot more complicated. So I'm going to go through this series, take notes, and hopefully make this task less daunting.
day 1-22:34
Sure. I searched for this topic and less relevant videos showed up. I reached here by manually going to your playlist and select it from there. Your tutorial is better than all that I have seen in this topic. Thanks.
Use this command to Avoid the Error 1175:
34:40 SET SQL_SAFE_UPDATES=0;
Bro did what we've done during a semester in 3 hours 💯💯
You're a life saver man
Chaaad!, How did you cover all these concepts in 3 hour
Man you are a real HERO!
Not only for the knowledge you upload and share with all of us in your channel with a excellent quality but for helping kids in need!
I was willing to learn MySQL and this is exactly what I was looking for!
Thanks man!!! God bless you!!!
✅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.)
posted just in time! I have my exam on wednesday. this is explained so well.
0:36 Quest Whhhhat 😳😳💀
Just completed this course now i am gonna build a project with MYSQL thanks Bro Code