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

   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 49: Lec-49: Question on Inner, Left, Right & Full Outer Joins Explanation | DBMS

Lecture 50: Lec-50: Introduction to Relational Algebra | Database Management System

Lecture 51: Lec-51: Projection in Relational Algebra | Database Management System

Lecture 52: Lec-52: Selection in Relational Algebra | Database Management System

Lecture 53: Lec-53: Cross/Cartesian Product in Relational Algebra | Database Management System

Lecture 54: Lec-54: Set Difference in Relational Algebra | Database Management System

Lecture 55: Lec-55: Union Operation in Relational Algebra | Database Management System

Lecture 56: Lec-56: Division Operation in Relational Algebra | Database Management System

Lecture 57: Lec-57: Rename Operator in Relational Algebra | Database Management System (DBMS)

Lecture 58: Lec-58: Tuple Calculus in DBMS with examples

Lecture 59: Lec-59: Introduction to Structured Query Language | All Points regarding its Features and Syllabus

Lecture 60: Lec-60: All Types of SQL Commands with Example | DDL, DML, DCL, TCL and CONSTRAINTS | DBMS

Lecture 61: Lec-61: Create table in SQL with execution | SQL for Beginners | Oracle LIVE

Lecture 62: Lec-124: CREATE Command (DDL) in SQL with Implementation on ORACLE

Lecture 63: Lec-55: ALTER Command (DDL) in SQL with Implementation on ORACLE

Lecture 64: Lec-56: Difference between Alter and Update in SQL with examples in Hindi | DBMS

Lecture 65: Lec-57 Difference between Delete, Drop & Truncate in SQL | DBMS

Lecture 66: Lec-58: Constraints in SQL in Hindi | DBMS

Lecture 67: Lec-59: SQL Queries and Subqueries (part-1) | Database Management System

Lecture 68: Lec-60: SQL Queries and Subqueries (part-2) | 2nd Highest Salary | Nested Queries | DBMS

Lecture 69: Lec-61: SQL Queries and Subqueries (part-3) | Group By clause | Database Management System

Lecture 70: WITH Clause in SQL | SQL CTE (Common Table Expression) | DBMS

Lecture 71: Lec-62: SQL Queries and Subqueries (part-4) | Having clause | Database Management System

Lecture 72: Lec-63: SQL Queries and Subqueries (part-5) | Database Management System

Lecture 73: Lec-64: SQL Queries and Subqueries (part-6)| use of IN and Not IN | Database Management System

Lecture 74: Lec-65: SQL Queries and Subqueries (part-7)| use of IN and Not IN in Subquery | DBMS

Lecture 75: Lec-66: EXIST and NOT EXIST Subqueries(part-8) | Database Management System

Lecture 76: Lec-107: Like Command in SQL with example in Hindi | Learn SQL in Easiest Way| DBMS

Lecture 77: Lec-125: SEQUENCE in SQL with Syntax & Examples

Lecture 78: Lec-126: How SQL Query executes?? Order of SQL Query Execution⏳🔄

Lecture 79: Lec-67: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions | DBMS

Lecture 80: Lec-113: How Aggregate Functions work on NULL Values | SQL | DBMS

Lecture 81: Lec-68: Correlated Subquery in SQL with Example | Imp for Placements, GATE, NET & SQL certification

Lecture 82: Non Correlated Subquery in SQL with Example | Imp for Placements, GATE, NET & SQL certification

Lecture 83: Lec-69: Difference between Joins, Nested Subquery and Correlated Subquery | Most Imp Concept of SQL

Lecture 84: Lec-70: Find Nth(1st,2nd,3rd....N) Highest Salary in SQL | Imp for Competitive & Placement exam

Lecture 85: Lec-71: 3 Imp Questions on SQL basic Concepts | DBMS

Lecture 86: Lec-72: Introduction to PL-SQL in DBMS

Lecture 87: Lec-73: Introduction to Transaction Concurrency in HINDI | Database Management System

Lecture 88: Lec-74: ACID Properties of a Transaction | Database Management System

Lecture 89: Lec-75: Transaction States | Database Management System

Lecture 90: Lec-76: What is Schedule | Serial Vs Parallel Schedule | Database Management System

Lecture 91: Lec-77: All Concurrency Problems | Dirty Read | Incorrect Summary | Lost Update | Phantom Read

Lecture 92: Lec-78: Write-Read Conflict or Dirty Read Problem | Database Management System

Lecture 93: Lec-79: Read-Write Conflict or Unrepeatable Read Problem | Database Management System

Lecture 94: Lec-80: Irrecoverable Vs Recoverable Schedules in Transactions | DBMS

Lecture 95: Lec-81: Cascading vs Cascadeless Schedule with Example | Recoverability | DBMS

Lecture 96: Lec-82: Introduction to Serializability | Transactions Concurrency and Control | DBMS