Deep Dive on Locks & Deadlocks for Application Developers

Check out Dometrain and use code ZORAN for 15% off any course ► https://dometrain.com/?coupon_code=ZORAN

Download source code ►   / zoranhorvat  
Join Discord server with topics on C# ► https://codinghelmet.com/go/discord
Enroll course Beginning Object-Oriented Programming with C# ► https://codinghelmet.com/go/beginning...
Subscribe ►    / @zoran-horvat  

How far are you ready to go as an application developer in understanding the processes that happen inside the relational database? Will you hide behind a database access library or an ORM and pretend the database will cope with any request the application passes down?
This video explains the trouble an application developer must go through to ensure that concurrent application use does not damage data or cause a deadlock. No matter what access method you use, this demo will show you the rules to obey. Otherwise, errors of all kinds will happen, including damage to data, deadlocks, and concurrent update errors.

⌚ 00:00 Intro
⌚ 01:18 Relying on Implicit Transactions
⌚ 08:32 Using Pessimistic Locking
⌚ 11:01 Avoiding Deadlocks
⌚ 17:44 Using Optimistic Locking
⌚ 24:03 Recovering from Concurrent Updates

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
👨 About Me 👨
Hi, I’m Zoran, I have more than 20 years of experience as a software developer, architect, team lead, and more. I have been programming in C# since its inception in the early 2000s. Since 2017 I have started publishing professional video courses at Pluralsight and Udemy and by this point, there are over 100 hours of the highest-quality videos you can watch on those platforms. On my YouTube channel, you can find shorter video forms focused on clarifying practical issues in coding, design, and architecture of .NET applications.❤️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚡️COPYRIGHT NOTICE:
The Copyright Laws of the United States recognize a “fair use” of copyrighted content. Section 107 of the U.S. Copyright Act states: “Notwithstanding the provisions of sections 106 and 106A, the fair use of a copyrighted work, including such use by reproduction in copies or phono records or by any other means specified by that section, for purposes such as criticism, comment, news reporting, teaching (including multiple copies for classroom use), scholarship, or research, is not an infringement of copyright." This video and our youtube channel, in general, may contain certain copyrighted works that were not specifically authorized to be used by the copyright holder(s), but which we believe in good faith are protected by federal law and the Fair use doctrine for one or more of the reasons noted above.

#csharp #dotnet #relationaldatabase