Lec-74: ACID Properties of a Transaction | Database Management System

Поделиться
HTML-код
  • Опубликовано: 5 авг 2024
  • 👉Subscribe to our new channel: / @varunainashots
    0:00 - Introduction
    1:20 - Atomicity
    4:57 - Consistency
    10:11 - Isolation
    12:23 - Durability
    ► Database Management System(Complete Playlist):
    • DBMS (Database Managem...
    Other subject-wise playlist Links:
    --------------------------------------------------------------------------------------------------------------------------------------
    ►Design and Analysis of algorithms (DAA):
    • Design and Analysis of...
    ►Computer Architecture (Complete Playlist):
    • Computer Organization ...
    ► Theory of Computation
    • TOC(Theory of Computat...
    ►Artificial Intelligence:
    • Artificial Intelligenc...
    ►Computer Networks (Complete Playlist):
    • Computer Networks (Com...
    ►Operating System:
    • Operating System (Comp...
    ►Structured Query Language (SQL):
    • Structured Query Langu...
    ►Discrete Mathematics:
    • Discrete Mathematics
    ►Compiler Design:
    • Compiler Design (Compl...
    ►Number System:
    • Number system
    ►Cloud Computing & BIG Data:
    • Cloud Computing & BIG ...
    ►Software Engineering:
    • Software Engineering
    ►Data Structure:
    • Data Structure
    ►Graph Theory:
    • Graph Theory
    ►Programming in C:
    • C Programming
    ►Digital Logic:
    • Digital Logic (Complet...
    ---------------------------------------------------------------------------------------------------------------------------------------
    Our social media Links:
    ► Subscribe to us on RUclips: / gatesmashers
    ►Subscribe to our new channel: / @varunainashots
    ► Like our page on Facebook: / gatesmashers
    ► Follow us on Instagram: / gate.smashers
    ► Follow us on Instagram: / varunainashots
    ► Follow us on Telegram: t.me/gatesmashersofficial
    ► Follow us on Threads: www.threads.net/@gate.smashers
    --------------------------------------------------------------------------------------------------------------------------------------
    ►For Any Query, Suggestion or notes contribution:
    Email us at: gatesmashers2018@gmail.com

Комментарии • 626

  • @varungupta2727
    @varungupta2727 4 года назад +564

    Truly a nation builder by providing free and quality education.. 😃 Ty for all.

  • @RanjeetSingh-xt5sh
    @RanjeetSingh-xt5sh 5 лет назад +216

    Finally fell in love with DBMS..
    The only reason is your way of explanation..
    Thnks a lot Sir..

  • @ItsJyoti
    @ItsJyoti 4 года назад +99

    When you said Machine mei se awaz aayi....गढ़ गढ़ गढ़ 🤣🤣🤣🤣🤣
    Best explanation As Always 🙏

  • @riyamajumdar3184
    @riyamajumdar3184 Год назад +71

    OUR WHOLE COLLEGE STUDENTS ARE WATCHING YOUR VIDEO BEFORE DBMS SEM EXAM 🤣😂

  • @052_gopaltiwari2
    @052_gopaltiwari2 Год назад +258

    Mje ki baat btau: sir aapki hi wjh se exam pass hote h, college wale to frji lakho rupaye lete h 😀

  • @ozorstudio7325
    @ozorstudio7325 5 лет назад +31

    Wow!! Such a great mentor of this modern era.

  • @oshniklife9661
    @oshniklife9661 5 лет назад +192

    Sir ur explanation of each and every topic is different from any other Faculty of our university..
    ACID property generally people explain only topic.. but u taught with real example.. thats make u different from others.. May alla bless u.. doing a great job...

    • @crazykhan8851
      @crazykhan8851 5 лет назад +6

      Konsi university hai aap logo ki or aap kha se belong krte hai

    • @it_sujeetyadav8489
      @it_sujeetyadav8489 2 года назад +2

      @@crazykhan8851 aktu

    • @crazykhan8851
      @crazykhan8851 2 года назад +3

      😅do saal bd rply diya h ab m is branch ko left kr chuki hu ....now i joined with basic education teaching dept

    • @crazykhan8851
      @crazykhan8851 2 года назад +2

      @smart sanvi😊

    • @it_sujeetyadav8489
      @it_sujeetyadav8489 2 года назад +3

      @@crazykhan8851 maine dhyan nahi diya 🤣🤣

  • @priyankadutta8798
    @priyankadutta8798 4 года назад +16

    Sir ,your way of teaching is very easy.Any students can understand this.The examples you are given ,are based on real life problems.It makes understanding dbms much more easier.Thank you sir.

  • @Mr.Unknown2137
    @Mr.Unknown2137 9 месяцев назад +27

    Legends are watching this video 5years later

  • @gautamhans1
    @gautamhans1 2 года назад +101

    Sir you used to teach in LPU, right? I was your student! Glad to see others appreciating your hard work as well :)

  • @IbrahimKhan-cu5hk
    @IbrahimKhan-cu5hk Год назад +10

    Sir. You are the deserving teacher of IT and CS. Thanks alot Sir. I want to see you as a professor in our virtual university of Pakistan

  • @riteshbisht94
    @riteshbisht94 7 месяцев назад +6

    Backbone of our nation 🗿⭐

  • @sriparnochowdhury3900
    @sriparnochowdhury3900 3 года назад +7

    I don't know how to thank u brother ... Ur presentation style is so unique and beautiful.. i wasn't that good at dbms.. i was worrying about my sem clearance .. i lost all the hopes ... Then one day i watched a video from this playlist...i got amazed...it was through and to the point...now i have gathered an interest for this subject... Trust me it's far better than any other paid courses on internet... Thank u.. happy teachers day❤️

  • @HamzaSinghera
    @HamzaSinghera 5 лет назад +16

    Sir you are just brilliant! I have learned many concepts from your lectures which unable to get from university .. much respect for you sir .. Stay blessed with more and keep it up … :)

  • @sangeetsingh8980
    @sangeetsingh8980 5 лет назад +41

    I followed most of you videos and never have exact words to show my gratitude to you sir. You are a GODSEND for all the students. The way you teach and explain concepts is marvelous. Nothing can better than this. I wish you get lots of success and achieve all your dreams..

  • @akshaygupta2863
    @akshaygupta2863 4 года назад +8

    Sir ji, aap gajab padhate ho. Great and Thanks.
    Concepts apne aap clear hone lagte ha.

  • @gigaheheboi
    @gigaheheboi 5 месяцев назад +4

    When I was in my College, I used to pass semester by watching Varun sir's Video. Now I got placed and working as a DBA, Still I find Varun Sir's Video Helpful!! Thank you sir for making us understand topics like these so easily!!

    • @Artist-Afrina
      @Artist-Afrina 2 месяца назад

      how to get the post of DBA please tell me

  • @ManojPandeyManub22
    @ManojPandeyManub22 3 года назад +17

    On "Consistency", the example given by you is already taken care by "Atomicity" itself. Consistency talks about the data "Integrity constraints" applied on the schema/table. So after a transaction completes it should also honor the constraints (if there are), like if a CHECK() constraints says balance should not go -ve or more than 2 Lacs, in this case the transaction should be rolled back. Otherwise if a transaction still happens, A will have -ve balance and SUM of both sides will still be equal !!!

    • @abhaybansal9904
      @abhaybansal9904 Год назад +4

      exactly.. consistency example was misleading. What if transaction doesnt involve any integer value. or what if we deposit money, so the sum of money should increase. it was a poor example imo

  • @pksharma9225
    @pksharma9225 2 года назад

    jabardast teaching. wo gad-gad-gad jab atm se paise nikalte hain. Actually your way of representation is natural which anyone grasp easily. Bhagwan aapko hamesha khush rakhein.

  • @vikramsutar1792
    @vikramsutar1792 3 года назад +19

    Best ever lecture... Every concept got 👌

  • @implementtech9683
    @implementtech9683 3 года назад +7

    The best teaching method I' ve ever seen love from Pakistan

  • @nabajitbora6314
    @nabajitbora6314 4 года назад +1

    Finally a great explainer found! Baki RUclipsrs ki video dekhta hu toh neend aa ja ti hai.. par ap alg typ ke ho . Great video and thanks

  • @btsforever0712
    @btsforever0712 2 года назад +2

    i truly feel relieved when i search for a topic and tht topic is said by you sir.....am thankful☺☺

  • @bhavanas9020
    @bhavanas9020 Год назад +2

    Such a best teaching ever👏.......I'm not getting bored even a min even though am continously watching all the videos

  • @lol_iris237
    @lol_iris237 2 года назад +1

    Sir you made learning DBMS a lot easier and aapke smjhane ka way bhi kaafi accha hai . ☺

  • @29priyanka29
    @29priyanka29 Месяц назад

    Great learning.....thanx sir... abhi tk ACID yaad ni hui kbhi .apne Jo best concept m simply btaya h ab yaad krne ki jrurt ni concept ki understanding ho gyi ache se 👌👍

  • @rakeshdas4035
    @rakeshdas4035 5 лет назад +6

    Dude you are a fantastic teacher never stop teaching.god bless you

  • @ajmalkhaniit
    @ajmalkhaniit 5 лет назад +4

    Very very nice explanation sir no one can teach dbms like you sir and one request you to all remaining videsos upload as soon as possible please

  • @abdulwaris5496
    @abdulwaris5496 5 месяцев назад

    I have been trying to learn these concepts for 2 days. I wasn't able to until I found your video.
    I like your teaching methodology please keep sharing like this video.. Thanks a lot

  • @shraddhalone8151
    @shraddhalone8151 2 года назад +2

    Awesome lecture👍 I enjoyed throughout the lecture with all your interesting examples!!!! Thank You Sir 👍👍

  • @yashusharma8891
    @yashusharma8891 5 лет назад +7

    Such a wonderful Video sir....👌 You Are Amazing..👌 Each and every topic of yours was fabulous...👌👌👌👌

  • @shahrukhshaikh7458
    @shahrukhshaikh7458 5 лет назад +5

    Sir thank u for such amazing lectures bcz in college it is impossible to understand but u r making it easy... Keep it up

  • @karamchoudhary5696
    @karamchoudhary5696 3 года назад +1

    Thank you for this channel, you have made DBMS so easy.

  • @aryarawal1145
    @aryarawal1145 4 года назад +1

    Diploma, degree, master degree krne ke baad aaj ACID properties Ka use smjh aya,👍👍thnkew so much sir😊

  • @snehasishmallik2820
    @snehasishmallik2820 3 года назад +4

    The best thing about this man is that he always gives real life example.

  • @shivampatel8850
    @shivampatel8850 2 года назад +4

    Sir your way of explanation is very good and effective because of examples you add in every concept please keep it up, god bless you and you will definitely do well in future

  • @umakantojha7013
    @umakantojha7013 Год назад

    Thank u so much sir for being there for us.After watching ur video when i started solving the question of gate and isro, I dont find any difficulty in eliminating the options ,I must say u r the best computer science faculty I have ever seen in my life.Ur lecture and video has increase my accuracy 200 time then before .Thanku sir😊.

  • @sameery7070
    @sameery7070 3 года назад

    70 thousands dekr database ki classes kei thi lekin concept yaha clear ho rha hai... thanku so much sir....4 din se lagatar apka video dekh rha hu, or har video me mera concept apne clear kiya hai... thanks again...

  • @chidiyyaa
    @chidiyyaa Год назад

    Whenever I search for a topic, I think that you have made a video on that topic and as soon as I get it, it seems that it will be clear now, there is no tension.🙇‍♀️

  • @gautamjangir221
    @gautamjangir221 Год назад +1

    The Best Explanation in the entire youtube...THANKS.

  • @zaidamin5005
    @zaidamin5005 2 года назад

    Awesome explanation sir, because this question asked to me in interview, that time i was not able to told them clearly but now i explained this with full explanation. once again thanks sir .

  • @wasidmasroor7985
    @wasidmasroor7985 3 года назад

    Sir the way you explain really hats off thanks to you for helping many students across the globe...Its help alot to us.ur way of understanding the topic is really incredible.Thankssssss

  • @saddam926
    @saddam926 5 лет назад +7

    What a explanation sir👌
    Keep making videos for other subjects too!

  • @mkchauhan7587
    @mkchauhan7587 5 лет назад +3

    Sir, your explanation is really great, dbms becomes easy to understand

  • @sratnamanjari244
    @sratnamanjari244 4 года назад

    Sir Crystal Clear Explanation......Clearly Understood....
    The Examples you Presented Sir...Superb .....Thank YOU Sir......

  • @vasumathivaishnavi2537
    @vasumathivaishnavi2537 5 лет назад +3

    Iam clearly understand ing all your expectations sir thank u so much

  • @talhaamir9023
    @talhaamir9023 3 года назад

    Good Teachers Play their role for a better Future !!
    Thanks a lot :)

  • @abhiamit22
    @abhiamit22 Год назад

    Brilliant explanation. It made more sense when you explained it with an example.Thank you for the video.cheers

  • @amishachoudhary42
    @amishachoudhary42 5 лет назад +4

    Sir...u are an angel to students like me.. 😇😊

  • @anishchar4282
    @anishchar4282 2 года назад +2

    Understanding ACID Property in a best way = Gate Smashers analysis
    Thanks a lot sir ❤❤

  • @nakibtheexplorer5383
    @nakibtheexplorer5383 4 года назад +2

    Best Explanation , Thank you so much and Love from Bangladesh.

  • @aietisreekar2425
    @aietisreekar2425 4 года назад +1

    Finally understood the topic because of u sir.
    Thank you.

  • @marinalepcha8997
    @marinalepcha8997 4 года назад

    such a awesome understanding topic which I can learn very easily ..I wanna say amazing ..thank you sir...

  • @usharawat3307
    @usharawat3307 2 года назад +1

    God bless to you .... amazing teacher and amazing teaching ....

  • @RaviSharma-wd3rd
    @RaviSharma-wd3rd 3 года назад +2

    In youtube I see that your explanation is very amazing and powerful 👍👍👍🙏

  • @vandnasharma6464
    @vandnasharma6464 5 лет назад +2

    So nicely you explained each and every concept ..thankyou sir

  • @aniketmalvi8602
    @aniketmalvi8602 2 года назад +3

    This is real revolution in education sector ❤

  • @anuragnair2112
    @anuragnair2112 2 года назад +3

    you are a legend .i have my end sem tommorow and i found your rdbms series thank you soo much

  • @kajalsainiiuuhjj8866
    @kajalsainiiuuhjj8866 2 года назад

    Very clear cut concepts sir. Thanku so much for giving this such a great knowledge

  • @shivamvishwakarma4454
    @shivamvishwakarma4454 2 года назад +3

    Best ever lecture.... Every concept understood

  • @praneshnanoskar6353
    @praneshnanoskar6353 4 года назад

    The way of your teaching is really excellent..thank you sir

  • @codecamp2111
    @codecamp2111 4 года назад +4

    your all video on DBMS are fabulous, sir please make some more videos on locking protocol and deadlock.

  • @rubul2071
    @rubul2071 4 года назад

    Sir, you are awesome in teaching. This topic is not in my syllabus but I am still watching this.

  • @tanvi3101
    @tanvi3101 Год назад

    Such an excellent lecture with real life example.

  • @brahminGirl_
    @brahminGirl_ 5 лет назад +2

    You are jst awesome... D way u explain everytime 👌

  • @travelnlearn
    @travelnlearn 2 года назад

    Amazing video sir, Learned a lot. Thank YOU SO MUCH

  • @atulthakur8319
    @atulthakur8319 5 лет назад +2

    u explained this superbly. YES u explained this

  • @ananyatalukder753
    @ananyatalukder753 4 года назад +2

    Thank you so much Sir for the amazing lectures.

  • @jatindersingh2241
    @jatindersingh2241 3 года назад +2

    best explanation about ACID properties ....good work bro ,Love from Melbourne

  • @mahisanap4178
    @mahisanap4178 Год назад

    Thank you sir🙏🙏.. ur real life examples are easy to understand

  • @user-fq9cc9ny7s
    @user-fq9cc9ny7s 3 года назад

    Speechless explanation sir....thanks a lot sir....u r videos really helpful for lot of students ....

  • @shivamprakashjha9166
    @shivamprakashjha9166 11 месяцев назад

    Sir u r god to me🙏🙏🙏mai kaha kaha nhi bhtka ye pdhne ke liye but finally aap mil gye.

  • @ranawaqas5325
    @ranawaqas5325 5 лет назад +1

    I love your method of explanation...

  • @nabeelusmani5937
    @nabeelusmani5937 3 года назад

    Thank u very much Varun sir, for making lecture intresting nd funny too thanks alot once again 🔥🔥🔥

  • @maazrehman6702
    @maazrehman6702 2 месяца назад

    Ye vedio dekh kr itna ache se smj aagaya ...

  • @ashsharma6433
    @ashsharma6433 5 лет назад

    Ur lectrs r rly vry helpful....i prepared topics frm ur lectrs...u mk it quite easy....thnks...

  • @krishanudutta2943
    @krishanudutta2943 3 года назад

    No can explain the concepts as well as you do
    Tons of thanks...

  • @2441139knakmg
    @2441139knakmg 5 лет назад +1

    Wow yaar! Nice job!

  • @vasusharmarealtor
    @vasusharmarealtor 3 года назад +1

    Best in explaining the concept. Doing a great job.

  • @natureisbest7632
    @natureisbest7632 5 лет назад

    sir u explained very nicely..i m electronics student but i can understand this topic easily after your lecture

  • @makwanaanjali1767
    @makwanaanjali1767 Год назад

    Your teaching style is very amazing and it's helped to understand very easly

  • @sayandas7323
    @sayandas7323 5 лет назад +4

    Explanation asum 10000/100😄😄

  • @srijitadas3189
    @srijitadas3189 Месяц назад +1

    Thanks sir, apki waja se sab hard topic easy ho geya...😭

  • @rajatsinhthackray6274
    @rajatsinhthackray6274 2 года назад

    one of the best explanation on youtube.................

  • @sratnamanjari244
    @sratnamanjari244 4 года назад +3

    Sir you have explained very well...🙏👌😘...Ab samjh aya ye topic... Itne salo mei😀.

  • @vikas_kaushal8276
    @vikas_kaushal8276 Год назад +1

    Sir, you explain in a very good way , very well understood.

  • @harishreeln4706
    @harishreeln4706 Год назад

    once the vedio has been watched that will be in mind forever tqu sir........................

  • @ramandeepsuthar6693
    @ramandeepsuthar6693 4 года назад

    your explaination is very good , i am a non computer student and i got this topic clearly thanks a lot.....

  • @bhaveshmali6266
    @bhaveshmali6266 Год назад

    Very good teaching technique
    All the concepts are clears that you described
    Great sir jii
    Thanks a lot
    Keep going on👏

  • @emanch436
    @emanch436 8 месяцев назад

    Sir am your very biggest fan from Pakistan...
    Ap ky lectures le kr e me BSIT ko par kr ri ...
    Tysm sir 🎉❤

  • @GagandeepSingh-qq5lm
    @GagandeepSingh-qq5lm 2 года назад

    Really Sir You are the best teacher in youtube

  • @Mayank_singh29
    @Mayank_singh29 3 года назад +1

    Thanks sir... Your lectures are very helpful in my university exams... Respect from Agra the city of taj

  • @user-mq7bm5fn9y
    @user-mq7bm5fn9y 4 месяца назад

    love you sir understand in easy way of each step

  • @happycoding5163
    @happycoding5163 3 года назад

    understood each and every point clearly...thankyou very much

  • @jigneshrrawal4069
    @jigneshrrawal4069 3 года назад

    Sir itna mast samjate ho ki me kya batao . Excellent lecture 👌 👏 👍 .

  • @ghanshyam014
    @ghanshyam014 3 года назад

    Well explained and demonstrated bro...
    It's really helpful ☺️
    Smart with magnificent brain 😉

  • @rehamalbulushi520
    @rehamalbulushi520 2 года назад

    Matlab kamal hei sir... such mein... mujhe iss concept ka asli definition abhi bata chala ... Thank you very much for a crystal-clear explination

    • @Acadetime
      @Acadetime 2 года назад

      ruclips.net/channel/UC5UCDqBotPtxQgfum4iGM2A

  • @polasaibhargavgupta8301
    @polasaibhargavgupta8301 3 года назад

    Awesome teaching also love the way u teach❤️

  • @DiptarunChatterjee
    @DiptarunChatterjee 2 года назад

    Checked this video.. Immediately subscribed.

  • @Ashitha08
    @Ashitha08 6 месяцев назад

    Super class👍Thank you sir... 🙏