Chapter 1 : Stored Procedures
Topic : Stored Procedures and Functions
Content : Stored Procedures and Functions, Create procedure, create function, invoke the procedures and functions 36 MB ,19:47 MIN , THEORY + PRACTICAL

Chapter 2 : Triggers
Topic : Triggers
Content : Concept of triggers, Implementing triggers, creating triggers, insert, delete and update triggers, nested triggers, viewing, deleting and modifying triggers 46 MB ,26:3 MIN , THEORY + PRACTICAL

Chapter 3 : Sequence
Topic : Using Sequences
Content : Creating sequences, referencing, altering and dropping a sequence 34 MB ,19:7 MIN , THEORY + PRACTICAL

Chapter 4 : File Organization and Indexing
Topic : Index data structure
Content : hash and Tree based indexing 35 MB ,18:57 MIN , THEORY

Chapter 4 : File Organization and Indexing
Topic : File Organization
Content : File Organizations, Types of File Organizations: Sequential File Organization, Heap File Organization, Hash File Organization, B+ Tree File Organization, Clustered File Organization 20 MB ,10:10 MIN , THEORY

Chapter 1 : Fundamentals of PL/SQL
Topic : Introduction to PL/SQL
Content : Introduction to PL/SQL, Why PL/SQL? Need of PL/SQL, Purpose of PL/SQL, PL/SQL Architecture 21 MB ,12:24 MIN , THEORY

Chapter 1 : Fundamentals of PL/SQL
Topic : Identifiers and Keywords
Content : PL/SQL Identifiers and Keywords 14 MB ,7:7 MIN , THEORY + PRACTICAL

Chapter 1 : Fundamentals of PL/SQL
Topic : Datatypes
Content : Defining variables and constants, Data types in PL/SQL, inheriting datatypes, %TYPE, %ROWTYPE 40 MB ,22:5 MIN , THEORY + PRACTICAL

Chapter 1 : Fundamentals of PL/SQL
Topic : PL/SQL Block Structure
Content : PL/SQL Block Structure, Types of PL/SQL Blocks, Anonymous Blocks 23 MB ,12:18 MIN , THEORY + PRACTICAL

Chapter 3 : Overview of PL/SQL Control Structures
Topic : Overview of PL/SQL Control Structures
Content : Conditional Control statements, IF and CASE Statements, IF-THEN statement, IF-THEN-ELSE Statement, IF-THEN-ELSIF Statement, CASE Statement, CASE with selector, CASE with conditions 34 MB ,16:29 MIN , THEORY + PRACTICAL

Chapter 1 : Fundamentals of PL/SQL
Topic : Case Expressions
Content : Case Expressions 13 MB ,6:48 MIN , THEORY + PRACTICAL

Chapter 3 : Overview of PL/SQL Control Structures
Topic : Overview of PL/SQL Control Structures-Loops
Content : Loops in PL/SQL, Iterative Control: LOOP and EXIT Statements, SIMPLE LOOP, WHILE-LOOP, FOR-LOOP 18 MB ,9:23 MIN , THEORY + PRACTICAL

Chapter 1 : Fundamentals of PL/SQL
Topic : Logical Operators
Content : Logical Operators: AND, OR, NOT 15 MB ,8:23 MIN , THEORY + PRACTICAL

Chapter 1 : Fundamentals of PL/SQL
Topic : Null Values in Comparisons and Conditional
Content : Null Values in Comparisons and Conditional 24 MB ,14:4 MIN , THEORY + PRACTICAL

Chapter 3 : Overview of PL/SQL Control Structures
Topic : Sequential Control
Content : Sequential Control: Goto & NULL 17 MB ,9:47 MIN , THEORY + PRACTICAL

Chapter 1 : Transaction Management
Topic : Concurrency Control - Lock Management
Content : Concurrency Control - Lock Management, Lock Granularity, Lock Types, Deadlocks, Binary Locking, Shared / Exclusive Locking, Two - Phase Locking (2PL) 30 MB ,15:31 MIN , THEORY

Chapter 1 : Transaction Management
Topic : Transaction Management-ACID Properties
Content : Transaction, Characteristics Of Transactions, ACID Properties 18 MB ,10:28 MIN , THEORY

Chapter 1 : Transaction Management
Topic : Concurrency Control-Deadlock
Content : Concurrency Control, Deadlock, Deadlock detection & Prevention 18 MB ,10:27 MIN , THEORY

Chapter 1 : Transaction Management
Topic : Concurrency control
Content : Concurrency control, Methods for Concurrency control, Locking Methods, Time-stamp Methods, Optimistic Methods 14 MB ,7:51 MIN , THEORY

Chapter 1 : Transaction Management
Topic : Concurrency control-Optimistic Method
Content : Concurrency control-Optimistic Method, Read phase, Validation or certification phase, Write phase 9 MB ,5:8 MIN , THEORY

Chapter 1 : Transaction Management
Topic : Concurrency control-Timestamp based protocol
Content : Concurrency control-Timestamp based protocol, Timestamp Ordering Protocol, Thomas Write Rule 18 MB ,9:9 MIN , THEORY

Chapter 2 : DCL Statements (TCL Statements)
Topic : DCL Statement (TCL Statement)
Content : Defining a transaction, Making Changes Permanent with COMMIT, Undoing Changes with ROLLBACK, Undoing Partial Changes with SAVEPOINT and ROLLBACK 30 MB ,16:57 MIN , THEORY

Chapter 1 : Transaction Management
Topic : Two Phase Locking Protocol
Content : 2PL, Two Phase Locking Protocol 20 MB ,11:57 MIN , THEORY

Chapter 1 : Transaction Management
Topic : Concurrency Control-Lost Update Problem
Content : Lost Update Problem 6 MB ,3:58 MIN , THEORY

Chapter 1 : Transaction Management
Topic : Serializability
Content : Serializability: Conflict Serializability & View Serializability 21 MB ,12:30 MIN , THEORY

Chapter 2 : DCL Statements (TCL Statements)
Topic : DCL Statement (TCL Statement)
Content : Using TCL statements Demo 10 MB ,4:44 MIN , PRACTICAL

Chapter 3 : Crash recovery
Topic : System Recovery-ARIES Algorithm
Content : System Recovery, ARIES Algorithm 45 MB ,26:41 MIN , THEORY

Chapter 3 : Crash recovery
Topic : Data Recovery
Content : Data Recovery, Crash Recovery, Recovery and Atomicity, Log-based Recovery, Checkpoint, Redo list, Undo List 31 MB ,18:24 MIN , THEORY

Chapter 3 : Crash recovery
Topic : Data Recovery
Content : Crash Recovery, Failure Classification, Recovery and Atomicity, Log-based Recovery, Recovery with Concurrent Transactions, Checkpoint, Recovery 31 MB ,18:24 MIN , THEORY

Chapter 3 : Crash recovery
Topic : Two Phase Commit Protocol
Content : Two Phase Commit Protocol 13 MB ,7:25 MIN , THEORY

Chapter 3 : Crash recovery
Topic : Write-ahead log protocol
Content : Write-ahead log protocol 11 MB ,6:8 MIN , THEORY

Chapter 3 : Crash recovery
Topic : Recovery Related Structures
Content : Recovery Related Structures: Transaction Table & Dirty page table 31 MB ,18:24 MIN , THEORY

Chapter 1 : Transaction Management
Topic : Two Phase Commit Protocol
Content : Two Phase Commit Protocol 13 MB ,7:25 MIN , THEORY