Concurrency and Concept of Schedules
Loading Video Lesson
In this 40 mins Lesson you will Learn about following concepts.
Introduction, Concurrency, Advantages of Concurrency, Schedule, Serial Schedule, Equivalence of Schedules, Conflicting Set of Operations, Conflict Serializability, Serializability, and related Topics.
Related Video Lessons in this Series
 Bad Audio.jpg)
Transactions - Basic Concepts and ACID properties
41 mins Video LessonIntroduction, ACID Properties, Atomicity, Consistency, Isolation, Durability, Transaction states, and other topics.
Concurrency and Concept of Schedules
40 mins Video LessonIntroduction, 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 LessonNeed 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 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.
Joins, Aggregate Functions, Group By, Having clause and DB Modifications
33 mins Video LessonJoins , Aggregate Functions, Grouping, Having Clause, Insert, Delete, and other topics.
Assertions, Triggers, Roles and Embedded SQL
43 mins Video LessonAssertions, Triggers, Privileges, Roles, Embedded SQL, and other topics.
