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

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 ก.ค. 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 TH-cam: / 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

ความคิดเห็น • 624

  • @varungupta2727
    @varungupta2727 4 ปีที่แล้ว +563

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

  • @RanjeetSingh-xt5sh
    @RanjeetSingh-xt5sh 5 ปีที่แล้ว +214

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

  • @ItsJyoti
    @ItsJyoti 4 ปีที่แล้ว +98

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

    • @Balu-vlogs466
      @Balu-vlogs466 3 ปีที่แล้ว +1

      Excellent job sir ji 🙏

  • @ozorstudio7325
    @ozorstudio7325 5 ปีที่แล้ว +30

    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.

  • @052_gopaltiwari2
    @052_gopaltiwari2 ปีที่แล้ว +255

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

    • @kumargupta6070
      @kumargupta6070 7 หลายเดือนก่อน +10

      Bhai bat tu bilkul sahi bol raha h

    • @vidhanshuborade5977
      @vidhanshuborade5977 6 หลายเดือนก่อน +4

      16 ane sach hai

    • @maastatus7773
      @maastatus7773 3 หลายเดือนก่อน +1

      Oooo hme to pta nhi tja

    • @maastatus7773
      @maastatus7773 3 หลายเดือนก่อน

      Ooooo

    • @msrazee7676
      @msrazee7676 2 หลายเดือนก่อน +1

      Sch m yarrr😂

  • @riyamajumdar3184
    @riyamajumdar3184 ปีที่แล้ว +68

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

  • @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❤️

  • @riteshbisht94
    @riteshbisht94 6 หลายเดือนก่อน +6

    Backbone of our nation 🗿⭐

  • @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 :)

    • @shailesh_rajpurohit
      @shailesh_rajpurohit ปีที่แล้ว +2

      konsa subject padhate the sir?

    • @manishpathak6936
      @manishpathak6936 11 หลายเดือนก่อน +12

      @@shailesh_rajpurohitHindi

    • @apnipathshala7866
      @apnipathshala7866 10 หลายเดือนก่อน

      ​@@manishpathak6936😂🤣🤣😂😂 sahi pakde hai😂

  • @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

  • @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 … :)

  • @akshaygupta2863
    @akshaygupta2863 4 ปีที่แล้ว +8

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

  • @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..

  • @gigaheheboi
    @gigaheheboi 4 หลายเดือนก่อน +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

  • @vikramsutar1792
    @vikramsutar1792 3 ปีที่แล้ว +19

    Best ever lecture... Every concept got 👌

  • @nabajitbora6314
    @nabajitbora6314 4 ปีที่แล้ว +1

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

  • @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.

  • @implementtech9683
    @implementtech9683 3 ปีที่แล้ว +7

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

  • @yashusharma8891
    @yashusharma8891 5 ปีที่แล้ว +7

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

  • @Mr.Unknown2137
    @Mr.Unknown2137 8 หลายเดือนก่อน +25

    Legends are watching this video 5years later

    • @karanbelwal
      @karanbelwal หลายเดือนก่อน +2

      Chup hoja legend padhne de

    • @akashkumardeepraj6661
      @akashkumardeepraj6661 28 วันที่ผ่านมา

      Tu legends nahi hai tu late ho gya

  • @bhavanas9020
    @bhavanas9020 ปีที่แล้ว +2

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

  • @rakeshdas4035
    @rakeshdas4035 5 ปีที่แล้ว +6

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

  • @btsforever0712
    @btsforever0712 2 ปีที่แล้ว +2

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

  • @29priyanka29
    @29priyanka29 24 วันที่ผ่านมา

    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 👌👍

  • @saddam926
    @saddam926 5 ปีที่แล้ว +7

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

  • @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

  • @gautamjangir221
    @gautamjangir221 ปีที่แล้ว +1

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

  • @lol_iris237
    @lol_iris237 2 ปีที่แล้ว +1

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

  • @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

  • @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

  • @amishachoudhary42
    @amishachoudhary42 5 ปีที่แล้ว +4

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

  • @karamchoudhary5696
    @karamchoudhary5696 3 ปีที่แล้ว +1

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

  • @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

  • @snehasishmallik2820
    @snehasishmallik2820 3 ปีที่แล้ว +4

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

  • @shraddhalone8151
    @shraddhalone8151 2 ปีที่แล้ว +2

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

  • @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......

  • @shivamvishwakarma4454
    @shivamvishwakarma4454 2 ปีที่แล้ว +3

    Best ever lecture.... Every concept understood

  • @talhaamir9023
    @talhaamir9023 3 ปีที่แล้ว

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

  • @aryarawal1145
    @aryarawal1145 4 ปีที่แล้ว +1

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

  • @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.🙇‍♀️

  • @vasumathivaishnavi2537
    @vasumathivaishnavi2537 5 ปีที่แล้ว +3

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

  • @nakibtheexplorer5383
    @nakibtheexplorer5383 4 ปีที่แล้ว +2

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

  • @tanvi3101
    @tanvi3101 ปีที่แล้ว

    Such an excellent lecture with real life example.

  • @aietisreekar2425
    @aietisreekar2425 4 ปีที่แล้ว +1

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

  • @atulthakur8319
    @atulthakur8319 5 ปีที่แล้ว +2

    u explained this superbly. YES u explained this

  • @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

  • @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...

  • @vandnasharma6464
    @vandnasharma6464 5 ปีที่แล้ว +2

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

  • @anuragnair2112
    @anuragnair2112 2 ปีที่แล้ว +3

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

  • @anishchar4282
    @anishchar4282 2 ปีที่แล้ว +2

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

  • @brahminGirl_
    @brahminGirl_ 5 ปีที่แล้ว +2

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

  • @jatindersingh2241
    @jatindersingh2241 3 ปีที่แล้ว +2

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

  • @usharawat3307
    @usharawat3307 2 ปีที่แล้ว +1

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

  • @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 .

  • @sratnamanjari244
    @sratnamanjari244 4 ปีที่แล้ว +3

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

  • @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😊.

  • @abhiamit22
    @abhiamit22 ปีที่แล้ว

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

  • @marinalepcha8997
    @marinalepcha8997 4 ปีที่แล้ว

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

  • @vasusharmarealtor
    @vasusharmarealtor 3 ปีที่แล้ว +1

    Best in explaining the concept. Doing a great job.

  • @RaviSharma-wd3rd
    @RaviSharma-wd3rd 3 ปีที่แล้ว +2

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

  • @up_kissan_farming
    @up_kissan_farming 2 หลายเดือนก่อน +8

    Today you look like Lawrence bishnoi😂

  • @ranawaqas5325
    @ranawaqas5325 5 ปีที่แล้ว +1

    I love your method of explanation...

  • @aniketmalvi8602
    @aniketmalvi8602 2 ปีที่แล้ว +3

    This is real revolution in education sector ❤

  • @user-fq9cc9ny7s
    @user-fq9cc9ny7s 3 ปีที่แล้ว

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

  • @ananyatalukder753
    @ananyatalukder753 4 ปีที่แล้ว +2

    Thank you so much Sir for the amazing lectures.

  • @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

  • @codecamp2111
    @codecamp2111 4 ปีที่แล้ว +4

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

  • @krishanudutta2943
    @krishanudutta2943 3 ปีที่แล้ว

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

  • @kajalsainiiuuhjj8866
    @kajalsainiiuuhjj8866 2 ปีที่แล้ว

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

  • @mahisanap4178
    @mahisanap4178 ปีที่แล้ว

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

  • @ashsharma6433
    @ashsharma6433 5 ปีที่แล้ว

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

  • @praneshnanoskar6353
    @praneshnanoskar6353 4 ปีที่แล้ว

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

  • @rubul2071
    @rubul2071 4 ปีที่แล้ว

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

  • @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 ปีที่แล้ว

      th-cam.com/channels/5UCDqBotPtxQgfum4iGM2A.html

  • @harini.a7934
    @harini.a7934 4 ปีที่แล้ว

    Nice lecture with clear explanations and examples..

  • @vaibhav0207
    @vaibhav0207 3 ปีที่แล้ว +1

    Sir, Sir ,Sir ................wow just awesome lecture loved it

  • @nabeelusmani5937
    @nabeelusmani5937 3 ปีที่แล้ว

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

  • @polasaibhargavgupta8301
    @polasaibhargavgupta8301 3 ปีที่แล้ว

    Awesome teaching also love the way u teach❤️

  • @travelnlearn
    @travelnlearn 2 ปีที่แล้ว

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

  • @bhaveshmali6266
    @bhaveshmali6266 ปีที่แล้ว

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

  • @lohithps3968
    @lohithps3968 5 ปีที่แล้ว +1

    Nice explanation sir. Tq I learnt this topic

  • @ghanshyam014
    @ghanshyam014 3 ปีที่แล้ว

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

  • @codingwithabhilashtiwari1425
    @codingwithabhilashtiwari1425 5 ปีที่แล้ว +1

    Love you sir.
    Fantastic explanation sir

  • @ManishPatidarmanishnice
    @ManishPatidarmanishnice 4 ปีที่แล้ว

    Awesome explanation... Top class.... 👌👌👌

  • @swapnafenn4957
    @swapnafenn4957 ปีที่แล้ว +1

    Nothng to say..but a biggggggg hug..thanz a lot...topic is crystal clear for me

  • @happycoding5163
    @happycoding5163 3 ปีที่แล้ว

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

  • @sayandas7323
    @sayandas7323 5 ปีที่แล้ว +4

    Explanation asum 10000/100😄😄

  • @vikas_kaushal8276
    @vikas_kaushal8276 ปีที่แล้ว +1

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

  • @ritugrewal7488
    @ritugrewal7488 5 ปีที่แล้ว +1

    Aap jaisa koi teach krne wala ni dekha sir .bhut achhe se btate ho

    • @GateSmashers
      @GateSmashers  5 ปีที่แล้ว

      Thank You. Keep learning and sharing

  • @user-mq7bm5fn9y
    @user-mq7bm5fn9y 3 หลายเดือนก่อน

    love you sir understand in easy way of each step

  • @sajansekhu8785
    @sajansekhu8785 4 ปีที่แล้ว

    sir explanation is vry nyc ..
    .thnkk u so much ji...
    stay blessed...

  • @Andy-jw9oc
    @Andy-jw9oc 5 ปีที่แล้ว

    Thanks for explaining in such a easy way

  • @yashitbhandula2389
    @yashitbhandula2389 4 ปีที่แล้ว

    EXPLANATION IS VERY GUD.......
    I REALLY LIKE IT ......
    THANKS A LOT SIR.

  • @natureisbest7632
    @natureisbest7632 5 ปีที่แล้ว

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

  • @maazrehman6702
    @maazrehman6702 หลายเดือนก่อน

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

  • @kalpanaverma1269
    @kalpanaverma1269 3 ปีที่แล้ว +1

    This really helps !!! Thank you 🙌

  • @2441139knakmg
    @2441139knakmg 5 ปีที่แล้ว +1

    Wow yaar! Nice job!