IIT se passed out teachers bhi apke jaisi explanation nahi de paate... Thanks for making our concepts clear in the best and simplest way... Simply Superb Explanation!!!
Hello Babaljeet, thanks for appreciation and such a delightful comment, we are glad that we could help you in understanding concepts, happy to help. :)
Just wanted to tell you how helpful your videos have been in understanding Normalization. You are great at explaining these things and your redundancy with redefining terms is quite helpful. Keep up the good work!
Thank you so much! This means a lot! Keep learning & stay connected for more amazing contents👍😊 You can also check out our course for all Computer Science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science
This made the concept alot clearer, and broke it down properly without making it really complicated from the start. Loved this. I'm doing an exam tonight and will use some of this in it!!!!
Hello Pranjal, you just made me laugh, Thank you so much, would like to hear more from you. We upload more topics every week, Please subscribe this channel for best GATE tutorials. :)
He is in angry mood.. If C is a non prime attribute, how the hell can he find D. And there it goes, AB broke the promise 😖 I like the way you teach.. Nice tutorial sir 😄
These videos are incredibly good!!!! My native language is Spanish, but even so I managed to learn a lot from this lecturer. You're incredibly good!!! If you added some subtitles, specially for the parts when you don't speak in English these videos would be better than a DB course at a top university, as the one Im studying. Keep it up!! Thanks!!!
The way you explain the concepts is very good. Your videos are really helpful . You made it so easy to understand the concepts of DBMS. Thank you so much Sir..
Amazing video sir my college professors are nothing compares to you even I can teach better than them after watching your videos God bless u sir thanks again
Yar sanchit i am also a teacher but your explanation is so good not so good........... its very very good i am a big fan of you wow kitna easy bana diya yar tumne normalization .... thanks boss [Now you are my teacher from today]
my university teacher took 2 weeks to complete upto 3NF but was not able to do the amazing work you did sir,in such short videos..... thanks sir really impressive
10:28 phat hi gyi, well your videos are really so awesome I was trying to understand the concept of normalization for 2hours but after watching your videos I am clear now
Thanks sir your videos are too helpful but the only problem i face in it was your speed of moving ahead is a bit more. Other than that the concepts you teach are just cleared in a single go.
Because of these videos I scored 9 point in DBMS in my university exams(MAKAUT, formerly WBUT). I used to struggle so badly with these concepts previously, but a friend suggested this channel. Thank you Sanchit Sir, may your mission and vision be successful. :-)
so here for 3rd normal form it is making non prime attribute prime so there wont be occurance of null value and we can directly find the value of the other non prime attribute through candidate keys. so if we make non prime a prime attribute ,. Then it also becomes the part of candidate key!! . But while identifying candidate key , we see there is no incoming path on they keys ,those we set as candidate keys. So in conclusion can we set it as a C as prime attribute .? hope u get my doubt....
Hi Pushpendra,Thank you so much, would like to hear more from you. We upload more topics every week, Please subscribe this channel for best GATE tutorials.
For complete DBMS, check out this video: th-cam.com/video/YRnjGeQbsHQ/w-d-xo.html
IIT se passed out teachers bhi apke jaisi explanation nahi de paate... Thanks for making our concepts clear in the best and simplest way... Simply Superb Explanation!!!
Hello Babaljeet, thanks for appreciation and such a delightful comment,
we are glad that we could help you in understanding concepts, happy to help. :)
Even the teachers at my college don't make such efforts! You're one of the best teachers, I must say:)
I think now your BTech is completed right ?
@@abhyudaychaturvedi3416 lol no I was doing bsc in physics. And now I'm about to complete my master's degree 😆
@@reshminayak195 ohh okay 😂😂
"C neta banna chahta tha, toh humne use bana diya". I laughed a little! :D
your sarcasm game is excellent
"Then how the hell you'll find the value of D?" 😂😂😂
Well said bruh.
i was looking for this comment after listening that dialog, lol 😂😂😂
Was about to write same comment 😂😂
damn😂
🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg
🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg
Just wanted to tell you how helpful your videos have been in understanding Normalization. You are great at explaining these things and your redundancy with redefining terms is quite helpful. Keep up the good work!
Hi Diana, thank you so much for your encouraging and delightful words.
We are glad that we could be helpful. :) :)
Teachers are super hero's too...!
And you are my favorite super hero sir
even though you are not well you are teaching us
love u sir!!
Thank you so much 😀 Stay blessed & keep supporting ! You can also visit our website www.knowledgegate.in for more amazing courses & contents 👍😊
Am i the only one who likes sir delivering lecture in 2x speed?. 😁
1.5 i prefer
chutiya
@@chhatrapalnayak3946 agreed
Bhai daru Pike mat dekha Kar😅
Haha me too bro 1.5 or 2 either😁😁
Simplest example I have ever seen. I am a senior database developer and never found such an easy example since my college days. Keep it up sir.
Every time he speaks i feel like i should write it in my notebook.. example are just amazing..
Thanks for showing your gratitude,glad i could help.
piyush Poply Seriously the same thought came in my mind.
piyush Poply meee too
It's so true
Even after qualifying GATE and reaching NIT Jamshedpur, watching these lectures to revise the old concepts. Thanks a lot sir.
You're most welcome dear❤ Keep learning & supporting, stay connected 👍😊
Congrats buddy..
now sir,u are leader of dbms,thanksssssssssssssssssssssssssss
the best teacher on youtube,suberb explanation sir.
aapki tarif mai eassy bhi likh du to vo bhi kam hai .
In DBMS no one can beat you on entire earth... Practice problem is the major strength of the series... Keep it up in every subject..
Thank you so much! This means a lot! Keep learning & stay connected for more amazing contents👍😊 You can also check out our course for all Computer Science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science
sir,i cant explain how much you helped us by making these videos..
great job sir..agr bachpan se aise teacher milte to sayd kuch aur acha hota..
This made the concept alot clearer, and broke it down properly without making it really complicated from the start. Loved this. I'm doing an exam tonight and will use some of this in it!!!!
10:21 take a breath Sir , thanks alot for all of this
c ko neta banne do!!! awesome sir!!! Your way of teaching the concepts is unbeatable.....unique and really simple
Hi Sunny, we truly appreciate your kind words for our efforts :)
thank you so much for your support :)
Thanku Very Much Sir...
Exam ki ek raat phle hi video dekh raha hu or sb ese clear ho rahe hai jese kl hi pdha ho :-)
Bohot Sahi sir, mja aa gya padh kr, m aapke lagatar videos dekh rha hu....sbse shi wo lgta h sir "k yha pr B neta ban rha h".....
Hello Pranjal, you just made me laugh, Thank you so much, would like to hear more from you. We upload more topics every week, Please subscribe this channel for best GATE tutorials. :)
He is in angry mood.. If C is a non prime attribute, how the hell can he find D. And there it goes, AB broke the promise 😖
I like the way you teach.. Nice tutorial sir 😄
You made it so easy to understand :) Thank you for the videos. I'm just a big fan of your Teaching Style :)
These videos are incredibly good!!!!
My native language is Spanish, but even so I managed to learn a lot from this lecturer.
You're incredibly good!!!
If you added some subtitles, specially for the parts when you don't speak in English these videos would be better than a DB course at a top university, as the one Im studying.
Keep it up!!
Thanks!!!
Thank you so much for your videos sir. You are doing such a great job. Your language and explanations are crystal clear.
One of the easiest explanations of normal forms.... thanks a lot
You are >> our college professor thank you sir 😊
Most welcome dear! Keep supporting & stay connected for more amazing videos & upcoming contents 👍😊
Apka lecture boht acha hota hy urdu mn bnayn normalization plzzzz
You are simply awesome... we desperately need more energetic teachers like you.. You are the best teacher sir..
Hi Arpan, Thank you so much for your encouraging words.We upload more topics every week, Please subscribe this channel for best GATE tutorials. :)
Sir Networking ka bhi video upload karo.. _/\_
Big salute to u...... Great teaching experience....👌👌👌👌
The way you explain the concepts is very good. Your videos are really helpful . You made it so easy to understand the concepts of DBMS. Thank you so much Sir..
bhaiiii tu bhagwan nikla bhai
crystal clear concept clearing
keep up the good work sir!!!
Wow, impressive. Hats off , the way you made it so easy.
your lectures are outstanding!!! so easy to understand!!! Thank you is just not enough for you!!!
Hi Buddy, Thank you so much for your encouraging words.
we truly appreciate your kind words for our efforts :)
Sir i appreciate the way you are explaining each and every topic!! Simply "Sir main to aap ka fan ban gaya!"
Babar Bahadur from Pakistan
Sir your videos helps me a lot to understand the normalization more clearly.....thank You very much Sir...You are best Sir
6:50 chill Sir😋! All jokes aside, he is the best teacher out there!
I must say the way in which sir delivers the lecture is amazing.
Thank you so much dear Abhishek, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
yes these guys are way better than college teachers.
Thank you ❤ keep learning & supporting, stay connected for more amazing videos & upcoming contents👍😊
your effort can be seen directly in ur videos.. tyvm for ur effort sir.. u hve made these concepts very very easy with ur explanation
always follow your tutorials , because you make the concept simpler.. nice examples
better than my prof. in NIT awesome work. keep it up
7:13 "there is no garanty tha She(C) will survive here she(C) will stand here everytime"
Never been through such a nice and intuitive explanation of all normal forms. Thank you.
Hi Omkar, we truly appreciate your kind words for our efforts.
Thank you so much for your support. :)
great lecture...solved my more than half of my problem about normalization..thnku very much
Bhaii bacha liya. Brilliant teacher 👏
Amazing video sir my college professors are nothing compares to you even I can teach better than them after watching your videos
God bless u sir thanks again
sir.. as you said AB is key but if AB is primary key ,individually A cant be null but you said A can be null at 6:06 ...sir can any clarify my doubt
thank you very much sir , we are learning concept even a day before the exams all because of your playlist
love from AP
😍
You're most welcome dear, glad to hear this😍
Keep learning & supporting! Stay connected for more amazing contents & videos 👍
Thank you very much you really saved me today , it's my exam day and this can get really confusing but you sorted it out like a god thank you sir
Best explanation. You are great. We would like to learn from you more. You are doing great work. Great respect for you Sir!
Hi Rushi, thank you so much for showing gratitude,it means a lot to us :)
we upload more topics every week:)
Your examples are so amazing ..and will help us for better understanding
Awesome video on Normalization ..... Great Great JOB !!!!
you awesome sir!! C neta ban raha hai ,nice example
Hello Anshu, we truly appreciate your kind words for our efforts. People easily understand the concept with help of example. :)
Yar sanchit i am also a teacher but your explanation is so good not so good........... its very very good i am a big fan of you wow kitna easy bana diya yar tumne normalization .... thanks boss [Now you are my teacher from today]
It's really a fantastic teaching, hats off to you sir...
Thank you so much sir, not even the college teachers could explain as great as you did. Tysm
Very informative, easy to understand, concepts are clear.
my university teacher took 2 weeks to complete upto 3NF but was not able to do the amazing work you did sir,in such short videos..... thanks sir really impressive
your explanation is just too good..take care of your health also sir
sir u make things very easy and understandable. thanks sir. yoy helps us a lot. keep going...
sir best explanation ever ........... you must have tried for teaching in various IIT's and NIT's it will be a great fun to have such a teacher there
great sir you teach in very easy manner
Nice sir ............. khas hamare college ke teacher ase sanha pata...
Your videos are amazing and ideal examples are sighted. Thankyou so much for helping.
5:45 "Duster got Spiderman's genes"😮
Sir, how the duster sticked on that blackboard.. 6:05
Magnet Bro..
@@AnilKumar-bh4vt
Thank you
Sir apko Neta bana dena chahiye! :D You are amazing.
you are a great teacher.You have cleared all my doubts.Thank u
10:28 phat hi gyi, well your videos are really so awesome I was trying to understand the concept of normalization for 2hours but after watching your videos I am clear now
bahot bariya sir ....plz apne videos banate rahe
Thanks sir your videos are too helpful but the only problem i face in it was your speed of moving ahead is a bit more. Other than that the concepts you teach are just cleared in a single go.
OMG... I HAVE THOUGHT P AND NP PROBLEMS... GRT SIR
clear cut concept in simple terms......thank you sir.
And the duster attached to board dragged my attention!... Very informative and perfect explanation though!
Your are awesome. I never understood this clearly before this. Thanks for sharing .
Because of these videos I scored 9 point in DBMS in my university exams(MAKAUT, formerly WBUT). I used to struggle so badly with these concepts previously, but a friend suggested this channel. Thank you Sanchit Sir, may your mission and vision be successful. :-)
Ty sir, the whole normalisation series was really helpful. Ty again!
Teaching at its very best..
what if there is a element which does not have any incoming or outgoing edges
so here for 3rd normal form it is making non prime attribute prime so there wont be occurance of null value and we can directly find the value of the other non prime attribute through candidate keys. so if we make non prime a prime attribute ,. Then it also becomes the part of candidate key!! . But while identifying candidate key , we see there is no incoming path on they keys ,those we set as candidate keys. So in conclusion can we set it as a C as prime attribute .? hope u get my doubt....
No, see we are making C a ck in a decomposed table, not in the main one
Sir IIT professor bhi asa clear concept nhi de pate...God bless you at on higher rank..
How can c become a candidate key in second relation after decomposition??🤔🤔
If a ---> b then its partial dependency? ?
Hats off sir...ur lectures helped me a lot.....
you way of teaching is too good sir..
Hi Motilal,Thank you so much for your encouraging words.We upload more topics every week, Please subscribe this channel for best GATE tutorials.
superb lecture.....thanx a lot sanchit sir....
Hi Pushpendra,Thank you so much, would like to hear more from you. We upload more topics every week, Please subscribe this channel for best GATE tutorials.
diz izz the bst way of teachng ...tqqqq vry much sir.....u r more helpfull fr us.
Hi Shirish,Thank you so much for your encouraging words. :)
Best video lectures for DBMS! Keep up the great work ♥️
The best lecture on normal forms... Thank you
Really an effective explanation,,, thanks allot
What happens If partial candidate key functionally depends on non prime attribute ?? Please help
sir i want to know if c is null then what will happen after the decompsition becauese it is now candidate key and key is never be null.
Now, i have clear my all the topics in which i have doubt....so , thank u sir 😊
Everything covered very nicely...love the channel!
Hello I have small doubt AB are candidate keys so they cant be null how can c become null if ab becomes primary key.
I can't thank you enough sir, I didn't attend dbms class in college and this video is making up for it.
you are a god!....I didn't have words to express thanks.....
Brilliant explanation Sir, but please do explain 4NF, 5NF
Wait a sec , At 5:43 -> duster got attached to the board . haha :) Nice explanation by the way with netas :P LOL
its a magnetic board souvik pal ji...
Oh!!! great . /(o_o)/