Learn MySQL in one video [Hindi]

  Рет қаралды 586,746

Learn Code With Durgesh

Learn Code With Durgesh

Күн бұрын

Пікірлер: 925
@rahul-java-dev
@rahul-java-dev 4 жыл бұрын
Thank you so much Sir Ji...you have changed my Java life.🙏🙏🙏
@sujatabiswas4197
@sujatabiswas4197 3 жыл бұрын
Thanks Durgesh.. Amazing video. Please make separate video explaining JOINS (Inner, outer, left, right). ALso would be really helpful if you can pass on the notes that you were writing on Notepad.
@mytubeamit1593
@mytubeamit1593 2 жыл бұрын
Hi
@mechanosys
@mechanosys 2 жыл бұрын
I am not from IT but a mechanical engineer, 53. I was surprised that this was so easy to learn SQL. I am used to MSAccess, so very easily learned MySQL with all installation as per your video! Thank you DURGESH!.
@pranuthiprasad6103
@pranuthiprasad6103 3 жыл бұрын
This is the best explanation i have heard, please do more vidoes . Thanks
@sonalkale639
@sonalkale639 2 жыл бұрын
54.55 assignment answer- alter table [table_name] rename column [old col_name] to [new col_name]; alter table student rename column country to state;
@shaktidash1675
@shaktidash1675 2 жыл бұрын
bro.. i also tried by this syntax, but some error there. Can u explain?
@surajkamble482
@surajkamble482 Жыл бұрын
Bhava thank you 😊 you are Right
@mdtariqueazeez9213
@mdtariqueazeez9213 2 жыл бұрын
To rename column use cmd-alter table table_name rename column old_column_name to new_column_name; To change the datatype of column use cmd- alter table table_name modify column_name datatypes; Thank you durgesh sir to provide this wonderful video
@diyanegi52
@diyanegi52 Жыл бұрын
TO RENAME COLUMN ALTER TABLE TABLE NAME CHANGE OLD COLUMN NEW COLUMN DATATYPE
@janakjadhav4909
@janakjadhav4909 3 жыл бұрын
Easiest method of teaching, even a school students can also learn without any doubt Absolutely fabulous work sir...😊😊😊
@kmtfarhan
@kmtfarhan 2 жыл бұрын
Clear MySQL basics after so many month and found this video to be of great use. Excellent work, Durgesh!
@OmParkashSarangani
@OmParkashSarangani 2 жыл бұрын
Revising MySQL basics after years and found this video to be of great use. Excellent work, Durgesh!
@kidzzone441
@kidzzone441 Жыл бұрын
Theek hai om Parkash😂
@niteshyadav5159
@niteshyadav5159 Жыл бұрын
@@kidzzone441 funy guy🤣🤣
@jawadazimi8607
@jawadazimi8607 Жыл бұрын
PPT and source code is not in here dear Your teaching is great.
@madhurigupta8494
@madhurigupta8494 3 жыл бұрын
this was really helpful, maine first time MySQL window open kia and i was totally clueless..... by the end of these 2 hours I was amazed! thank you so much!!
@prithvichauhan9507
@prithvichauhan9507 Жыл бұрын
Hii, Durgesh please provide me the notes of this video as soon as possible .
@sanjitpaul2953
@sanjitpaul2953 3 жыл бұрын
Great Sir. Learned overview of MYSQL within a short time. Your teaching style is excellent. Thank you.
@p2kgaming407
@p2kgaming407 Жыл бұрын
Bhaiya mujhe smjh thora aaya coding krte time mera mind blank ho jta h kya kru 🥲🥲🥲🥲
@FaizanFurqanAhmad
@FaizanFurqanAhmad Жыл бұрын
Practice makes us perfect 😉
@gurpreetbains9196
@gurpreetbains9196 3 жыл бұрын
31:45 at this moment I laughed alot because i can relate this😂 (pata ee nahi he)
@indiancomedyandhindisongs8584
@indiancomedyandhindisongs8584 3 жыл бұрын
0000p0pp0
@krankumarsharma2895
@krankumarsharma2895 2 жыл бұрын
select * from student where city like '_u%' Video :- 1:27:08
@sanjaykumar-gz1zg
@sanjaykumar-gz1zg 3 жыл бұрын
For changing column name Mysql> alter table [table name] change [old col name] [new column name]: Right na bro..
@abbasahmad6643
@abbasahmad6643 2 жыл бұрын
alter table [table name] rename column [old col name] to [new column name];
@tshende02
@tshende02 Жыл бұрын
Yes , somehow your videos are good but to increase the watch time u repeat the same sentences again and again, that is not good u should respect our time.
@riteshdangi7460
@riteshdangi7460 4 жыл бұрын
need one more video on joints in details
@aliyaabbas9556
@aliyaabbas9556 3 жыл бұрын
can you send me the notepad quires please or how i contact you Thank you for your help
@amithghosh3332
@amithghosh3332 4 жыл бұрын
auto_increment and default values u havent explained? no matter!!; i am so happy with your methodology in teaching..... u covered every basic details whatsoever!!!!
@KumarHemjeet
@KumarHemjeet 3 жыл бұрын
@Reginald Waylon bots !
@suyashbhargava4827
@suyashbhargava4827 2 жыл бұрын
Thank-you so much sir Please give me notes
@venkatasimham4729
@venkatasimham4729 3 жыл бұрын
Thank you Durgesh. It was very refreshing to get a brush up on my SQL skills on very basics which I've learnt long back. I wish there were more type of joins added in this video. Still thank you again for all the efforts.
@eshwarkanna3067
@eshwarkanna3067 2 жыл бұрын
ALTER TABLE [TABLE_NAME] RENAME COLUMN [OLD_NAME] TO [NEW_NAME] ;
@nishanthedaoo8937
@nishanthedaoo8937 4 жыл бұрын
Hello sir, Wapms server me jo mysql database hai use use kar sakte hai kya Eclipse? Thank you 😊
@spdeshwar8225
@spdeshwar8225 Жыл бұрын
In the history of KZbin prospectus of MySQL this vdo is best vdo of all ❤❤❤❤❤❤❤❤❤❤🎉🎉🎉🎉🎉🎉🎉🎉🎉
@anjubirla6976
@anjubirla6976 3 жыл бұрын
Sir thanks to you a lot .I have to upload my journal which includes mysql work for practical exam in boards . I could not understand what my teacher was teaching and I thought I was going to score very less in this chapter.I invested my 2 hours and now I am an expert and also I can answer questions what my teacher can ask.Worthy 2 hours
@oneclick8403
@oneclick8403 Жыл бұрын
reallly😅😅
@Treeman143
@Treeman143 4 жыл бұрын
Sir ek video bootstrap 5 ko offline use karke ek video banao
@gamerboi38387
@gamerboi38387 3 жыл бұрын
Thank you so much bro.. u made things clear in just 1and half hour .... I fully understood the concepts.. Thank you so much
@zeeshanahmad-tx5hw
@zeeshanahmad-tx5hw 3 жыл бұрын
Great Sir..... Good videos.... Thanks
@shrutikakadam9677
@shrutikakadam9677 3 жыл бұрын
Great Sir. Learned overview of MYSQL within a short time.
@someshsahu4638
@someshsahu4638 2 жыл бұрын
Very nice explanation thankyou so much sir 🙏🏼🙏🏼🙏🏼
@nikitanaik178
@nikitanaik178 2 жыл бұрын
Great Video Sir! Can you also make a separate video on Joins concept with example & explaination?
@ravikantverma1642
@ravikantverma1642 Жыл бұрын
Very nice information. I am Je mech but u make sql very easy.
@ravikantverma1642
@ravikantverma1642 Жыл бұрын
Plese send ur note
@pankajsangle2752
@pankajsangle2752 3 жыл бұрын
Next one small video should be the real time implementation of database queries in any any project.
@spdeshwar8225
@spdeshwar8225 Жыл бұрын
Alter coll.old name rename new name
@BilluAck
@BilluAck 4 жыл бұрын
Sir NoSql ka bhi banaiye in one video please🙏🙏🙏🙌🔥🔥🔥
@amithghosh3332
@amithghosh3332 4 жыл бұрын
yes, I want it too :)
@lofivibes4you
@lofivibes4you 2 жыл бұрын
Sir dont mind I am just kidding so my question is that in this video the last topic is join or foreign key on that the beginning part where you just show two tables on the first there is two name "" Durgesh or vandna "" .. So Vandna is your girlfriend 😀
@LearnCodeWithDurgesh
@LearnCodeWithDurgesh 2 жыл бұрын
Sister***
@lofivibes4you
@lofivibes4you 2 жыл бұрын
@@LearnCodeWithDurgesh i am really sorry i just imagine that why i was asking..:'(
@vaibhavshukla1685
@vaibhavshukla1685 3 жыл бұрын
thanku bro your definetly a good teacher who have the ability to vanish the doubts of your student. I am proud to see your video . Now i know mysql better.. thanku.. keep it... One suggest from my side my make a video all the concept of Database management system..
@as.editz.
@as.editz. 2 жыл бұрын
Tq sir 🙏🙏🙏🙏❣️❣️❣️❣️🥀🥀🥀🥀
@rahulchauhan144
@rahulchauhan144 3 жыл бұрын
Now, That's what I call a perfect video, it had both Installation and Learning tutorial, Very Good ! Your Channel has been Subscribed :)
@aashadeeptechnical1898
@aashadeeptechnical1898 2 жыл бұрын
U r great sir ..the way of teaching ..and ..the sequence ...to connect one problem with another and give sol in esiest possible way ....is amazing sir
@ArjunKumar_01
@ArjunKumar_01 2 жыл бұрын
Thank You So Much Sir
@tarunchauhan1025
@tarunchauhan1025 3 жыл бұрын
Thanks sir.. I love the way you explained .... very very good job sir ji... You are Excellent. Keep uploading Videos ..
@Abhinay461
@Abhinay461 Жыл бұрын
Thank you sir ❤️
@pankajkumargupta708
@pankajkumargupta708 Жыл бұрын
Sir notes Chhiye pankajkg0825@gmail.com 🙏❤️
@bodyart1460
@bodyart1460 Жыл бұрын
very helpful thank you
@devendrapandey3124
@devendrapandey3124 2 жыл бұрын
Foreign key and join nahi samajh me aya... Baki sab samajh me aya.. Thanks a lot👍👍
@p2kgaming407
@p2kgaming407 Жыл бұрын
Bro foreign key main bss yahi dekhna h dono table main ek jesa column or value pr depend h same h to foreign key
@tejaskumar6056
@tejaskumar6056 2 жыл бұрын
ALTER TABLE table_name CHANGE old_column_name new_col_name Data Type;
@goldenicons9660
@goldenicons9660 2 жыл бұрын
Change column name command-: alter table table_name rename column (type old column name) to (type new column name); ex. alter table student rename column country to nation; 100% Working...........
@adityachopade3748
@adityachopade3748 3 жыл бұрын
thnksss lotttttttttttttttttttttttttttttttttttttttttttttttttttttttttttt superbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
@abkkashyap
@abkkashyap 2 жыл бұрын
Change column name. 👉👉👉👉👉👉 Alter table [table name -for eg(college)] rename column [column name -for eg(fess)] to [new column name -for eg (country) ]
@krishnakawade7136
@krishnakawade7136 3 жыл бұрын
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'creat database krish' at line 1 what type of error is this;
@vaibhavsharma6976
@vaibhavsharma6976 3 жыл бұрын
use create
@anjalidevi46
@anjalidevi46 2 жыл бұрын
Alter table [table_name] change old_col_name new_col_name; Alter table student change country state varchar(50);
@vikashyadav-xn5md
@vikashyadav-xn5md Жыл бұрын
Hi, Great work brother. AAP mjhe phle kyu nhi mile bhai !!!!! send me the link for notes as well ... continue with your remarkable work ...
@anishamalode5326
@anishamalode5326 2 жыл бұрын
Thank you for the tutorial
@arpitsri9631
@arpitsri9631 2 жыл бұрын
Hi friends 🙏👍
@tshende02
@tshende02 Жыл бұрын
well i thought my-sql has some different commands and at the end of this video i got to know that it is same as other database.
@Debasispat525
@Debasispat525 3 жыл бұрын
thanks sir u r the best
@MuhammadAli-fo2sj
@MuhammadAli-fo2sj 3 жыл бұрын
Good SQL server VS MySQL
@vk19
@vk19 2 жыл бұрын
Hi bro Very informative video I made notes on mssql I subscribed ur channel. Thank you and keep going
@Imkrisharma
@Imkrisharma 2 жыл бұрын
Sir plz ek full length course lekrr aaae KZbin pr in which you will explains full python programming from basics to acidic
@suriyab8143
@suriyab8143 Жыл бұрын
Which software are you using for recording this video?? Kindly let me know. Thanks in advance
@Amit-tn5fq
@Amit-tn5fq Жыл бұрын
Best video 👌✌️
@priyankapatidar_CS
@priyankapatidar_CS Ай бұрын
It's very helpful and easy to understand thank you so much sir..❤
@RAKESHGUPTA-ct7gp
@RAKESHGUPTA-ct7gp 2 жыл бұрын
Sir I can't able to download my sql community server 8.0.28 please help me
@shiprasingh9541
@shiprasingh9541 Жыл бұрын
This video is awesome Thank you so much sir Your teaching style is very nice I have huge problem in SQL but this video is much help
@surajmukhiya2643
@surajmukhiya2643 Жыл бұрын
Too grateful sir. Please make more videos In this I.e. MYSQL
@TanayOjha250889
@TanayOjha250889 Жыл бұрын
Very nice Durgesh good for beginners... But make some videos for professional also
@ahsanalimughal3701
@ahsanalimughal3701 Жыл бұрын
Rename alter table student rename column country to state; change datatype alter table student change id to std_id varchar(50);
@saikumar-kk1kh
@saikumar-kk1kh Жыл бұрын
please Explain us slowly.......🙏🙏🙏durgeshh🙏🙏🙏🙏
@SurajWankhede-ng3eb
@SurajWankhede-ng3eb 5 ай бұрын
55:02 alter table student modify name to person varchar (50);
@ScientificMyths2706
@ScientificMyths2706 2 жыл бұрын
1:21:36 "like always important hota hai" .. Lagta hai bhai ne youtube video dil tootne ke baad banana start kiya hai.. BDW great revision course . It would have been more informative if you included exception handling , priorities and more on different type of joins.
@janendersharma7712
@janendersharma7712 3 жыл бұрын
Simply add the notepad link in description box against personally mail to everyone.
@ahpatel100
@ahpatel100 Жыл бұрын
Which version of . Net Freamwork installed?
@rameshavaghad6966
@rameshavaghad6966 Жыл бұрын
Sir , one question asked in interview..remove duplicate row from table..how it do
@divinecreations1
@divinecreations1 9 ай бұрын
Thank you so much for amazing video really very helpful, please share notes with me
@surajkumarrajput6347
@surajkumarrajput6347 Жыл бұрын
thank you so much sir this one-shot video was very helpful and i just got each and every detailed concept very clearly and the content was to the point . thankyou so much sir 🙏🙏
@M1P1...
@M1P1... Жыл бұрын
Sir temporally RAM SSD permanent store bhut why use sql
@sagarmuttireddy2477
@sagarmuttireddy2477 2 жыл бұрын
understood bhaiya thanks for video make video on plsql also bhaiya.
@shubhama0
@shubhama0 2 жыл бұрын
Send notes
@wolfspack5483
@wolfspack5483 2 жыл бұрын
I don't able run query... when I type show database; and tap enter it shows error.... can you please help me...?
@AYUSHKUMAR-ml5il
@AYUSHKUMAR-ml5il 2 жыл бұрын
alter table student change country region varchar(80); and sir this is for changing name of column and at the same time datatype also.
@harshkaira945
@harshkaira945 3 жыл бұрын
58:35 lol
@sahilnayak6588
@sahilnayak6588 8 ай бұрын
Very helpful, as per basic level so much covered in this vdo thanku so much brother ❤
@jaychopra8932
@jaychopra8932 2 жыл бұрын
how to add serial no. column in my existing table which have 30 rows (in mysql)
@riyadeb2988
@riyadeb2988 3 жыл бұрын
Thankyou so much this video us helpful... Want to know more about it...
@arpitsri9631
@arpitsri9631 2 жыл бұрын
Hello 🙏👍
@nileshkshatriya5827
@nileshkshatriya5827 2 жыл бұрын
Please don't do spelling mistake deliberately i know you want to increase the video size but this is not way to increase the video size it was so irritating when you do spelling mistake deliberately ...Please don't do that
@moulaalihujare6939
@moulaalihujare6939 Жыл бұрын
select * from sanam where id between 20 and 30 order by id desc; .... this query also works;
@divinecreations1
@divinecreations1 3 жыл бұрын
Thank you so much it's really good Please send me notes
@abhilive0156
@abhilive0156 2 жыл бұрын
Alter table [tb_name] Raname Column oldcolumnName to NewcolumnName;
@Aditya-jk8qr
@Aditya-jk8qr 2 жыл бұрын
When I download it shows there's no mysql server package
@gamesunboxingwithkd1174
@gamesunboxingwithkd1174 3 жыл бұрын
Notes
@saivenkat3607
@saivenkat3607 2 жыл бұрын
you forget to explain group by, sybstring, count...etc many more
@tusharverma2559
@tusharverma2559 6 ай бұрын
To change column name alter table student rename column name to first_name;
@believer-n3t
@believer-n3t 2 жыл бұрын
Bhaiya hum log script ( file ) ka use kyon nhi karte he data ko store karne ke liye, alag se software kyon chahiye🤔🤔🤔?? Reply please
@Vithal_Nivargi
@Vithal_Nivargi Жыл бұрын
Best Video! sir, please make video on JOINS
@prashantnarlawar1058
@prashantnarlawar1058 2 жыл бұрын
Thank you Durgesh. your video very nice and very ease understand....
@naveent2799
@naveent2799 10 ай бұрын
Its really good video, Are you doing cloud computing videos as well ?
@sanjurajput2260
@sanjurajput2260 Жыл бұрын
Thanks bhai.. it's really helpful..bhai muje notes chahiye thi 🙏
@developernilesh
@developernilesh 2 жыл бұрын
It's too much helpful. Thanks🙏🙏
Live Cricket Score Application using REACT JS  | Project using React JS
1:27:40
Learn Code With Durgesh
Рет қаралды 63 М.
🔥Master MySQL Database  |  MySQL Crash Course | MySQL in one video  | Part  1 | Hindi
1:21:21
Worst flight ever
00:55
Adam W
Рет қаралды 29 МЛН
Cute
00:16
Oyuncak Avı
Рет қаралды 12 МЛН
Spongebob ate Michael Jackson 😱 #meme #spongebob #gmod
00:14
Mr. LoLo
Рет қаралды 10 МЛН
Master Mysql Triggers with Practical Use Cases |  Learn MySql Triggers in Hindi
52:35
🔥MongoDB in one video | Master Mongo Db in one video | MongoDB in one video in Hindi
1:19:30
MySQL - The Basics // Learn SQL in 23 Easy Steps
17:17
Fireship
Рет қаралды 870 М.
SQL Introduction | Complete SQL course in Hindi | MySirG
50:53
MySirG.com
Рет қаралды 21 М.
SQL Views Tutorial | VIEWS in SQL Complete Tutorial
43:20
techTFQ
Рет қаралды 275 М.
you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)
24:25
NetworkChuck
Рет қаралды 1,5 МЛН
Worst flight ever
00:55
Adam W
Рет қаралды 29 МЛН