DBMS (Database Management System) (Hindi) (Part 3)

   Friday, March 06, 2026   

Starting a new Lecture Notes Series on DBMS (Database Management System)

Youtube Lecture Playlist Credits 

Channel Name: Gate Smashers

So Let Us Start to This Journey of Learning 

DBMS (Database Management System) By Lecture Notes together!

Lecture 97: Lec-83: Conflict Equivalent Schedules with Example | Transaction concurrency and Control | DBMS

Lecture 98: Lec-84: Conflict Serializability | Precedence Graph | Transaction | DBMS

Lecture 99: Lec-85: Why View Serializability is Used | Introduction to View Serializability | DBMS

Lecture 100: Lec-86:Shared Exclusive Locking Protocol with Example in Hindi | Concurrency Control | DBMS | Part-1

Lecture 101: Lec-87: Drawbacks in Shared/Exclusive Locking Protocol with Example | Concurrency Control Part-2

Lecture 102: Lec-88: 2 Phase Locking(2PL) Protocol in Transaction Concurrency Control | DBMS

Lecture 103: Lec-89: Drawbacks in 2 Phase Locking(2PL) Protocol with examples | Concurrency Control | DBMS

Lecture 104: Lec-90: Strict 2PL, Rigorous 2PL and Conservative 2PLSchedule | 2 Phase Locking in DBMS

Lecture 105: Lec-91: Basic Timestamp Ordering Protocol with Example in Hindi | Concurrency Control | DBMS

Lecture 106: Lec-92: How to Solve Question on Timestamp Ordering Protocol | Concurrency Control | DBMS

Lecture 107: Lec-93: Why Indexing is used | Indexing Beginning | DBMS

Lecture 108: Lec-94: Numerical Example on I/O Cost in Indexing | Part-1 | DBMS

Lecture 109: Lec-95: Numerical Example on I/O Cost in Indexing | Part 2 | DBMS

Lecture 110: Lec-96: Types Of Indexes | Most Important Video on Indexing

Lecture 111: Lec-97: Primary Index With Example | GATE, PSU and UGC NET | DBMS

Lecture 112: Lec-98: Clustered Index in Database with Example

Lecture 113: Lec-99: Secondary Index in Database with Example | Multilevel Indexing

Lecture 114: Lec-100: Introduction to B-Tree and its Structure | Block Pointer, Record Pointer, Key

Lecture 115: Lec-101: Insertion in B-Tree with example in Hindi

Lecture 116: Lec-102: How to find Order of B-Tree | Imp Question on B-Tree

Lecture 117: Lec-103: Difference b/w B-Tree & B+Tree in Hindi with examples

Lecture 118: Lec-104: Order of B+ Tree | Order of Leaf Node & Non Leaf Node in B+Tree

Lecture 119: Lec-105: Immediate Database Modification in DBMS | Log Based Recovery Methods

Lecture 120: Lec-106: Deferred Database Modification in DBMS | Log Based Recovery | Imp for UGC NET and KVS

Lecture 121: Lec-108: Basic PL-SQL Programming With Execution | Part-1

Lecture 122: Lec-109: Basic PL-SQL Programming(While, For Loop) With Execution | Part-2

Lecture 123: Lec-110: Single row and Multi row functions in SQL

Lecture 124: Lec-111: Character functions in SQL with execution | Oracle LIVE

Lecture 125: Lec-112: View in Database | Oracle, SQL Server Views | Types of Views

Lecture 126: Lec-114: What is RAID? RAID 0, RAID 1, RAID 4, RAID 5, RAID 6, Nested RAID 10 Explained

Lecture 127: Lec-115: Various objects in Database | Oracle, SQL Server

Lecture 128: Lec-117: Very Imp. Questions on DBMS basic concepts and Data Modelling | DBMS

Lecture 129: Lec-119: 4 Imp Questions on Advance DBMS | BIG Data and Data Warehouse | DBMS

Lecture 130: Lec-121: Important Question on Relational Algebra | DBMS

Lecture 131: Lec-122: Codd’s 12 Rules of RDBMS with examples

Lecture 132: Lec-123: Top 15 SQL Interview Questions Answers | Most Important Questions for Job Interview

Lecture 133: Lec-127: Introduction to Hadoop🐘| What is Hadoop🐘| Hadoop Framework🖥

Lecture 134: Lec-128: Introduction to BIG Data in Hindi | Small Data Vs BIG Data | Real Life Examples

Lecture 135: Lec-129: Simple vs Complex vs Materialized Views with examples | DBMS

Lecture 136: Procedures in PL-SQL | Local Procedure vs Stored Procedure

Lecture 137: How to Fetch Data from Database using Procedures | PL-SQL Procedure

Lecture 138: What is Cursor in PL-SQL with example

Lecture 139: %TYPE & %ROWTYPE in PL-SQL with Examples

Lecture 140: Data Cleaning using SQL Functions with examples