I have no words to explain how good you are at teaching.. i dont know why we are paying to our university.. i guess just for the stress they are giving us for the heavy work load .. work seems easier when taught by the teachers like you sir.. hats off to you….
I'm a malayali. Usually I watch youtube tutorials in English. Yours is the first Hindi tutorial I watch. Simply superbbbb.. well understood.. Thank you 😊
Same with me , I'm from Andhra Pardesh, for the first time I'm watching hindi tutorial..bcz I love the way he makes the concepts very clear and even his language is understandable.
i just want to say , thanks to you for teaching me "coa" , "os" , and now "dbms" ... your real life examples related to topic . makes feel the topic ..
Sir aapka way of teaching or 🙂 explaining way bhut accha hai 😂 mujh aapne college vallo pr shrm aa rhi hai dhung se kyu nhi study krvate ..... Aapki videos se sub clear ho jatta hai😊 thank you so much sir
Accidently I found your one lecture about SDLC and then I became your student ..thank you so much sir ..u always clear my all doubts.. Specially normalisation😊
Words can't explain how thankful I am to you for helping me out at a time when I desperately need help, when not getting help simply means failing the exam. Thank You very much Sir. God bless you.
you are such a great teacher that even our college's well qualified lecturers recommend your channel😇..... although , we were already active on your channel before their recommendation😜❣................you are a fabulous teacher💯 ........you have made the toughest subject very easy with your explanation hats off🙌
Jab ham student the tab bhi apki videos se help lete ha ab ham teacher ha ab bhi apka method follow krte hue teach kr rhe ha thank you soooo much sir g ❤❤❤
00:00 Normalization is a technique to remove or reduce redundancy in a table. 01:36 Setting the primary key prevents row-level duplicates but not column-level duplicates. 03:16 Duplicates in data can cause three types of anomalies: insertion, deletion, and updation. 05:07 Insertion and deletion anomalies in database 06:36 Deleting a row from the table may cause loss of related information 08:11 There are three fundamental operations in a database: insertion, deletion, and updation. 09:50 Salary updation query creates redundancy 11:28 Combine multiple tables into one to simplify processes Crafted by Merlin AI.
Helo sir I am from Pakistan and l always watch your vedio your teaching methods and your overload knowledge is so furit full for all of us we all appreciate your knowledge and always pary for your more success ❤❤❤❤❤❤❤❤❤
Update Anomaly:- For instance, if we try updating a data element with its copies scattered all over various places, then only a few instances will be updated properly. On the other hand, the rest others will be left with their old values.
I regularly learn concepts from his videos. As usual, I landed here to know Normalisation.. surprisingly, when I checked his channel's oldest video, this was the video.. wow You are a great teacher ❤
i watch your first video lecture in first sem and now i am in six semester regularly i listen your lectures.....you are best teacher always ...Allah bless you ...from pakistan
Ap bhut tehzeeb sy bat krty Hain ,mjy lga k mein apny teacher sy class ly raha hn wo b Urdu tehzeeb sy booty hlin. Hindi Jo b bolta hai wo tez tez bolta hai but ye Hindi to Urdu jaisy lagi means apni language.🇵🇰🇵🇰🇵🇰👏👏👏
Sir aap bahut accha padhate ho .ur are my favourite teacher.because of u i get good marks in my os subject without coaching and attending college classes.thanku so much sir. Ur great bt iss video me aap thode sad lg rahe the tabiyat kharab hoga sayad apka.once again thanks
Hiii Dhananjay...bahut bahut dhanyawad.. I wish you will best in your life..GOD bless you Hahahaah..you are absolutely right. I was suffering from cold and fever that day..
Sir, great work. I have been trying to understand it for many days and now i understood it by watching your video on it. Thanks for explaining it like that and making it very simple🤗
12:37. Sir agr ham Faculty F1 ki salary change krde sath me where Sid='somevalue' de tb to ek hi tuple me change hogi baki F1 faculty se kuch problem hi ni 🤔🤔plzzz reply sir
bhaiya mera amcat ka exam hain usme cs module dene wala hu....aaap itni ache se samjhate ho...thank you...humare cse department main dbms ko toh joke banake padha ke rakha tha 😂😂😂
Your teaching method is really nice. I am referring your videos for SEBI exam preparation. Almost all are very helpful to clear basic concepts. Thanks for explaining in such a way. Will you please make videos for Tuple Calculus, indexing ( B and B+ trees ), transaction and concurrency control?
I have no words to explain how good you are at teaching.. i dont know why we are paying to our university.. i guess just for the stress they are giving us for the heavy work load .. work seems easier when taught by the teachers like you sir.. hats off to you….
I'm a malayali. Usually I watch youtube tutorials in English. Yours is the first Hindi tutorial I watch. Simply superbbbb.. well understood.. Thank you 😊
Where did you get English explanation
You are a best teachr of the world 👍
Same with me , I'm from Andhra Pardesh, for the first time I'm watching hindi tutorial..bcz I love the way he makes the concepts very clear and even his language is understandable.
Me too a malayali really love this Teacher...
th-cam.com/video/p0gL1pAhGZE/w-d-xo.html🙏🏻
i just want to say , thanks to you for teaching me "coa" , "os" , and now "dbms" ... your real life examples related to topic .
makes feel the topic ..
finally a decent teacher who teach in both hindi n elglish... very well sir
u go tho inglis koching
@@p.raghavendrarao2213 yas Biro
Yes bro
Decent nhi bestt ✨❤️
teaches both in hindi and english
One of the best computer teacher i have ever found ❤
Sir in amritpal example sid=4 isnt it you wrote 2 at 9:24
Ikrrrr 🤩🤩
Hands Down!
Bhai mere classmates gate smashers ke he Bharose rhatay hai
@@FrontLineEngineer mere bhi brother 🤣
You actually prove the word TEACHING to it's best.
Your way of teaching is really great! 🙌
I have my exam in 1hr, and aapne saare important concepts itni jaldi samjha diye! Tysm! Best channel for last minute revisions!👍🏻
1 hr😂😂😂😂😂😂
@Saumya itna b juth nai bolna tha. Juth ki bhi limit hoti h, tumne sab par kardi...🤣🤣
Seriously yr🤣🤣
@@aashishsah2110 bhai vansh ko padha de hamein smjh nahi aaraha
@@VapTex Sir bhi soch rhe hoge etna bhi kya jldi thi Thank you so much ko tysm likh kr chali gyi😂
Zindegi mein pehli baar samajh aya hum normalize kyu karte hain. Salute boss. Keep up the good work.
Sir aapka way of teaching or 🙂 explaining way bhut accha hai 😂 mujh aapne college vallo pr shrm aa rhi hai dhung se kyu nhi study krvate ..... Aapki videos se sub clear ho jatta hai😊 thank you so much sir
BEST EXPLANATION EVER !..... I have watched over 8 to 10 videos of normalization....but this vid was the one where I finally understood. THANKYOU
You are God of students. U deserve millions,billions of subscriber. ❤️❤️
Accidently I found your one lecture about SDLC and then I became your student ..thank you so much sir ..u always clear my all doubts.. Specially normalisation😊
Words can't explain how thankful I am to you for helping me out at a time when I desperately need help, when not getting help simply means failing the exam. Thank You very much Sir. God bless you.
❤👍 I don't have words to say 😊about this c.teacher seriously 😊sirf 2 min dekha mne or like or subscribe kr diya bina soche 😮 asa m kabhi ni krti😅 omg
you are such a great teacher that even our college's well qualified lecturers recommend your channel😇..... although , we were already active on your channel before their recommendation😜❣................you are a fabulous teacher💯 ........you have made the toughest subject very easy with your explanation hats off🙌
Thank you so much for your effort.
Thank god, finally I found a good teacher for dbms
There is a one redundancy in your videos - Your best way of teaching.👍👍👌
r3 t r d
Great video just one mistake at 9:16 it should be UPDATE STUDENT SET Sname= 'Amrit Pal' where Sid=4; instead of sid = 2.
I just came to see that how would have comment this one mistake 😂
yes true
we deleted the first 2 rows in the deletion anomaly, hence only 2 rows are left, thus the sid = 2
best teacher i have seen on youtube for computer sci. Thanku so much for ur very beautiful knowledge
Can't thank you enough!!
Lots of respect from Pakistan.
❤️
The dislikes are from those University teachers who are jealous of you 😂
Yes🤟😅😆🤭
True 🤣 Since he is an amazing professor.
noooo...i think they would be his relatives😝
th-cam.com/play/PLyeuwglfy-CsNXT3xDkvKjlG-p9EyF5NC.html
@@mahammalik1881 th-cam.com/play/PLyeuwglfy-CsNXT3xDkvKjlG-p9EyF5NC.html
Sir I've no Words to express my Gratitude to you ✨
best teacher ho tusi sir...
Yr help plz
This is the level of teaching ♥
th-cam.com/play/PLyeuwglfy-CsNXT3xDkvKjlG-p9EyF5NC.html
Such a simple explanation sir 🎉.....it's easy to remember....😊
Mind blowing explain to the NF
Lawrance Bishnoi in parellel universe... although lecture was too good, easy to understand. Thanks
love you Sir. What an amazing way of teaching. Mazaa aa jaata hai.
@5:37 you cannot insert the dummy value because it will create domain constraints .
Can you plz elaborate it?
Perhaps you meant to say "violate" domain constraints instead? That need not be so, you can insert a value like -1, which is still an integer.
Ur indirectly helping us for our exams very greatly explained...👌👍👍👍
Ur r a best teacher.....👌👌👍thanq
Jab ham student the tab bhi apki videos se help lete ha ab ham teacher ha ab bhi apka method follow krte hue teach kr rhe ha thank you soooo much sir g ❤❤❤
You are the bst teacher fr evr sir....❣️
00:00 Normalization is a technique to remove or reduce redundancy in a table.
01:36 Setting the primary key prevents row-level duplicates but not column-level duplicates.
03:16 Duplicates in data can cause three types of anomalies: insertion, deletion, and updation.
05:07 Insertion and deletion anomalies in database
06:36 Deleting a row from the table may cause loss of related information
08:11 There are three fundamental operations in a database: insertion, deletion, and updation.
09:50 Salary updation query creates redundancy
11:28 Combine multiple tables into one to simplify processes
Crafted by Merlin AI.
Apke video dekhne se pehle hi like ka button daba deta hu ....
Easy way me concept samja dete ho aap sirG😎😎😉🤗🤗🤗🤗
I am from Punjab and I literally watch ur videos and ur teaching methods are superb ❤️
CU ?
very nice explanation all doubts get cleared .. great doing brother :-
)
Simply superb explanation..... 👌👌👌
9:13 sec changed from amrit to amritpal , this guy predicted punjab's future 5 years back :)😂😂
Modi ne amritpal ka data delete kar diya🤣
Amritpal is a MP now.....
Sir ji aapne hamari dubti kashti ko bacha lia..........bohot bohot shukria!
You give very satisfactory explanation in every video.... Thank you for your kind effort 😊🤗
Helo sir I am from Pakistan and l always watch your vedio your teaching methods and your overload knowledge is so furit full for all of us we all appreciate your knowledge and always pary for your more success ❤❤❤❤❤❤❤❤❤
Update Anomaly:-
For instance, if we try updating a data element with its copies scattered all over various places, then only a few instances will be updated properly. On the other hand, the rest others will be left with their old values.
thank you bro
Most useful channel for CS, IT students
Very well explained 👍😊😊
Thank you so much sir
After 5 years i watch this video and i found same person always energetic 🙇♂️🙏
Sir Ap ki tariff k Lai mere pass word nh h...Mai jitna bolu utna kam h...👏👏🙏
I regularly learn concepts from his videos. As usual, I landed here to know Normalisation.. surprisingly, when I checked his channel's oldest video, this was the video.. wow
You are a great teacher ❤
gurujee shandhar jabardast zindabad
Sir!! Thankiuu so much
Itni schiii explanation sir
Thank you so much 😊❤️
THANK YOU SIR!! Really Great Teaching,
i watch your first video lecture in first sem and now i am in six semester regularly i listen your lectures.....you are best teacher always ...Allah bless you ...from pakistan
very nice explanation..........will u plz upload videos on computer orgnization....
After 5 years of my master's..... Finally understand Normalisation..........East or west varun sir is the best
U mean 5yrs of Bachelor's?
You made the concept easy ..good going
Ap bhut tehzeeb sy bat krty Hain ,mjy lga k mein apny teacher sy class ly raha hn wo b Urdu tehzeeb sy booty hlin. Hindi Jo b bolta hai wo tez tez bolta hai but ye Hindi to Urdu jaisy lagi means apni language.🇵🇰🇵🇰🇵🇰👏👏👏
U r the only one, u r no 1 sir ji ..... Love yr teaching ♥️😇
my goodness what a video. spent 10 minutes rewatching the anomalies coz i had so many doubts. everything ended at the end.
tomorrow is my DBMS exam and your video really help me understand the topics of of DBMS. Thank you so much for creating this series ♥♥♥♥.
@Abdullah Kamal good luck brother do your best 👍✨💯
Watched this video and it helped solving updation anomalies in my final paper
iss video may energy kaam lag rahi thi sir ji but great explaination as usual . Hats off to your effort.
Sir aap bahut accha padhate ho .ur are my favourite teacher.because of u i get good marks in my os subject without coaching and attending college classes.thanku so much sir. Ur great bt iss video me aap thode sad lg rahe the tabiyat kharab hoga sayad apka.once again thanks
Hiii Dhananjay...bahut bahut dhanyawad.. I wish you will best in your life..GOD bless you
Hahahaah..you are absolutely right. I was suffering from cold and fever that day..
Love you sir. Good method of teaching
Well Explained !!!
Very Nice Explained Sir.Really Hats Off😊 Your Way Of Teaching👍
Kaam aisa karo ke 6 saal bad v kisi ke jaan bach jaye
Bhai kya baat boli hai waa❤❤
Very helpful video sir thank you
Today is my dbms exm from 10:30
And now I'm trying to cover the whole syllabus 🥲
nikla kya bhai??
Same. My exam is at 11:00 am. 1 hour and 20 minutes left.
I have finally resumed revising, and all my notes are now complete.
Sir u are the best teacher ,, thanku so much for giving your time to teach us and putting your efforts
You are the best teacher..... 👌👌
Wow, thank you so much :)
Keep up the good work!
God level teaching. i love the way of teaching and it is really helping me in my studies.
Sir, great work. I have been trying to understand it for many days and now i understood it by watching your video on it. Thanks for explaining it like that and making it very simple🤗
Aur yahan se ek legend ka janm hua...........
Love you sir ji.
💙💜🔥💚♥️
12:37. Sir agr ham
Faculty F1 ki salary change krde sath me where Sid='somevalue' de tb to ek hi tuple me change hogi baki F1 faculty se kuch problem hi ni 🤔🤔plzzz reply sir
haan toh kuch sense nhi banega na fir, f1 faculty ki salary sirf sid =1 ke liye change karna koi sense nhi banata
kamaal ka samjha rhe ho aap, aesi lage raho
sir, thank you so much for nice explanation
Hyyyyyy Priya are you computer science engineer student????
Sir kamal kr diya ap ny... ❤❤
Ap bhot achy sy har point ko clear krty hain.. 👍👍
Ap k lectures bhot helpful hai...
Thanks. ❤❤
Sir please try to upload video on Disign Analysis Algorithm
Its really difficult to understand please..
Thankyou. The videos are very simple to understand.
bhaiya mera amcat ka exam hain usme cs module dene wala hu....aaap itni ache se samjhate ho...thank you...humare cse department main dbms ko toh joke banake padha ke rakha tha 😂😂😂
All the very best..DBMS is imp for Amcat exam.. specially data model, relational algebra,SQL, indexing
sir aap bohot ache se padhate ho ache se clear hota hai
You just made the concept crystal clear.. great job and thanks a lot
Very good explanation sir, yeh 3rd video dekha maine. Abb jake smajha.
plzz sir , make video on " Graphic Design " & " software Engineering" ...
Superb explanation, very simply explained👍
one of the greatest teacher i have ever seen (thank you sir)
Best lecture from college faculties
Thanks sir 🙏🏻
who is in 2024😂?
💀
Me
2025
Awsome lectures sir love from Lahore,Pakistan
I don't have words to thanking u for all ur video its all are greate and very easy to understand thnq so much sir.....😊😊
Sir I don't have words to describe how the best teaching experience you have ,great one sir ❤️❤️❤️
Tq so much sir for ur superb explanation it helps me alot 😊
ily
Thnku soo much sir for explaining in briefly🤗🙂
Your hard work for us is clearly visible sir 🥺🥺🥺
Thank you sir
Ur info is accurate and ur method is great sir
Your teaching method is really nice. I am referring your videos for SEBI exam preparation. Almost all are very helpful to clear basic concepts. Thanks for explaining in such a way. Will you please make videos for Tuple Calculus, indexing ( B and B+ trees ), transaction and concurrency control?
badhiya confidence built hota hai sir apke videos dekh ke
Tq sir for your videos which helped me in my preparation 🙂🙂🙂