****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: kzitem.info/door/PLwGdqUZWnOp2R_BVnHPqD3aMg7wHWlL8k
@bhagyashreebane9260
5 жыл бұрын
Add plsql video also
@vinayakbelgaum4369
5 жыл бұрын
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
4 жыл бұрын
Thank you much apke video se MySQL ek dam ache se smjh aa gya
@pratimasingh915
4 жыл бұрын
Bro how to save this?
@yashaswikulshreshtha1588
4 жыл бұрын
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
2 жыл бұрын
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
2 жыл бұрын
Great
@adarshraj6679
2 жыл бұрын
@@badbuddies4220 thanks buddy 😁
@yaminipatidar206
2 жыл бұрын
Thankss
@adarshraj6679
2 жыл бұрын
@@yaminipatidar206 mention not 😊
@rushikeshkamble9680
2 жыл бұрын
super. thanks
@soniyapol5755
Жыл бұрын
1st long video which i m able to complete till end😂 its because of u thank u
@ThapaTechnical
Жыл бұрын
Most welcome 😊
@amanlodhi1688
3 жыл бұрын
Nobody, literally nobody- Thapa bro after every minute: Boom guys...😂
@shriyapandey2737
4 жыл бұрын
This lecture is informative and worth the trip,you explained smoothly. It developed my interest in SQL, thank you so much.
@ThapaTechnical
4 жыл бұрын
Welcome ☺️ please share with your friends too ☺️
@makrandtari1107
3 жыл бұрын
My too 😁
@MukeshSingh-db9di
3 жыл бұрын
Do wanna be programming partner I am searching a partner to learn
@rjsays2636
3 жыл бұрын
Ab ye hi bat hum kehete na to jutte hi pdne the 🥺🥺
@jaidmulla9550
2 жыл бұрын
♥️
@kirtisharma2959
5 жыл бұрын
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
5 жыл бұрын
Thanku so much.. plz share with your friends too ☺️
@maheshraj290
4 жыл бұрын
You are great Sir ji..........
@Alex-ml9iv
4 жыл бұрын
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
3 жыл бұрын
bro i'm also from the non IT background plz help me to get a job
@sarfraznawaz7248
4 жыл бұрын
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.
@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?
@yogeshchaudhari4113
Жыл бұрын
Best MySQL teacher ❤
@user-jh6yp6ob5o
Жыл бұрын
Nice thapalal ji 🤟👑
@manishkumar-gk3it
3 жыл бұрын
Sir delete statement is used to delete the record in table rather than deleting table itself truncate statement is also same
@akhandpratapsingh6391
4 жыл бұрын
Thanks for putting lots of effort into every topic. Thank you very much 👍🏼
@RohitSharma-ys6cq
3 жыл бұрын
really man everyone should appreciate your hard work
@arpanprakash5233
3 жыл бұрын
bhai 3 din me video complete hua notes or practice ke sath...THANKS FOR YOUR EFFORTS....PLEASE MAKE A VIDEO ON JAVASCRIPT
@Kittu-z6h
3 жыл бұрын
wowwwwwwwwww....sir best explanation ever .......thank you sir ........👏👏👏👏
@manasdas1300
5 жыл бұрын
"delete from students;"It deletes all the record without deleting the table.
@vinayakbelgaum4369
5 жыл бұрын
Try drop table command
@saailganesh
5 жыл бұрын
it is a dml command , so it will only work with ur db tuples
@ANILKUMAR-ye3rq
3 жыл бұрын
Use also truncate
@adorablecat2985
11 ай бұрын
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
@ayush_singh_23
2 жыл бұрын
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.
@67_nandanisorathiya24
4 жыл бұрын
Clear ho gya.. Thank you so much🤗🤗
@Enjoygaming73
2 жыл бұрын
very helpful sir
@Vipul_775
3 ай бұрын
awesome course ...
@Smartguyinblor
4 жыл бұрын
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
3 жыл бұрын
Hi Sumit you can checkout my channel also for this type of videos m.kzitem.info/rock/HMZR-4GkCIk_ypsx5gunEw
@RKY48
4 жыл бұрын
Good Going , Thanks for Making This Video for student
@Ashking143
4 жыл бұрын
In one video you covered a lot of things....i hope everyone must watch as beginner ......great@Thapa Technical:)
@softdev7622
3 жыл бұрын
Hi Tech Ash you can checkout my channel also for this type of videos m.kzitem.info/rock/HMZR-4GkCIk_ypsx5gunEw
@deepikasaxena640
4 жыл бұрын
This is best crash course tutorial 👌👌 very well explained point to point keep it up 👍.
@007pratibha
3 жыл бұрын
Such a comprehensive lecture 😀👍 thanks for your efforts
@maheshraj290
4 жыл бұрын
I Am very happy for my Question Reply with Video ❤️ ❤️ ❤️ ❤️
@rockagain5416
4 жыл бұрын
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
4 жыл бұрын
Welcome bro ☺️ plz share with your friends too on all social networking sites ☺️
@suyogsawale8700
2 жыл бұрын
Hatta off to you brother.....you are best
@rohitrout6450
3 жыл бұрын
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..
@chandbamotra1982
4 жыл бұрын
Bhut acha smjate ho aap
@SheGotFavour
5 жыл бұрын
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
5 жыл бұрын
thank u so much :) plz share with ur friends on Whatsapp group, Facebook n all :)
@unknown-ex9lu
4 жыл бұрын
*100M
@phoenix5195
3 жыл бұрын
Good video.... TY😘
@prasadgurav6220
4 жыл бұрын
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.
@himanshushah5697
Жыл бұрын
THNAK YOU BHAIYA Mera mysql comand prompt Mai start ho gaya shukriya
@manjusolam17
5 жыл бұрын
My all doubts are cleared in this one video... Thank you so much... 💐💐 Sir, Please upload full course on PHP..
@g9super
Жыл бұрын
Simply awesome 👍
@asheeshmishra3442
3 жыл бұрын
1:11:57 Best example to understand Set and update 😂
@vinaysharma3839
Жыл бұрын
🤣🤣🤣🤣🤣🤣
@maheshraj290
4 жыл бұрын
Great thapa sir (KZitem#1 No.1 HTML video) Please next video About PHP MySQL with Apache server🎯🙏🙏🙏🙏🙏🙏🙏🙏🙏
@ThapaTechnical
4 жыл бұрын
Suru kr diya dekho
@aayushtirole8025
4 жыл бұрын
Last night revision. . . Tomorrow is my cs viva
@shubhamsahu4637
3 жыл бұрын
Really Helpful 👍
@sapnagupta6394
4 жыл бұрын
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😊
@archanasingh5804
2 жыл бұрын
Thankyou so much for this vedio😍😍
@shabirpirbay
5 жыл бұрын
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
5 жыл бұрын
welcome bro :) plz share with ur friends on Whatsapp group, Facebook n all :)
@nitesh_saini2000
3 жыл бұрын
bhut bhut bhut badiya bro🔥🔥🔥🔥🔥🔥❤❤❤❤❤❤❤❤
@Knowledgehub837
4 жыл бұрын
Bro, you had explained each & everything so nicely...I would like to see your other videos also... :)
@ThapaTechnical
4 жыл бұрын
Thanku so much ☺️ plz share with your friends and classmates too ☺️
@bhanubhaktaadhikari3955
2 жыл бұрын
Tq so much brother collz ma padeko k padya k padya jasto lagyo hajurko video herepaxi dherai sikiyo
@rajmohanbhagat5831
4 жыл бұрын
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
@muhammadjunaid2329
3 жыл бұрын
1:24:53 select * from students order by age desc; and then grab the most top row.
@dhruvagrawal4525
4 жыл бұрын
sir i have no words to thank you for this video all my doubts are clear now
@ThapaTechnical
4 жыл бұрын
Thanks bro 😄 please share with your friends too ☺️
@arifafahmida4045
4 жыл бұрын
Can you do SQL now???
@lettechtutorials
3 жыл бұрын
Wah Thaapa jee, you are great, Respect from Lahore, Pakistan
@hrsh_013
4 жыл бұрын
This is the best video about my sql on the entire KZitem I appreciate your work sir thank you so much.👍👍👍🙏💯
@infinity4237
4 жыл бұрын
1:06:54 REALLY WONDERFUL EXPLANATION 🙏🙏🙏🙏🙏...N TAK
@New_Movie_Watch
Жыл бұрын
#1_Day_Chellagne (I'm going to complete SQL completely)
@mukeshkumar-yt9ki
3 жыл бұрын
Very Well Topic covered by Tiger Thapa... Keep it up... Good Josh
@ritunaresh4780
4 жыл бұрын
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...
@its_.hashmi_
5 жыл бұрын
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 😉
@armanhussain1935
4 жыл бұрын
It is helpful to revise all the SQL concept in one video
@mahiabdullah8880
4 жыл бұрын
Best ""MySQL in One Video"" on entire KZitem..Thanks brother 😉😉😉
@ThapaTechnical
4 жыл бұрын
Thanks bro 🙂 please share with your friends too ☺️
@mahiabdullah8880
4 жыл бұрын
@@ThapaTechnical I Already shared brother.Carry on. You are helping so many students out there.
@k.ashutoshbaitharu3964
Жыл бұрын
Everything is temporary, Boom guys is permanent. Thank you for this amazing tutorial!
@shaurya_aggarwal_G
3 жыл бұрын
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
2 жыл бұрын
After "use mysql" , you need to "select database(); " and then start the further operations. All the Best.
@suvarnachakor4700
4 жыл бұрын
Such wonderful teaching sir...thank you so much. My all querys solved here. Thank uhh ...
@dineshrajN
5 жыл бұрын
Sir make a video on advanced php(OOP's concept)
@shivkumarpatel7940
3 жыл бұрын
Check geakyShows channel playlist
@srijanshankardubey1804
3 жыл бұрын
Bhai aap bahut achhe insaan ho. God bless you.
@ismailshaik522
5 жыл бұрын
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
@फलानाधिकाना
4 жыл бұрын
very nice video Thapa sir ji ...................................
@VipinYadav-kf5hs
4 жыл бұрын
All rows are deleted when we use delete from students
@parvhusaw8624
3 жыл бұрын
Truknt
@nishitmakvana1493
3 жыл бұрын
apka video dekh ke bhot achha laga sir simple language me apne bahot kuch sikha diya thancu sir
@aniketyadav6009
3 жыл бұрын
What is database and DBMS 0:01 Types of DBMS 7:07 SQL introduction 11:10
@MrSudip1986
3 жыл бұрын
Great teacher Thanking you🐽💐🌸💮🏵🌹🌺🌻🌼🌷
@carinfo4877
4 жыл бұрын
27:11 binod .....😂😂😂
@snehasinghpippal4775
3 жыл бұрын
Thnku so mch sir 😊
@kelseycrane2707
4 жыл бұрын
14:27 sir minecraft kheltey hain ;)
@nehakashyap6191
Жыл бұрын
you have done fabulous just amazing teaching style in the very easiest way...
@ankitpanwar9485
3 жыл бұрын
Set ka example😂😂😂😂 Ladki set karna cahta hun😂😂😂
@varshasharma-xs5zl
2 жыл бұрын
Thank you Vinod... Grt way of explanations...
@CareerHirings
Жыл бұрын
Very informative for me..thankyou
@vidyakore3930
4 жыл бұрын
Thanks a lottt.... U are doing great things... Keep it up
@naimatullahmajeed1877
4 жыл бұрын
Thank u sir. You save my 12 marks. Just watching 2 hours Video .Love u.
@sanketkhedekar-br9gr
Жыл бұрын
Very helpful video. 💯 Thank You.
@tarunbhatt6185
6 ай бұрын
very nice video for a quick refresher.
@AmanSingh-nb3tk
4 жыл бұрын
Best Video for me to learn sql in just 2 hours. Thankyou Bhaiya
@kishanmunjapara5216
2 жыл бұрын
SUPER VIDEO AND GREAT EXPLAINED....VERYY THANKFUL TO YOU SIR
@irha4418
2 жыл бұрын
Wonderfully explained
@stevefox2318
3 жыл бұрын
best in class teaching style
@ajinkyajagtap3063
2 жыл бұрын
Very Nice Video.. your very clearly explain all queries of MySQL..I like it
Пікірлер: 1,3 М.