Timestamp based and Optimistic Protocols
Loading Video Lesson
In this 46 mins Lesson you will Learn about following concepts.
Timestamp based Protocols, Timestamp Ordering protocol, Thomas' Write Rule, Optimistic/ Validation Based Protocols, Multiversion Scheme, and related Topics.
Related Video Lessons in this Series
.jpg)
Lock Based Protocols
55 mins Video LessonIntroduction, Lock Based Protocols, Starvation, Desdlocks, 2 Phase Locking Protocol, Strict 2PL, Rogorous 2PL, Lock Conversion Based Protocol, and other topics.
Timestamp based and Optimistic Protocols
46 mins Video LessonTimestamp based Protocols, Timestamp Ordering protocol, Thomas' Write Rule, Optimistic/ Validation Based Protocols, Multiversion Scheme, and other topics.
Deadlocks
38 mins Video LessonDeadLocks, Deadlock Prevention, Preemtion/ Rollback Scheme, Wait-Die Scheme, Wound-Wait Scheme, Deadlock Detection, Deadlock Recovery, Selection of Victim, Rollbacks, and other topics.
Failures and Log based Recovery Techniques
45 mins Video LessonIntroduction, Types of Failures, Log Based Recovery, Deferred Database Modification, Immediate Database Modification, and other topics.
Check point based Recovery and Shadow Paging
36 mins Video LessonCheckpoint Based Recovery, Shadow Paging, and other topics.
SQL - Basic Concepts and Queries
56 mins Video LessonIntroduction, Data Types, Schema And Catalog, Select-From-Where, Cross Product, Aliasing / Rename, Star Symbol (*), SQL results as MultiSet, Set Operations, Generalized Projection - Use of Math. Ops, Order By, String Comparison - Like, and other topics.
Data Definitions, Schemas and Views
39 mins Video LessonTable Creation, Domain Creation, Deleting a table - Drop Table, Modifying a Table - Alter Table, Views, and other topics.
NULL Comparisons, Nested and Co-related Queries
41 mins Video LessonIntroduction, NULL Comparison, Nested Queries - In/ Some/ Any/ All, Co-Related Query - Exist/ Not Exist, and other topics.
