****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
@bhagyashreebane92605 жыл бұрын
Add plsql video also
@vinayakbelgaum43695 жыл бұрын
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
@abhaymishra18044 жыл бұрын
Thank you much apke video se MySQL ek dam ache se smjh aa gya
@pratimasingh9154 жыл бұрын
Bro how to save this?
@yashaswikulshreshtha15884 жыл бұрын
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..
@adarshraj66792 жыл бұрын
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
@badbuddies42202 жыл бұрын
Great
@adarshraj66792 жыл бұрын
@@badbuddies4220 thanks buddy 😁
@yaminipatidar2062 жыл бұрын
Thankss
@adarshraj66792 жыл бұрын
@@yaminipatidar206 mention not 😊
@rushikeshkamble96802 жыл бұрын
super. thanks
@RKY484 жыл бұрын
Good Going , Thanks for Making This Video for student
@amanlodhi16883 жыл бұрын
Nobody, literally nobody- Thapa bro after every minute: Boom guys...😂
@kirtisharma29595 жыл бұрын
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 🙏🏽💐👌❤️
@ThapaTechnical5 жыл бұрын
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 😊
@sarfraznawaz72484 жыл бұрын
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?
@maheshraj2904 жыл бұрын
Great thapa sir (KZbin#1 No.1 HTML video) Please next video About PHP MySQL with Apache server🎯🙏🙏🙏🙏🙏🙏🙏🙏🙏
@ThapaTechnical4 жыл бұрын
Suru kr diya dekho
@Alex-ml9iv4 жыл бұрын
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-sz4qs3 жыл бұрын
bro i'm also from the non IT background plz help me to get a job
@shriyapandey27374 жыл бұрын
This lecture is informative and worth the trip,you explained smoothly. It developed my interest in SQL, thank you so much.
@ThapaTechnical4 жыл бұрын
Welcome ☺️ please share with your friends too ☺️
@makrandtari11073 жыл бұрын
My too 😁
@MukeshSingh-db9di3 жыл бұрын
Do wanna be programming partner I am searching a partner to learn
@rjsays26363 жыл бұрын
Ab ye hi bat hum kehete na to jutte hi pdne the 🥺🥺
@jaidmulla95502 жыл бұрын
♥️
@ayush_singh_232 жыл бұрын
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-gk3it3 жыл бұрын
Sir delete statement is used to delete the record in table rather than deleting table itself truncate statement is also same
@akhandpratapsingh63915 жыл бұрын
Thanks for putting lots of effort into every topic. Thank you very much 👍🏼
@arpanprakash52333 жыл бұрын
bhai 3 din me video complete hua notes or practice ke sath...THANKS FOR YOUR EFFORTS....PLEASE MAKE A VIDEO ON JAVASCRIPT
@Ashking1434 жыл бұрын
In one video you covered a lot of things....i hope everyone must watch as beginner ......great@Thapa Technical:)
@softdev76224 жыл бұрын
Hi Tech Ash you can checkout my channel also for this type of videos m.kzbin.info/door/HMZR-4GkCIk_ypsx5gunEw
@g9super Жыл бұрын
Simply awesome 👍
@007pratibha3 жыл бұрын
Such a comprehensive lecture 😀👍 thanks for your efforts
@maheshraj2904 жыл бұрын
You are great Sir ji..........
@user-jh6yp6ob5o Жыл бұрын
Nice thapalal ji 🤟👑
@yogeshchaudhari4113 Жыл бұрын
Best MySQL teacher ❤
@manasdas13005 жыл бұрын
"delete from students;"It deletes all the record without deleting the table.
@vinayakbelgaum43695 жыл бұрын
Try drop table command
@saailganesh5 жыл бұрын
it is a dml command , so it will only work with ur db tuples
@ANILKUMAR-ye3rq3 жыл бұрын
Use also truncate
@Vipul_7754 ай бұрын
awesome course ...
@rockagain54165 жыл бұрын
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.
@ThapaTechnical5 жыл бұрын
Welcome bro ☺️ plz share with your friends too on all social networking sites ☺️
@deepikasaxena6404 жыл бұрын
This is best crash course tutorial 👌👌 very well explained point to point keep it up 👍.
@RohitSharma-ys6cq3 жыл бұрын
really man everyone should appreciate your hard work
@ajinkyajagtap30632 жыл бұрын
Very Nice Video.. your very clearly explain all queries of MySQL..I like it
@rohitrout64503 жыл бұрын
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-z6h3 жыл бұрын
wowwwwwwwwww....sir best explanation ever .......thank you sir ........👏👏👏👏
@sapnagupta63944 жыл бұрын
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😊
@muhammadjunaid23294 жыл бұрын
1:24:53 select * from students order by age desc; and then grab the most top row.
@SheGotFavour5 жыл бұрын
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 . 😘
@ThapaTechnical5 жыл бұрын
thank u so much :) plz share with ur friends on Whatsapp group, Facebook n all :)
@unknown-ex9lu4 жыл бұрын
*100M
@bhartarishinde77763 жыл бұрын
dhanyawad sir
@prasadgurav62204 жыл бұрын
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...
@Smartguyinblor4 жыл бұрын
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 .
@softdev76224 жыл бұрын
Hi Sumit you can checkout my channel also for this type of videos m.kzbin.info/door/HMZR-4GkCIk_ypsx5gunEw
@shubhamsahu46373 жыл бұрын
Really Helpful 👍
@Knowledgehub8374 жыл бұрын
Bro, you had explained each & everything so nicely...I would like to see your other videos also... :)
@ThapaTechnical4 жыл бұрын
Thanku so much ☺️ plz share with your friends and classmates too ☺️
@phoenix51953 жыл бұрын
Good video.... TY😘
@manjusolam175 жыл бұрын
My all doubts are cleared in this one video... Thank you so much... 💐💐 Sir, Please upload full course on PHP..
@varshasharma-xs5zl3 жыл бұрын
Thank you Vinod... Grt way of explanations...
@Enjoygaming732 жыл бұрын
very helpful sir
@_servantofAllah_7864 жыл бұрын
very excellent explanation sir. Sir pls make full in one vidoes as same as this one on c and c++
@asheeshmishra34423 жыл бұрын
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..
@shabirpirbay5 жыл бұрын
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 😍😍😍
@ThapaTechnical5 жыл бұрын
welcome bro :) plz share with ur friends on Whatsapp group, Facebook n all :)
@mukeshkumar-yt9ki3 жыл бұрын
Very Well Topic covered by Tiger Thapa... Keep it up... Good Josh
@aayushtirole80254 жыл бұрын
Last night revision. . . Tomorrow is my cs viva
@suyogsawale87002 жыл бұрын
Hatta off to you brother.....you are best
@rajmohanbhagat58314 жыл бұрын
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
@suvarnachakor47004 жыл бұрын
Such wonderful teaching sir...thank you so much. My all querys solved here. Thank uhh ...
@dhruvagrawal45254 жыл бұрын
sir i have no words to thank you for this video all my doubts are clear now
@ThapaTechnical4 жыл бұрын
Thanks bro 😄 please share with your friends too ☺️
@arifafahmida40454 жыл бұрын
Can you do SQL now???
@67_nandanisorathiya244 жыл бұрын
Clear ho gya.. Thank you so much🤗🤗
@hrsh_0134 жыл бұрын
This is the best video about my sql on the entire KZbin I appreciate your work sir thank you so much.👍👍👍🙏💯
@maheshraj2904 жыл бұрын
I Am very happy for my Question Reply with Video ❤️ ❤️ ❤️ ❤️
@shaurya_aggarwal_G3 жыл бұрын
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;
@vedantghodki88172 жыл бұрын
After "use mysql" , you need to "select database(); " and then start the further operations. All the Best.
@sanketkhedekar-br9gr Жыл бұрын
Very helpful video. 💯 Thank You.
@ritunaresh47804 жыл бұрын
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...
@anannyabajpai31904 жыл бұрын
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_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 😉
@jellybean54334 жыл бұрын
Thank you sir...your teaching style is great...Sir Please make one video on the difference between Mysql and Maria DB
@dineshrajN5 жыл бұрын
Sir make a video on advanced php(OOP's concept)
@shivkumarpatel79403 жыл бұрын
Check geakyShows channel playlist
@lettechtutorials3 жыл бұрын
Wah Thaapa jee, you are great, Respect from Lahore, Pakistan
@mahiabdullah88804 жыл бұрын
Best ""MySQL in One Video"" on entire KZbin..Thanks brother 😉😉😉
@ThapaTechnical4 жыл бұрын
Thanks bro 🙂 please share with your friends too ☺️
@mahiabdullah88804 жыл бұрын
@@ThapaTechnical I Already shared brother.Carry on. You are helping so many students out there.
@smartdecoder2 жыл бұрын
It's Clear Now...! Thank You.
@ismailshaik5225 жыл бұрын
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
@samra9623 жыл бұрын
Really helpful for me. Thanking you from the bottom of my herat. GBU
@aniketyadav60093 жыл бұрын
What is database and DBMS 0:01 Types of DBMS 7:07 SQL introduction 11:10
@ShopsRajMarket4 жыл бұрын
Very very nice video bhaijaan maine subscribe bhi kar diya or share bhi. Thanks a lot dude.. god bless u🙂🙂
@ShopsRajMarket4 жыл бұрын
like bhi kar diya brother
@VipinYadav-kf5hs4 жыл бұрын
All rows are deleted when we use delete from students
@parvhusaw86243 жыл бұрын
Truknt
@lavleensharma5604 жыл бұрын
You are creating this SQL tutorials as very simple language. thanks
@carinfo48774 жыл бұрын
27:11 binod .....😂😂😂
@viratsingh89048 ай бұрын
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 🙏❤️
@kelseycrane27074 жыл бұрын
14:27 sir minecraft kheltey hain ;)
@MrSudip19863 жыл бұрын
Great teacher Thanking you🐽💐🌸💮🏵🌹🌺🌻🌼🌷
@ankitpanwar94854 жыл бұрын
Set ka example😂😂😂😂 Ladki set karna cahta hun😂😂😂
@devsimplified16864 жыл бұрын
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-eb5ye4 жыл бұрын
wo fname aur age dono mila ke jo distinct pair bnega wo show kr rha hai.
@ravj70803 жыл бұрын
good knowledge in one stroke...it was so simple and clear..thanks for it.. keep it up...waits for next
@armanhussain19354 жыл бұрын
It is helpful to revise all the SQL concept in one video
@archanasingh58042 жыл бұрын
Thankyou so much for this vedio😍😍
@thelearninglinks67064 жыл бұрын
nice video...complete basic.....kp it up...
@khushi_sandhu4 жыл бұрын
This video was actually awesome. Very good explanation. Keep it up!
@kamranahmed83624 жыл бұрын
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
@tapansingh93372 жыл бұрын
great knowledge sharing keep it up i have learnt a lot from your channel..
@2007tigadi4 жыл бұрын
Really your video of MySql is very good to any one like me... Also Expect More Videos of Continue process.. Thankq...
@jyotinprakash32073 жыл бұрын
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
@vidyakore39304 жыл бұрын
Thanks a lottt.... U are doing great things... Keep it up
@irha44182 жыл бұрын
Wonderfully explained
@himanshushah5697 Жыл бұрын
THNAK YOU BHAIYA Mera mysql comand prompt Mai start ho gaya shukriya
@rajatkumarjain2889 Жыл бұрын
very nice vinod! God bless you
@sanamgadpayle37342 жыл бұрын
Thank you thank you thank you Helpful video for me...thank you so much
@tarunbhatt61856 ай бұрын
very nice video for a quick refresher.
@sourav18644 жыл бұрын
Thanks a lot for this video!!!! Very well explained , great examples and covered all topics.