Database Transactions (ACID)

This computer science lesson covers the principles of database transactions with some simple examples. The ACID properties of a typical database transaction are described including Atomic, Consistent, Isolated and Durable. This tutorial briefly introduces the code of a Transact SQL (T-SQL) stored procedure that defines a transaction, including use of the commands BEGIN TRANSACTION, COMMIT TRANSACTION and ROLLBACK TRANSACTION.
Chapters:
00:00 ACID database transactions introduction
00:07 Example of a database transaction (bank accounts)
01:51 Definition of a database transaction
02:52 Example of a database transaction (archive students)
03:38 Implementing database transactions with SQL stored procedures
05:44 ACID properties of data transactions

[@GESSIO26]

You made this concept's very clear. Something my current professor is failing to do unfortunately. Excellent video

[@ComputerScienceLessons]

Thank you. Glas to help :)KD

[@EminoMeneko]

I had the same. And not only for ACID properties. I had teachers fail to explain me Foreign Keys and interfaces for instance. I did not understand then, but that's actually very simple.
Everything can be complex or simple depending on having the right people explaining in the right manner. Easier said than done to many. Myself, I'm not always good at explaining things I understand.

[@MWELASEDUBANDLELA]

You guys sound like ungrateful girlfriends in these comments😂😂
"Ohh you do it so much better than my boyfriend"

[@hanheeyang9837]

Thanks so much! My college professor is very bad. You are saving me so much time!

[@EminoMeneko]

This is tremendously well explained. I love it when things are explained in very simple terms, with clear examples and straight to the point. 👌💯

[@ComputerScienceLessons]

You are most welcome. Thank you :)KD

[@CASLOAcademy]

the most clear and precise explanation that others cant do it! thank you so much for that! please keep creating videos like that

[@ComputerScienceLessons]

Will do. Thank you :)KD

[@luispedromorales3242]

Beautiful explanation! In 7 minutes I learned way much more than two 80 min lessons from my DB college course teacher...

[@ComputerScienceLessons]

That's lovely to hear. Thank you :)KD

[@shan9544]

Sweet jesus! I was struggling to fully understand the concept of ACID by watching 2 hours long lectures from my professor.
However, 7 minutes of this video made it so clear!! Nice examples and clear explanations. Thanks a lot!

[@77cheese]

same we must have the same prof :'(

[@samikshamahure]

Your explanations are great! please make a video on the relational model as well.

[@coryaccardo2690]

A beautiful explanation. You really have no idea how much I appreciate your channel…

[@ComputerScienceLessons]

Thank you. You have no idea how much I appreciate comments like yours :)KD

[@marindedic441]

The best DB transactions explanation online. You rock!

[@ComputerScienceLessons]

Thank you :)KD

[@kamran_desu]

One of the best succinct explanations of ACID

[@DarkMonsterGFX]

I have to learn this a few months ago for the College! Thanks for the vid!!

[@Kacper-ve5pd]

Great explanation. Thanks mate!

[@sdrtsdhgf849]

short and informative! Thanks!

[@jermainewilliams4798]

I like your use of the example code to me the concept clear.

[@Jay_D_Lincoln]

Excellent. You are the Attenborough of SQL (y)

[@ComputerScienceLessons]

You are too kind :)KD

[@karansingh-nn1zv]

Well explained 🙏 in a simple and lucid language , thank you soooooo much

[@ComputerScienceLessons]

You are most welcome. Thank you :)KD

[@maximvassilev172]

Super helpful!
Nice👌

[@khanhdovanit]

That's beyond greatness! Thanks,

[@ComputerScienceLessons]

You are most welcome :)KD

[@aminehaine3301]

Thank you. You made this concept very easy to understand.

[@ComputerScienceLessons]

You're welcome. Glad to help :)KD

[@mydadshowering2978]

thank you ComputeR Sciene for the video on Transactions i n DMBS !! i am now better prepared for my examination on the 25th oth may in 2022 thanjs to your excellent vidio thank you kind sir :D

[@ComputerScienceLessons]

I wish you the very best of luck :)KD

[@sumanahmed4570]

Wow! wonderful explanation. Thanks.

[@ComputerScienceLessons]

You are most welcome. And thank you :)KD

[@AriKhuu]

your voice is so mesmerizing!

[@rahulthaker694]

Great video, Love your voice

[@Azimofffable]

really nice explanation

[@dublin18]

Great video. Thanks

[@ComputerScienceLessons]

Thank you :)KD

[@anuragnagpal]

Awesome Videos Thanks

[@ComputerScienceLessons]

Thank you :)KD

[@benjaminmoseslieb9856]

a perfect tutorial

[@ComputerScienceLessons]

Thank you :)KD

[@PeekMe1]

Thank you

[@meow-pk5gq]

thank you

[@AdiAdi-fm6yi]

Great video!

[@ComputerScienceLessons]

Thank you :)KD

[@davidlee588]

Could you help explain why ORM frameworks such as Rails's ActiveRecord and Django don't retry aborted transactions?

[@ksmemon1]

Practical Real world example is needed

[@dusmannalinwad]

good short not

[@morningstar3437]

Why is he talking like that 💀😂

[@ComputerScienceLessons]

He's attempting to be clear :)KD

[@morningstar3437]

@@ComputerScienceLessons I did understand for sure , thank you mate

[@robloxsupport1249]

Goofy ahh bri ish bro 💀💀💀