Bhai Maine Interview se ek din pehle aapka channel dekha aur tb mujhe dbms k basics bhi clear nhi the but your videos helped me a lot. Aur meri placement ho gyi. Thanks bro
I came here after I had some doubts while watching udemy course, and boy it worked. Concepts got into my head much more clearly. Thanks a lot for this wonderful session.
sir aap to dbms ke god hain One of the best teacher I have found on RUclips, hats off to your teaching style!. May god bless you. sir aap jo padhate hain vo ek baar main hi poora samajh aa jata hai
The way you teaches clears every doubt and helps in building a strong concept..it really helped me. Every concept is beautifully taught and can be easily understandable.
In college even if i tried to concentrate the concept was not taught properly,but You made it soo simple sir, the conditions are all stuck to head, you r really fantastic sir,hats off
Sir hats off to you man literally , ty tysm for doing it for free .Ik its hard for u to make such qualty and loads of content for us , but really sir you are shaping the future generation . Loads of appreciation : )
This is the only reason I can manage to get an A* in computer science even if I don't listen in computer class XD Great job sir, you have a very clear way of explaining things.
GATE 2004 for practice Consider the following relation schema pertaining to a students database: Student (rollno, name, address) Enroll (rollno, courseno, coursename) where the primary keys are shown underlined. The number of tuples in the Student and Enroll tables are 120 and 8 respectively. What are the maximum and minimum number of tuples that can be present in (Student * Enroll), where '*' denotes natural join ? A 8, 8 B 120, 8 C 960, 8 D 960, 120
To find max and min Join the table by using natural join 120×9=960 After joining both table the total tuple will be 960 And the tuple that are matching the rollno it could be total 8 tuple.why so? Because the enroll has the 8 tuple so the automatically the value of total tuple will be get 8 So the max=960 Min=8
I am from Pakistan and I love the way you teach is very clear and concise. Masha Allah your way of teaching is just amazing and you are really hard work person. I cleared all my concepts regarding with joins for the preparation of my FYP viva exams in short period of time just because of you. Thnaks alot :)
your videos are like the VEDAS of all the topics. Iske alaava there is no need to study anything. Concepts are so clear now. Thanks a lot. And yeah your videos do help a lot in placements and examinations.
Sir me jis area se hu wha itana knowledge nhi h ...... because of you .......I got pass last year ...... network issue ke karan me download kr ke dekha ta hu ....... really your God GIFT for me .... Thank you so much
Earlier i don't like dbms but when i started watching ur videos its jst clear my all basics nd now its become my one of the fav subjects..thnx a lot sir ..ur videos really help me alot
Just wowwww...Great way of teaching.. Finally a tough battle with the join concept has been put to an end sir... Thank you very much for explaining it so beautifully
Sir apka teaching style amazing h sb kuch 1 baar me hi samgh aa jata h sare concept clear ho jate h thank you sir itna achche se toh coaching Wale bhi nhi samghate h You are the world's best teacher 💐
I am so grateful of this universe for your existence... What a wonderful teacher you are.. Thankyou for doing all this hard work to help students for free. This world needs more teachers like you... This whole playlist has been a savior for me. Thankyou soooooo much..... 🙏🏼🙏🏼🙏🏼🙏🏼😭😭😭😭
Got most of my doubts covered in this video. Sir has provided very detailed explanation by drawing entire cross-product table which made understanding easier! Thank you!
Seriously in my whole engineering career and infact today when I am preparing for interview, I only trust your tricks... Thank you Gate Smasher ❤️ you're saviour
thank you for all the hardwork , I can see you sweating a lot but , not break the flow you keep the video running , its really interesting and I love these classes for a detailed study and overview.
Sir, Apka excellent way of explaination better understanding provide kr rha hai ,, aur apka Efforts se bhot motivation mil rha hai....... Thank you Sir
Great teaching, I was having so much confusion about the joins concept but now it is crystal clear to me. Thank you very much for teaching whole dbms subject. Respect and love from Pakistan ❤👌👍 A teacher should have a quality like this guy that when he teaches the student, student gradually starts to love the subject.
Respected Sir! I am your CS student. Your videos always helped me a lot.. whenever I have to study a topic, My first priority is always your lecture and I also suggest my friends to take your lectures,, you are best & my Favorite Teacher🤜🤛 at this level. hats off to your way of teaching.. Love from Pakistan🍰
Who is here 2023? Inner join for SQL brought me to your page and it's like I'm in a direct class with a professor. Thank you for sharing your knowledge and for the Subtitles to us Non-Hindi.
Respected sir...now I am pursuing btech in 3rd year CSE...I am still aspirants for gate exam....this is my 6th semester...and I am prepared for your gate related sub dbms,os,and networking...and dbms concept is clear...till natural join operation....and got a 67marks out of 70 in our college.....thank you so much...my target to be gain a good mark also rank in gate...plz help me without your video I am feeling a disappointed condition....
Thank u sir🙏! I was not understanding joins at all I had search every video and resources for website. Finally I got your channel and now my joins concepts are clear. I have one more suggestion please also make your videos in english because non-hindi speakers or even foreign students for them also it will be easy to understand your concepts. The way you had simplified explain joins nobody had teach you had made so easy to understand.
You are best sir.. Ur explanation is so easy and best way for understand.. Really I was so confused about join.. Bt now it's so easy... Thank a lot.. Keep it up Happy codeing :)
Ek hamara education system hai jisme paisa hi paisa bharte jao, RUclips na ho to baccho k guzara na ho. Thank you sir you deserve more subscriber.☺️
Thnx bhai mughje jagruk Krna kai lia 🛐
4 saal baad bhi kuch nhi badla bhai😢
Bhai Maine Interview se ek din pehle aapka channel dekha aur tb mujhe dbms k basics bhi clear nhi the but your videos helped me a lot. Aur meri placement ho gyi. Thanks bro
Ohhh great...Big congratulations. Which company??
congrats bro, I am watching too and tomorrow is my interview :')
@@GateSmashers Optum
kitne ki hui bro
@@hepfrem1386 requirements criteria kiya tha brother
Sir i am not skipping the advertisement....since u r working so hard 4 us...
hahaha..Thank You Dear
Bro Knowledge Gate bhi to sahi hein . Pata to tumko wo bhi hoga.. please uske Add bhi skip mat karna. paap lagega
@@AyushGupta-lb5st😮
This whole DBMS playlist helped me get into Infosys. Thank you so much Sir. Love you. ❤️
Congratulations..Dont forget to share with others.
@@GateSmashers sure sir.
I am also preparing for job only i am cse student you recommend watching the whole playlist?
@@manmeetkaur80 yes, go ahead with this playlist. It'll help you a lot to crack interview questions.
Woah, I will appear for a test for placement in Infosys this April .. Wish me luck !!!
I came here after I had some doubts while watching udemy course, and boy it worked. Concepts got into my head much more clearly. Thanks a lot for this wonderful session.
sir aap to dbms ke god hain
One of the best teacher I have found on RUclips, hats off to your teaching style!. May god bless you.
sir aap jo padhate hain vo ek baar main hi poora samajh aa jata hai
The way you teaches clears every doubt and helps in building a strong concept..it really helped me. Every concept is beautifully taught and can be easily understandable.
In college even if i tried to concentrate the concept was not taught properly,but You made it soo simple sir, the conditions are all stuck to head, you r really fantastic sir,hats off
This is the best educational channel on RUclips !!!
The way he tells the hard concepts in easy way is super!!!
thank You sir
One of the best teacher I have found on RUclips, hats off to your teaching style!. May god bless you.
Sir hats off to you man literally , ty tysm for doing it for free .Ik its hard for u to make such qualty and loads of content for us , but really sir you are shaping the future generation . Loads of appreciation : )
अध्वूत ज्ञान हैं आपकी इस विषय में।
प्रणाम।
I wish the faculty of computer science in my college had more teachers like you :(
This is the only reason I can manage to get an A* in computer science even if I don't listen in computer class XD Great job sir, you have a very clear way of explaining things.
Before this video I don't know anything natural join , now all is clear , so lot of thans for the same
GATE 2004 for practice
Consider the following relation schema pertaining to a students database:
Student (rollno, name, address)
Enroll (rollno, courseno, coursename)
where the primary keys are shown underlined. The number of tuples in the Student and Enroll tables are 120 and 8 respectively. What are the maximum and minimum number of tuples that can be present in (Student * Enroll), where '*' denotes natural join ?
A
8, 8
B
120, 8
C
960, 8
D
960, 120
A
D
Answer toh batado sir ( my choice is option A )
Sir, you said cross product is necessary in natural join but I hear cross product is necessary in cartesian join. Plzz reply
To find max and min
Join the table by using natural join
120×9=960
After joining both table the total tuple will be 960
And the tuple that are matching the rollno it could be total 8 tuple.why so? Because the enroll has the 8 tuple so the automatically the value of total tuple will be get 8
So the max=960
Min=8
I am from Pakistan and I love the way you teach is very clear and concise. Masha Allah your way of teaching is just amazing and you are really hard work person. I cleared all my concepts regarding with joins for the preparation of my FYP viva exams in short period of time just because of you. Thnaks alot :)
Compare the Pakistani and Indian RUclips channels. The difference is clear.
Where are you from
I means in which city
No way.... what an unbelievable explanation. CrossProduct + condition , now I understood. Thank you!
your videos are like the VEDAS of all the topics. Iske alaava there is no need to study anything. Concepts are so clear now. Thanks a lot. And yeah your videos do help a lot in placements and examinations.
I think this concept will remain forever in my mind.. Thnku so much sir for so much efforts ❤
Ek baar me concept clear kar dete hai sir aap....
God bless you...
your lecture on Operating system and DBMS helped me to cover my whole Semester syllabus ,Thanks Bhai
Sir me jis area se hu wha itana knowledge nhi h ...... because of you .......I got pass last year ...... network issue ke karan me download kr ke dekha ta hu ....... really your God GIFT for me .... Thank you so much
One of the best explanation of join on RUclips.
A great Teacher! Hattsoff
Earlier i don't like dbms but when i started watching ur videos its jst clear my all basics nd now its become my one of the fav subjects..thnx a lot sir ..ur videos really help me alot
Just wowwww...Great way of teaching.. Finally a tough battle with the join concept has been put to an end sir... Thank you very much for explaining it so beautifully
Sir ap he legend Ironman of knowledge.Ap ke parane se sablok lok thanos(exam) ko mar rehe he.
Sir apka teaching style amazing h sb kuch 1 baar me hi samgh aa jata h sare concept clear ho jate h thank you sir itna achche se toh coaching Wale bhi nhi samghate h
You are the world's best teacher 💐
man, you really needs an appreciation for helping in free, on the other hand institutions are taking huge money for nothing..
your explanation is really good and point to point..i came here to just brush-up my knowledge.really amazing..keep it up.
I am so grateful of this universe for your existence... What a wonderful teacher you are.. Thankyou for doing all this hard work to help students for free. This world needs more teachers like you...
This whole playlist has been a savior for me. Thankyou soooooo much..... 🙏🏼🙏🏼🙏🏼🙏🏼😭😭😭😭
Blessings
Got most of my doubts covered in this video. Sir has provided very detailed explanation by drawing entire cross-product table which made understanding easier! Thank you!
Wow! I am amazed how someone can explain so beautifully well.
First time, I have understood what are Joins. Thank You Sir! :)
Seriously in my whole engineering career and infact today when I am preparing for interview, I only trust your tricks... Thank you Gate Smasher ❤️ you're saviour
Bhai kya jhosh jagaya h 😂😍😍😍😍🤗🤗🤗🤗🤗 awesome will continue and prompt ur video
Thank you so much sir... your video help me lot.. interviewer ask me questions and all answers got from videos. u build my career. lots of blessings
So much wealth of valuable information all at one place !!! You are a master of masters !!!
Now i can answer my DBMS paper well. Thank you!
very informative video...even using this as a guide for my Master's classes in US Universitiy
its a great complement. Thank you for your support from US.. Bless you
thank you for all the hardwork , I can see you sweating a lot but , not break the flow you keep the video running , its really interesting and I love these classes for a detailed study and overview.
best explained without application, logically cleared the concepts , Thank you :)
Sir, Apka excellent way of explaination better understanding provide kr rha hai ,, aur apka Efforts se bhot motivation mil rha hai.......
Thank you Sir
24 carat pure Gold Teaching, Content and Varun Sir..❤❤
superb bro ,nicely explained ,you really dominated the routine teacher's style.9/10.u prevailed
your knowledge in dbms is indeed real, keep up the good work!!!
Finally understood how cross-product works. Thank you very much
Bhaiya...u r great.........great explanation.......sub kuch ek hi baar me clear ho jaata h......amazing
Wow... amazing nobody teaches like you. You should keep doing sir. keep shining and growing. TRUE TEACHER...
If this teaching was there in my college life, I would have become a computer scientist today !
Great effort sir.. thank for providing such knowledgeable video free of cost
So nice of you
Bhai kya mast explain karte ho, kya concepts clear hue mai ekdum satik. Love you bro!
Great teaching, I was having so much confusion about the joins concept but now it is crystal clear to me. Thank you very much for teaching whole dbms subject. Respect and love from Pakistan ❤👌👍 A teacher should have a quality like this guy that when he teaches the student, student gradually starts to love the subject.
you are a great teacher,I live in canada and preparing for some hard certification and your videos are making concepts so easy to understand,thanks
Your videos are brief and too the point. Well explained sir , Thanks for clearing concepts 😊
Respected Sir! I am your CS student. Your videos always helped me a lot.. whenever I have to study a topic, My first priority is always your lecture and I also suggest my friends to take your lectures,, you are best & my Favorite Teacher🤜🤛 at this level. hats off to your way of teaching.. Love from Pakistan🍰
Sir, Bohot achese smjhate ho aap. Bohot punya milega aapko from all the students :)
Who is here 2023? Inner join for SQL brought me to your page and it's like I'm in a direct class with a professor. Thank you for sharing your knowledge and for the Subtitles to us Non-Hindi.
Great Sir !!'
" Well Explained"
You are great sir..than all youtube channel related to cse
Thank you so much for your valuable feedback
Respected sir...now I am pursuing btech in 3rd year CSE...I am still aspirants for gate exam....this is my 6th semester...and I am prepared for your gate related sub dbms,os,and networking...and dbms concept is clear...till natural join operation....and got a 67marks out of 70 in our college.....thank you so much...my target to be gain a good mark also rank in gate...plz help me without your video I am feeling a disappointed condition....
And I have shear your video all my college friends..
this playlist is a complete saviour for us!!
10/10 for teaching style.
Thanks for amazing course.
Bhut hi Behtareen smjhate hain ap sir aur smjh b aata hai.. Thanks a lot☺️
Being a mech engineer, I started my first computer lang with your channel. Have interview in 2 days. Hope I will clear it.
Best of luck brotha
@@legend7890 fucked it!😂 Thanks anyways
Yar really ..no one is like you...your way of teaching is jaw-dropping ❤❤❤❤lots of love from kashmir
Fan of u r teaching.. writing all cross product really shows how query executes thank you so much
Really you are genius sir .................
Explained really well, thanks...
Apne bahut accha padhaya hai sachme. Thank you
Each and every point is very well explained,i am very-2 thankful to you sir!!!!
mast samjate hai sir aap...ek bar meh clear ho gya
great as @gatesmasher
your teaching skill beyond the level of many ones
Well done sir. I like such basic way of explanation
BAHUT SHAANDAAR PADHAYA HAI SIR APNE
Kya hi mast concept clear krwa dete ho sir 🙏🙏
Father of Informatics Practices
Thank u sir🙏! I was not understanding joins at all I had search every video and resources for website. Finally I got your channel and now my joins concepts are clear. I have one more suggestion please also make your videos in english because non-hindi speakers or even foreign students for them also it will be easy to understand your concepts.
The way you had simplified explain joins nobody had teach you had made so easy to understand.
bhai bht acha tariqa ha apki videos dekhi bht kuch sekhny ko mila sir
wow... that's the way of teaching...fabulous sir
bhaijan buhut shukria aap ka parhane ka tariqa buhut acha hay
I m in love with your dbms playlist ❣️❣️❣️
Bahut badhiya bahut Badhiya
Really concept is fully clear...So thankk u so much ji..Stay blessed...may u live long!..🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Best way of explaining topics, salute 👏 👌
Osm vedio bro thanks you so much
Super sir you are working internal processing also
Hats off to you, clear explanation of a important topic.
No words for your explanation way sir👏 as a fresher its helps me a lot... thank you so much for everything.god bless u
great sir
Omg thank you so much sir..your teaching skills are great...I wish you were my teacher.
बहुत बहुत धन्यवाद सर जी 🙏
I'm in 12 class
Nd glad to have a teacher like u
Really good explanation sir😊😊
Pls upload some questions related to joins
Nice way of explain. Best way of Teaching. Salute
I m just fan of ur teaching style and i have seen almost all ur videos.thanku for all videos.
Bahot badiya Sir aap bahot acche se explain karte ho .
You are best sir..
Ur explanation is so easy and best way for understand..
Really I was so confused about join..
Bt now it's so easy...
Thank a lot..
Keep it up
Happy codeing :)
sir no words to thank you..feel blessed
Your Video Clear my all doubts..
Thanks a Lot..
Keep it Up..
Full support..❤️❤️🎉
we no need to write where condition in natural join?
top-class teaching style