Java Script needs to be enabled for Video to Load.

Serializability, View Equivalence and Recoverability

Loading Video Lesson
In this 49 mins Lesson you will Learn about following concepts.
Serializability, View Equivalence and Recoverability

Need For Serializability, Example: Confilct serializability, Conflict Equivalence, Test For Conflict Serializability, View Equivalence, View Serializability, Recoverability, Recoverable Schedule, Cascadeless Schedule, and related Topics.


Related Video Lessons in this Series

Transactions - Basic Concepts and ACID properties

41 mins Video Lesson

Introduction, ACID Properties, Atomicity, Consistency, Isolation, Durability, Transaction states, and other topics.

Concurrency and Concept of Schedules

40 mins Video Lesson

Introduction, Concurrency, Advantages of Concurrency, Schedule, Serial Schedule, Equivalence of Schedules, Conflicting Set of Operations, Conflict Serializability, Serializability, and other topics.

Serializability, View Equivalence and Recoverability

49 mins Video Lesson

Need For Serializability, Example: Confilct serializability, Conflict Equivalence, Test For Conflict Serializability, View Equivalence, View Serializability, Recoverability, Recoverable Schedule, Cascadeless Schedule, and other topics.

SQL - Basic Concepts and Queries

56 mins Video Lesson

Introduction, 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 Lesson

Table 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 Lesson

Introduction, NULL Comparison, Nested Queries - In/ Some/ Any/ All, Co-Related Query - Exist/ Not Exist, and other topics.

Joins, Aggregate Functions, Group By, Having clause and DB Modifications

33 mins Video Lesson

Joins , Aggregate Functions, Grouping, Having Clause, Insert, Delete, and other topics.

Assertions, Triggers, Roles and Embedded SQL

43 mins Video Lesson

Assertions, Triggers, Privileges, Roles, Embedded SQL, and other topics.

Member's Zone