Loading Revision Notes. Please Wait, it may take upto a minute
Introduction, Concurrency, Advantages of Concurrency, Schedule, Serial Schedule, Equivalence of Schedules, Conflicting Set of Operations, Conflict Serializability, Serializability, and related Topics.
Introduction, ACID Properties, Atomicity, Consistency, Isolation, Durability, Transaction states, and other topics.
Introduction, Concurrency, Advantages of Concurrency, Schedule, Serial Schedule, Equivalence of Schedules, Conflicting Set of Operations, Conflict Serializability, Serializability, and other topics.
Need For Serializability, Example: Confilct serializability, Conflict Equivalence, Test For Conflict Serializability, View Equivalence, View Serializability, Recoverability, Recoverable Schedule, Cascadeless Schedule, and other topics.
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.
Table Creation, Domain Creation, Deleting a table - Drop Table, Modifying a Table - Alter Table, Views, and other topics.
Introduction, NULL Comparison, Nested Queries - In/ Some/ Any/ All, Co-Related Query - Exist/ Not Exist, and other topics.
Joins , Aggregate Functions, Grouping, Having Clause, Insert, Delete, and other topics.
Assertions, Triggers, Privileges, Roles, Embedded SQL, and other topics.