MSBI Training Part 51

Friends,

This is the 51th video from the series of videos. In this video we are gonna discuss about the following topics –

• Concurrency
• Pessimistic Concurrency
• Optimistic Concurrency
• Concurrency Issues
• Lost or buried updates.
• Uncommitted dependency (dirty read).
• Inconsistent analysis (nonrepeatable read).
• Phantom reads.
• ACID Properties
• Transaction Log
• Locks
• Lock Duration
• Lock Modes
• Shared Lock
• Exclusive Lock
• Update Lock
• Intent Lock