Complete SQL & MySQL in One Video in Hindi 2023🙏

[@ThapaTechnical]

****Updated FEB 2022**** In this video, I covered Complete SQL & MySQL Topics In Hindi and also Added TimeLine Features too 👍📌.. 🆓🆓For Free Source Code Join my the Discord Server : discord.gg/2y73wfNXvM 👉👉 Follow me on Instagram for more: instagram.com/thapatechnical/ GUYS, PLEASE SHARE WITH ALL YOUR FRIENDS AS MUCH AS YOU CAN ♥♥ 👉👉 Follow my SQL SERIES PLAYLIST: kzbin.info/aero/PLwGdqUZWnOp2R_BVnHPqD3aMg7wHWlL8k

[@bhagyashreebane9260]

Add plsql video also

[@vinayakbelgaum4369]

Bro I have created tables using my SQL command line prompt when there is no error in code it gets created smoothly but if there is some error it shows . Then should I write the complete code again or are there any way to edit already written code... reply asap

[@abhaymishra1804]

Thank you much apke video se MySQL ek dam ache se smjh aa gya

[@pratimasingh915]

Bro how to save this?

[@yashaswikulshreshtha1588]

I am really struggling with this, i never payed any attention to any of the lectures that were taught in the classes. I am a student of class 11th and i hate this IP subject, i like to learn these programming in a friendly and very easy environment, in schools it becomes more of a theoretical subject rather than a learning subject. I am truly regretting my decision of choosing IP as my additional subject. I Wish if i could go back in time and slap my face when i made this decision. HEY if you guys are in class 10th and interested in programming and opting for IP as well as PCM then i would recommend not to choose in your school cause you might face a lot of problems during that as you'll face a lot of stress. It would be better to learn these things on your own at home. If someone says to choose it even though you don't have interest in it, then don't listen to him. TRUST ME you'll regret it!! Choose subjects of your choice and interest cause, Don't make decision quickly as told by someone. You must talk and have discussion about it with family b4 stepping ahead. A WRONG STEP CAN RUIN EVERYTHING, JUST LETTING YOU KNOW. Computer science is a fun subject until your school teacher turns it into a boring theoretical lecture and ruin your time. I wasted my whole time for those stupid lectures that were taught in my schools even though i didn't enjoy them..

[@adarshraj6679]

00:00 Introduction 00:44 What is Database? 01:30 What is collection of Data? 02:09 Where and How to store Data? 02:54 Explanation of Database using real life example 04:10 What is Database Management System? 04:53 Advantages of DBMS 05:55 Working of DBMS 07:04 Difference between SQL and NoSQL 11:10 What is SQL and MySQL? 13:30 How to use MySQL? 16:45 How to find Username and Password on PhpMyAdmin? 18:36 What will we learn? 19:35 How to check Databases using CMD and PhpMyAdmin? 21:14 How to create Database using CMD and PhpMyAdmin? 23:25 How to delete Database using CMD and PhpMyAdmin? 25:02 How to check current Database? 26:28 MySQL Data types 26:44 Why we need MySQL data types? 29:23 Different categories of MySQL data types 29:50 Int data type 30:40 Varchar data type 31:53 Date data type 32:28 How to create Table using CMD and PhpMyAdmin? 35:24 How to show Tables using CMD and PhpMyAdmin? 38:30 How to delete Tables using CMD and PhpMyAdmin? 39:17 How to insert data into Table? 43:03 How to show data of Table? 43:29 First : Small Challenge 45:11 Solution of challenge 45:55 NULL vs Not NULL in MySQL 52:22 What is Default value in MySQL? 55:22 ALTER TABLE statement for adding new column 57:22 ALTER TABLE statement for deleting column 58:34 What is PRIMARY KEY in Table? 1:03:19 What is AUTO_INCREMENT in Table? 1:06:31 CRUD operation 1:07:02 First, Create one table for CRUD operation 1:08:20 Second, Insert data in it for CRUD operation 1:09:19 Read operation : SELECT , WHERE clause 1:10:54 Update operation : UPDATE statement 1:14:05 Delete operation : DELETE statement 1:16:21 Second : Simple Task 1:16:40 SELECT DISTINCT statement in MySQL 1:18:53 ORDER BY keyword in MySQL 1:21:17 LIMIT keyword in MySQL 1:22:05 LIKE operator in MySQL 1:24:26 Aggregate Functions : COUNT(),MAX(),MIN(),SUM(),AVG() in MySQL 1:27:50 What is Logical operators? 1:28:04 Logical operator : NOT EQUAL 1:29:17 Logical operator : Greater or Less than 1:30:16 Third : Simple Task 1:30:32 Logical operator : Between...and 1:31:26 Logical operators 1:33:24 Logical operator : NOT Between...and 1:33:42 Logical operator : IN 1:35:27 String functions : CONCAT() 1:37:47 String functions : REVERSE() 1:38:24 Simple Trick to make palindrome string 1:39:22 String functions : CHAR_LENGHT(),UPPER(),LOWER() 1:39:53 Date Time data types in MySQL 1:42:33 Predefined functions of Date Time data types 1:43:48 Foreign Key Constraint in MySQL 1:45:26 Implementation of Foreign Key Constraint 1:49:00 How to show relation between Tables using Foreign key? 1:52:17 What is SQL JOIN? 1:53:26 Different types of SQL JOINs 1:53:35 What is INNER JOIN in MySQL? 1:57:38 What is LEFT JOIN in MySQL? 1:59:56 What is RIGHT JOIN in MySQL? 2:00:42 Outro

[@badbuddies4220]

Great

[@adarshraj6679]

@@badbuddies4220 thanks buddy 😁

[@yaminipatidar206]

Thankss

[@adarshraj6679]

@@yaminipatidar206 mention not 😊

[@rushikeshkamble9680]

super. thanks

[@RKY48]

Good Going , Thanks for Making This Video for student

[@amanlodhi1688]

Nobody, literally nobody- Thapa bro after every minute: Boom guys...😂

[@kirtisharma2959]

Wow just wow! Thank you first of all taking the time and hard work to create the SQL training video. I did not learn like this much in detail in school than with your full 2 hr video. I will definitely check out other videos to learn from you further. Thank you 🙏🏽💐👌❤️

[@ThapaTechnical]

Thanku so much.. plz share with your friends too ☺️

[@soniyapol5755]

1st long video which i m able to complete till end😂 its because of u thank u

[@ThapaTechnical]

Most welcome 😊

[@sarfraznawaz7248]

Extremely helpful and quality content you have man, especially for someone like me who's desperately trying to switch his career to web development and doesn't have much time left to do so. Keep up the good work and greetings from across the border.

[@adorablecat2985]

1:41=collection of data best friends, shopping list , contact, facebook use accout +2:47 =database : mind , pen , phone, computer+4:14 =database management system example: pen is database management sys 6:08 =multiple database can create +6:40 =#+7:09 +7:27 =sql vs no sql +8:24 = no sql jason format +8:48 = sql vertically scalable +10:17 =# 11:22 =sql is a standard language which we use to talk to our database

[@shalinipanigrahy8862]

you helped a students a lot hope u will get whatever u want Thank you for your efforts......

[@Ameyiscool]

what have you leaened from him? see im not here to become bf dont shy away. i want to learn web development. what have u studied?

[@maheshraj290]

Great thapa sir (KZbin#1 No.1 HTML video) Please next video About PHP MySQL with Apache server🎯🙏🙏🙏🙏🙏🙏🙏🙏🙏

[@ThapaTechnical]

Suru kr diya dekho

[@Alex-ml9iv]

Thank you very much....i have joined IT company as a fresher and being a non IT guy this video is definitely gonna help me

[@PawanSingh-sz4qs]

bro i'm also from the non IT background plz help me to get a job

[@shriyapandey2737]

This lecture is informative and worth the trip,you explained smoothly. It developed my interest in SQL, thank you so much.

[@ThapaTechnical]

Welcome ☺️ please share with your friends too ☺️

[@makrandtari1107]

My too 😁

[@MukeshSingh-db9di]

Do wanna be programming partner I am searching a partner to learn

[@rjsays2636]

Ab ye hi bat hum kehete na to jutte hi pdne the 🥺🥺

[@jaidmulla9550]

♥️

[@ayush_singh_23]

I have studies Mysql during my school days and let me tell you this video is great help in recapping the whole Mysql and for revising it . Thanks for making this available.

[@manishkumar-gk3it]

Sir delete statement is used to delete the record in table rather than deleting table itself truncate statement is also same

[@akhandpratapsingh6391]

Thanks for putting lots of effort into every topic. Thank you very much 👍🏼

[@arpanprakash5233]

bhai 3 din me video complete hua notes or practice ke sath...THANKS FOR YOUR EFFORTS....PLEASE MAKE A VIDEO ON JAVASCRIPT

[@Ashking143]

In one video you covered a lot of things....i hope everyone must watch as beginner ......great@Thapa Technical:)

[@softdev7622]

Hi Tech Ash you can checkout my channel also for this type of videos m.kzbin.info/door/HMZR-4GkCIk_ypsx5gunEw

[@g9super]

Simply awesome 👍

[@007pratibha]

Such a comprehensive lecture 😀👍 thanks for your efforts

[@maheshraj290]

You are great Sir ji..........

[@user-jh6yp6ob5o]

Nice thapalal ji 🤟👑

[@yogeshchaudhari4113]

Best MySQL teacher ❤

[@manasdas1300]

"delete from students;"It deletes all the record without deleting the table.

[@vinayakbelgaum4369]

Try drop table command

[@saailganesh]

it is a dml command , so it will only work with ur db tuples

[@ANILKUMAR-ye3rq]

Use also truncate

[@Vipul_775]

awesome course ...

[@rockagain5416]

Really A good videos about dbms and sql . Many confusion was in my mind but when i saw your video its totally solved thanks for making such a video.

[@ThapaTechnical]

Welcome bro ☺️ plz share with your friends too on all social networking sites ☺️

[@deepikasaxena640]

This is best crash course tutorial 👌👌 very well explained point to point keep it up 👍.

[@RohitSharma-ys6cq]

really man everyone should appreciate your hard work

[@ajinkyajagtap3063]

Very Nice Video.. your very clearly explain all queries of MySQL..I like it

[@rohitrout6450]

I wonder from where you gather so precise and prefect understanding about any topic. Because no one is there who clarify things so beautifully just like you❣️❣️🎗️keep it up..

[@Kittu-z6h]

wowwwwwwwwww....sir best explanation ever .......thank you sir ........👏👏👏👏

[@sapnagupta6394]

Very informative video, also how to convert subquery into join query pls tell. Tia, I edited bcoz I wanted to say AWESOME VIDEO AND KNOWLEDGE YOU HAVE Thanks alot😊

[@muhammadjunaid2329]

1:24:53 select * from students order by age desc; and then grab the most top row.

[@SheGotFavour]

Today i was wondering what is sql and dbms , and this evening i got u... Thank u so mch yar....ur video was enough to understand what sql is... May God Bless uh and increase ur subscribers to 1M . 😘

[@ThapaTechnical]

thank u so much :) plz share with ur friends on Whatsapp group, Facebook n all :)

[@unknown-ex9lu]

*100M

[@bhartarishinde7776]

dhanyawad sir

[@prasadgurav6220]

Thanks Thapa !!! for such a lovely video , I was scared earlier about database but after completion of this video i can say i know database and i know how to write query. This video help me a lot Thanks once again. you made video for 2 hrs but i seated whole day and i did practice side by side . Grate Work !!! I surely recommend this video.

[@DebMohantaOfficial]

Thnq very much that you have completed SQL in one video waah tis us very fantastic.All the best for your channel...

[@Smartguyinblor]

It's awesome . I didn't get SQL in my college but after watching this video of yours , it has given me a base of SQL. A big thanks for that .

[@softdev7622]

Hi Sumit you can checkout my channel also for this type of videos m.kzbin.info/door/HMZR-4GkCIk_ypsx5gunEw

[@shubhamsahu4637]

Really Helpful 👍

[@Knowledgehub837]

Bro, you had explained each & everything so nicely...I would like to see your other videos also... :)

[@ThapaTechnical]

Thanku so much ☺️ plz share with your friends and classmates too ☺️

[@phoenix5195]

Good video.... TY😘

[@manjusolam17]

My all doubts are cleared in this one video... Thank you so much... 💐💐 Sir, Please upload full course on PHP..

[@varshasharma-xs5zl]

Thank you Vinod... Grt way of explanations...

[@Enjoygaming73]

very helpful sir

[@_servantofAllah_786]

very excellent explanation sir. Sir pls make full in one vidoes as same as this one on c and c++

[@asheeshmishra3442]

1:11:57 Best example to understand Set and update 😂

[@vinaysharma3839]

🤣🤣🤣🤣🤣🤣

[@nehakashyap6191]

you have done fabulous just amazing teaching style in the very easiest way...

[@New_Movie_Watch]

#1_Day_Chellagne (I'm going to complete SQL completely)

[@ramphapal6610]

really this is very very import ,, and your teaching style also excellent . you teach very smooth and uderstandable format ,, THANK YOU bhai for become that's type of video..

[@shabirpirbay]

Hello I followed all the previous video about MySQL and this video is excellent to end all the series about it. Great job god bless you!!!!! Thanks a lot for your help very helpfull for someone like me starting in coding 😍😍😍

[@ThapaTechnical]

welcome bro :) plz share with ur friends on Whatsapp group, Facebook n all :)

[@mukeshkumar-yt9ki]

Very Well Topic covered by Tiger Thapa... Keep it up... Good Josh

[@aayushtirole8025]

Last night revision. . . Tomorrow is my cs viva

[@suyogsawale8700]

Hatta off to you brother.....you are best

[@rajmohanbhagat5831]

Sir, thanks a lot This video is just AweSOME... it's the first time I'm on ur channel and i found it the BEST...i paused the video to like subscribe and comment Thankyou again

[@suvarnachakor4700]

Such wonderful teaching sir...thank you so much. My all querys solved here. Thank uhh ...

[@dhruvagrawal4525]

sir i have no words to thank you for this video all my doubts are clear now

[@ThapaTechnical]

Thanks bro 😄 please share with your friends too ☺️

[@arifafahmida4045]

Can you do SQL now???

[@67_nandanisorathiya24]

Clear ho gya.. Thank you so much🤗🤗

[@hrsh_013]

This is the best video about my sql on the entire KZbin I appreciate your work sir thank you so much.👍👍👍🙏💯

[@maheshraj290]

I Am very happy for my Question Reply with Video ❤️ ❤️ ❤️ ❤️

[@shaurya_aggarwal_G]

Create database Mysql; Show databases; Use Mysql; Create table students(name varchar(20), age int); Show tables; Insert into students Values('Hello',15); Select *from students;

[@vedantghodki8817]

After "use mysql" , you need to "select database(); " and then start the further operations. All the Best.

[@sanketkhedekar-br9gr]

Very helpful video. 💯 Thank You.

[@ritunaresh4780]

Woah! This was really helpful.. I've watched it till the end.. And BTW you did way too much to teach.. Hats off to your efforts! Thank you once again...

[@anannyabajpai3190]

Will this video be cover all the chapters of class 11 Python sumit arora Chapters - relational databases - simple queries in SQL - table creation and data manipulation commands - basics of nsql database Sir please reply 🙏

[@its_.hashmi_]

Thanks for your video bro, i have completed 1 hour , Any ready for notes . If you have some video on 'css' plz give me that link. I am very thankful to you for this video 😘 And don't worry i have already shared your video 😉

[@jellybean5433]

Thank you sir...your teaching style is great...Sir Please make one video on the difference between Mysql and Maria DB

[@dineshrajN]

Sir make a video on advanced php(OOP's concept)

[@shivkumarpatel7940]

Check geakyShows channel playlist

[@lettechtutorials]

Wah Thaapa jee, you are great, Respect from Lahore, Pakistan

[@mahiabdullah8880]

Best ""MySQL in One Video"" on entire KZbin..Thanks brother 😉😉😉

[@ThapaTechnical]

Thanks bro 🙂 please share with your friends too ☺️

[@mahiabdullah8880]

@@ThapaTechnical I Already shared brother.Carry on. You are helping so many students out there.

[@smartdecoder]

It's Clear Now...! Thank You.

[@ismailshaik522]

Sir why Can't you mention the Time of that Concept instead of Giving Numbers????...Try to Comment the Time with respect to the concept.. please sir

[@samra962]

Really helpful for me. Thanking you from the bottom of my herat. GBU

[@aniketyadav6009]

What is database and DBMS 0:01 Types of DBMS 7:07 SQL introduction 11:10

[@ShopsRajMarket]

Very very nice video bhaijaan maine subscribe bhi kar diya or share bhi. Thanks a lot dude.. god bless u🙂🙂

[@ShopsRajMarket]

like bhi kar diya brother

[@VipinYadav-kf5hs]

All rows are deleted when we use delete from students

[@parvhusaw8624]

Truknt

[@lavleensharma560]

You are creating this SQL tutorials as very simple language. thanks

[@carinfo4877]

27:11 binod .....😂😂😂

[@viratsingh8904]

Dil se ❤ sukriya bhaiya sach m all concepts cleared of SQL in a single video. Please make videos on other computer science subjects like - computer networking, operating system etc. Because the way of your teaching is very good. Bhut achhe se smaj aata h kyuki easy kar dete ho ek daam topics ko again thank you bhaiya ji 🙏❤️

[@kelseycrane2707]

14:27 sir minecraft kheltey hain ;)

[@MrSudip1986]

Great teacher Thanking you🐽💐🌸💮🏵🌹🌺🌻🌼🌷

[@ankitpanwar9485]

Set ka example😂😂😂😂 Ladki set karna cahta hun😂😂😂

[@devsimplified1686]

1:18:32 Select distinct fname, age from students; I feel ki yeh bus distinct fname return kr rha hai....jaise aap output mai dekh sakte ho ki bus vinod ek baar aaya hai

[@Anandkumar-eb5ye]

wo fname aur age dono mila ke jo distinct pair bnega wo show kr rha hai.

[@ravj7080]

good knowledge in one stroke...it was so simple and clear..thanks for it.. keep it up...waits for next

[@armanhussain1935]

It is helpful to revise all the SQL concept in one video

[@archanasingh5804]

Thankyou so much for this vedio😍😍

[@thelearninglinks6706]

nice video...complete basic.....kp it up...

[@khushi_sandhu]

This video was actually awesome. Very good explanation. Keep it up!

[@kamranahmed8362]

Very good video for SQL and MYSQL Great efforts, please keep going.

[@baldevyadav4122]

You are great

[@knowledgepeak_]

*Great sir amazing love you your voice sir really amazing amazing knowledge very helpful for me* *Thanku so much sir* 🙌🏻

[@jagupatigolguri1875]

Nice explanation.. Keep it up with more videos

[@tapansingh9337]

great knowledge sharing keep it up i have learnt a lot from your channel..

[@2007tigadi]

Really your video of MySql is very good to any one like me... Also Expect More Videos of Continue process.. Thankq...

[@jyotinprakash3207]

Exceptional work, gr8 mr. Vinod👍😊

[@Raghuvendra26]

For full SQL course, reach out to me in the comments section of this video- Creating db and tables - kzbin.info/www/bejne/epuyan-BmrOHf5I

[@vidyakore3930]

Thanks a lottt.... U are doing great things... Keep it up

[@irha4418]

Wonderfully explained

[@himanshushah5697]

THNAK YOU BHAIYA Mera mysql comand prompt Mai start ho gaya shukriya

[@rajatkumarjain2889]

very nice vinod! God bless you

[@sanamgadpayle3734]

Thank you thank you thank you Helpful video for me...thank you so much

[@tarunbhatt6185]

very nice video for a quick refresher.

[@sourav1864]

Thanks a lot for this video!!!! Very well explained , great examples and covered all topics.