I work as SDE@Zomato. Being a Competitive Programmer, I like to solve algorithmic questions on various online judges. 

Vaibhav Khandelwal

The course will give you a detailed knowledge about all the topics include in Concurrency Control in Database Management Systems. The course starts from Introduction of all the related terms and definitions and take you deeper towards various techniques used to solve concurrency control with the help of worked out Examples and various questions which have been asked in GATE in previous years.

GATE (Graduate Aptitude Test in Engineering) 2020 & 2021 complete preparation with best educators. Know about the detailed syllabus, best books, exam pattern and dates, previous year question papers a

GATE - Iconic Pro

English

Concurrency Control: GATE

Concurrency Control Techniques

Database Management System

CS & IT

GATE - CSIT, DSAI & Interview Preparation

GATE, ESE and IIT-JAM

Ace the toughest competitive and government exams in India 

Test Preparation

In this lesson you will get an overview of the syllabus of the course. You will also understand need of concurrency control with the help of a scenario. Stay tuned for next lessons.

Overview

In this lesson you will study about definition of a Transaction and its different properties.

Transactions and their Properties

In this lesson you will study about isolation and durability properties of a Transaction. You will also study basics of schedules, types of schedules and various problems in a schedule.

Schedules

In this video you will study about Uncommitted Dependency Problem, Dirty Read problem, Serializability and classification of Serializability.

Serializability

In this lesson, you will study conflicting operations, conflict equivalent schedules and finally Conflict Serializability test. We will also solve examples of each of them.

Conflict Serializability Test

In this lecture you will learn about View Equivalent Schedules and View Serializability Test.

View Serializability Test

In this lesson you will study some of the basics of lock based protocols along with different types of locks and their compatibility.

Lock Based Protocols

In this lesson you will learn about Two phase locking protocol, it's variation and pros-cons. Also, we will see how we can solve lost update and uncommitted dependency problem using 2PL

Two Phase Locking Protocol

In this video we will see how to detect a deadlock in a schedule using Wait For Graphs

Deadlock Detection

In this lecture we will see three techniques to prevent a deadlock namely- Time-out, Wait-Die, Wound-wait.

Deadlock Prevention

In this lecture we will discuss some parameters on which we should decide how to recover from a deadlock situation.

Deadlock Recovery

In this lesson we will discuss timestamp ordering protocol for concurrency control.

Timestamp Ordering Protocol

In this lecture we will discuss Thomas Write Rule under timestamp ordering protocols.

Thomas Write Rule

In this video we will discuss the Optimistic Method of Concurrency control.

Optimistic Concurrency Control

In this lecture we will solve some GATE questions related to concurrency control.

GATE Questions related to Concurrency control

Mentored 81,000+ Students | My Multiple Students secured AIR Below 100 in GATE | Joined top IISc, IITs & NITs | Joined PSUs | 5+ Years Exp.

Sweta Kumari

This course will cover File Structures & Indexing in Databases. In this course, I will be covering File organization , Hashing , Indexing Methods and Data replication.

(Hindi) File Structures & Indexing In Databases : GATE (CS/IT)

Teaching experience of 4+ years as GATE faculty with some prestigious GATE institutions,Qualifying GATE from 2014,Qualifyied UGC NET 2018(ju

Megha 

In this course, the educator will give detail information about a number of concurrency control techniques that are used to ensure the isolation property. Two phase locking protocol will be discussed in detail.

Concurrency Control Techniques: GATE

This course will give detail information about number of concurrency control techniques that are used to ensure the isolation property.Two phase locking protocol will be discussed in detail.Granularity of data items will be discussed in detail.

(Hindi) Concurrency Control Techniques : GATE (CS and IT)

This course discusses Database Management System for GATE examination.

(Hindi) MCQs on Database Management System for GATE 2018

This course will cover NOSQL Databases in 60 Minutes.

(Hindi) Learn NOSQL Databases in 60 Minutes

This course will cover Big Data Tutorial in 60 Minutes. The course will be GATE Aspirants.

Lessons

15 lessons • 2h 36m

Invalid Date

NaN

Overview

Invalid Date

NaN

Transactions and their Properties

Invalid Date

NaN

Schedules

Invalid Date

NaN

Serializability

Invalid Date

NaN

Conflict Serializability Test

Invalid Date

NaN

View Serializability Test

Invalid Date

NaN

Lock Based Protocols

Invalid Date

NaN

Two Phase Locking Protocol

Invalid Date

NaN

Deadlock Detection

Invalid Date

NaN

Deadlock Prevention

+ See all lessons