Starting a new Lecture Notes Series on Database Management System(DBMS) Full Course
Youtube Lecture Playlist CreditsChannel Name: Easy Engineering Classes
So Let Us Start to This Journey of Learning
Database Management System(DBMS) Full Course By Lecture Notes together!
Lecture 97: L94: Solved Question(1) on SQL Queries - Employee, Works, Company, Manages Relation Queries
Lecture 98: L95: Solved Question(2) on SQL Queries - Question on Vehicle, Person and Owner Table | DBMS Lectures
Lecture 101: L98: PL-SQL Select Into Statement with Example | Database Management System(DBMS) Lectures in Hindi
Lecture 102: L99: PL-SQL Condition Statement - IF Then, If Then else, CASE Statement with Examples | DBMS
Lecture 103: L100: PL-SQL Loops - For Loop, While Loop, Simple PL-SQL Loop with Examples | DBMS Lectures
Lecture 104: L101: PLSQL Cursor, Implicit and Explicit Cursor, How to Open, Fetch, Close Cursor | DBMS Lectures
Lecture 105: L102: PL-SQL Functions, How to Create PL SQL Function using Table with Examples | DBMS Lectures
Lecture 106: L103: PL-SQL Procedure, How to Create Procedure, Call Procedure with Example | DBMS Lectures
Lecture 107: L104: PLSQL Trigger, Row and Statement Level Trigger, How to Write Trigger with Examples | DBMS
Lecture 108: L105: PL SQL Exception Handling | How to Raise Exception in PLSQL with Examples | DBMS Lectures
Lecture 109: L106: Introduction to Transaction Management | ACID Properties in Database Management System(DBMS)
Lecture 110: L107: Transaction States with Diagram | Database Management System(DBMS) Lectures in Hindi
Lecture 111: L108: Database Concurrency Problems | Lost Update, Dirty Read, Unrepeatable Read, Incorrect Summary
Lecture 112: L109: Schedule in Database | Serial, Complete, Recoverable, Cascadeless, Strict Schedule with Eg.
Lecture 113: L110: Introduction to Serializability | Conflict and View Serializable Schedules in Database(DBMS)
Lecture 114: L110-1: Practice Problems on Problems on Conflict Serializability in Database Transaction Management
Lecture 115: L111: Conflict Equivalent Schedules with Example | Transaction concurrency and Control | DBMS
Lecture 116: L112: Concurrency Control - Lock Based Protocol in Database Management System(DBMS) with Examples
Lecture 117: L113: 2 Phase Locking(2PL) Protocol in Transaction Concurrency Control | Database(DBMS) Lectures
Lecture 118: L113-1: Practice Problem on 2PL(Two Phase Locking) - Add Lock/Unlock and check for Deadlock
Lecture 119: L114: Deadlock Detection in Database Transaction | Wait For Graph Explanation with Example | DBMS
Lecture 120: L115: Deadlock Control Techniques | Deadlock Prevention | Timestamps and Time Out based Scheme
Lecture 121: L116: Timestamp Ordering Protocol in Database Transaction Management | DBMS Lectures in Hindi
Lecture 124: L119: Deadlock Recovery in Database Transaction with example | Database Management System(DBMS)
Lecture 125: L120: Log Based Database Recovery | Write Ahead Log Buffer Strategy | DBMS Lectures in Hindi
Lecture 126: L121: Transaction Recovery Procedure - Deferred Database Vs. Immediate Database Modification
Lecture 127: L121-1: Differentiate between Immediate Update and Deferred Update Recovery Techniques | DBMS
Lecture 128: L122: Shadow Paging in Database Recovery | Advantages over Log Based Method and Drawbacks | DBMS
Lecture 129: L123: Explain Checkpoints and How Does it helps in reducing recovery time | DBMS Lectures in Hindi
Lecture 130: L124: Types of Database Indexes | Ordered, Clustered, Primary, Dense, Sparse, Secondary Index | DBMS
Lecture 131: L125: Database File Organization | B+ Tree and Other Types with Examples | DBMS Lectures in Hindi
Lecture 132: L126: Introduction to Distributed Database | Features, Advantages and Disadvantages | DBMS Lectures
Lecture 133: L127: Types of Distributed Databases | Data Storage (Fragmentation, Replication) | Transparency
Lecture 134: L128: Query Processing & Optimization in Distributed Database | Query Processing Steps, Query Blocks
Lecture 135: L129: Implementation of Select Operation, Complex Select Operation (And, Or) in Distributed Database
Lecture 136: L130: Implementation of Project Operation with Duplication Removal in Distributed Database
Lecture 137: L131: Implementation of Set Operation | Union, Intersection, Minus Operator in Distributed Database
Lecture 138: L132: Distributed Query Processing | Simple Join, Semi Join Processing | Parallelism | DBMS Lectures
Lecture 139: L133: Distributed Database Transactions | Distributed Locking (Single and Distributed Lock Manager)
Lecture 140: L134: Distributed Database Deadlock Handling | Local and Global Wait for Graph | DBMS Lectures
Lecture 141: L135: Distributed Database Recovery | Two Phase and Three Phase Commit Protocol | DBMS Lectures
Lecture 142: L136: Primary Copy | Majority Locking | Timestamping (Centralized and Distributed Scheme) | DBMS