Courses › CS Fundamentals
DBMS Complete Playlist
By Gate Smashers · Hindi · Beginner
ER model, normalization, SQL, transactions, indexing.
A free YouTube playlist, organised on Codify: your progress is saved, you can take timestamped notes and practise in the code editor under every video. All videos belong to their creator.
What this course covers (100 videos)
- Lec-1: DBMS Syllabus for GATE, UGCNET, NIELIT, DSSSB etc.| Full DBMS for College/University Students (18:04)
- Lec-2: Introduction to DBMS (Database Management System) With Real life examples | What is DBMS (12:00)
- Lec-3: File System vs DBMS | Disadvantages of File System | DBMS Advantages (13:00)
- Lec-4: 2 tier and 3 tier Architecture with real life examples | Database Management System (12:57)
- Lec-5: What is Schema | How to define Schema | Database management system in Hindi (4:34)
- Lec-6: Three Schema Architecture | Three Level of Abstraction | Database Management System (15:25)
- Lec-7: What is Data Independence | Logical vs. Physical Independence | DBMS (10:22)
- Lec-8: Integrity Constraints in Database with Examples (7:14)
- Lec-9: What is CANDIDATE KEY and PRIMARY key | Full Concept | Most suitable examples | DBMS (5:12)
- Lec-10: What is Primary Key in DBMS | Primary Key with Examples in Hindi (11:31)
- Lec-11: Foreign Key in DBMS | Full Concept with examples | DBMS in Hindi (8:43)
- Lec-12: Insert, Update & Delete from Foreign Key table | Referential Integrity (18:19)
- Lec-13: Question on Foreign Key | ये Question Competition Exams में अक्सर पूछा गया है (8:44)
- Lec-14: Foreign Key🔑 with On Delete Cascade with Execution (5:34)
- Lec-15: Super key in DBMS in HINDI | ये Question Competition Exams में अक्सर पूछा गया है (9:42)
- Lec-16: Introduction to ER model | ER Model क्या है (8:32)
- Lec-17: Types of Attributes in ER Model | Full Concept | DBMS in Hindi (14:02)
- Lec-18: One to One relationship in DBMS in Hindi (16:44)
- Lec-19: One to Many Relationship in DBMS in Hindi | 1-M Relationship (13:59)
- Lec-20: Many to Many Relationship in DBMS | M-N Relationship (10:47)
- Lec-21:Introduction to Weak Entity Set with Example | Database Management System (11:47)
- Lec-22:Question on Minimize tables in ER Model | ये Question Competition Exams में अक्सर पूछा गया है (5:38)
- Lec-23: Important Question explanation on ER Model | DBMS (8:44)
- Lec-24: Introduction to Normalization | Insertion, Deletion & Updation Anomaly (12:51)
- Lec-25: First Normal form in DBMS in HINDI | 1st Normal form क्या होती है ? (8:29)
- Lec-26: Finding Closure of Functional dependency in DBMS | Easiest & Simplest way (17:46)
- Lec-27: Functional Dependency & its properties in DBMS in HINDI (17:09)
- Lec-28: Second Normal Form | 2NF | Database Management System (18:00)
- Lec-29: Third Normal Form in dbms with examples in Hindi | Normalization (16:26)
- Lec-30: Boyce Codd Normal Form #BCNF #DBMS #Normalization with best examples (6:48)
- Lec-31: BCNF Always Ensures Dependency Preserving Decomposition?? Normalization Examples (10:04)
- Lec-32: Lossless and Lossy Decomposition| Fifth (5th) Normal Form | Database Management System (22:17)
- Lec-33: All Normal Forms with Real life examples | 1NF 2NF 3NF BCNF 4NF 5NF | All in One (11:15)
- Lec-34: Minimal Cover in DBMS With Example | Canonical cover (9:09)
- Lec-35: Practice Question on Normalization | Database Management System (20:08)
- Lec-36: How to find out the Normal form of a Relation | DBMS (24:03)
- Lec-37: How to Solve Normalization Questions | DBMS (9:21)
- Lec-38: Important Question Explanation on Normalization (19:28)
- Lec-39: Important Question on Normalization (Schemas) Explanation | DBMS (6:53)
- Lec-40: Cover and Equivalence of Functional Dependencies | Database Management System (13:24)
- Lec-41: Dependency Preserving Decomposition in DBMS with Examples in Hindi | DBMS (10:51)
- Lec-42: Dependency Preserving Decomposition in DBMS | Example 2 in Hindi (7:20)
- Lec-43: Introduction to Joins and its types | Need of Joins with example | DBMS (10:41)
- Lec-44: Natural Join operation with Example | Database Management System (16:11)
- Lec-45: Self Join operation with Example | Database Management System (14:37)
- Lec-46: Equi Join operation with Example | Database Management System (14:15)
- Lec-47: Left Outer Join operation with Example | Database Management System (7:48)
- Lec-48: Right Outer Join operation with Example | Database Management System (8:32)
- Lec-49: Question on Inner, Left, Right & Full Outer Joins Explanation | DBMS (4:03)
- Lec-50: Introduction to Relational Algebra | Database Management System (4:24)
- Lec-51: Projection in Relational Algebra | Database Management System (6:19)
- Lec-52: Selection in Relational Algebra | Database Management System (6:33)
- Lec-53: Cross/Cartesian Product in Relational Algebra | Database Management System (6:18)
- Lec-54: Set Difference in Relational Algebra | Database Management System (6:03)
- Lec-55: Union Operation in Relational Algebra | Database Management System (7:20)
- Lec-56: Division Operation in Relational Algebra | Database Management System (14:43)
- Lec-57: Rename Operator in Relational Algebra | Database Management System (DBMS) (13:21)
- Lec-58: Tuple Calculus in DBMS with examples (16:09)
- Lec-59: Introduction to Structured Query Language | All Points regarding its Features and Syllabus (12:10)
- Lec-60: All Types of SQL Commands with Example | DDL, DML, DCL, TCL and CONSTRAINTS | DBMS (10:32)
- Lec-61: Create table in SQL with execution | SQL for Beginners | Oracle LIVE (7:25)
- Lec-62: CREATE Command (DDL) in SQL with Implementation on ORACLE (10:57)
- Lec-63: ALTER Command (DDL) in SQL with Implementation on ORACLE (13:09)
- Lec-64: Difference between Alter and Update in SQL with examples in Hindi | DBMS (8:01)
- Lec-65: Difference between Delete, Drop & Truncate in SQL | DBMS (10:19)
- Lec-66: Constraints in SQL in Hindi | DBMS (12:01)
- Lec-67: SQL Queries and Subqueries (part-1) | Database Management System (8:58)
- Lec-68: SQL Queries and Subqueries (part-2) | 2nd Highest Salary | Nested Queries | DBMS (12:27)
- Lec-69: SQL Queries and Subqueries (part-3) | Group By clause | Database Management System (9:12)
- Lec-70: WITH Clause in SQL | SQL CTE (Common Table Expression) | DBMS (9:41)
- Lec-71: SQL Queries and Subqueries (part-4) | Having clause | Database Management System (11:02)
- Lec-72: SQL Queries and Subqueries (part-5) | Database Management System (11:30)
- Lec-73: SQL Queries and Subqueries (part-6)| use of IN and Not IN | Database Management System (9:14)
- Lec-74: SQL Queries and Subqueries (part-7)| use of IN and Not IN in Subquery | DBMS (9:40)
- Lec-75: EXIST and NOT EXIST Subqueries(part-8) | Database Management System (14:09)
- Lec-76: Like Command in SQL with example in Hindi | Learn SQL in Easiest Way| DBMS (10:42)
- Lec-77: SEQUENCE in SQL with Syntax & Examples (7:05)
- Lec-78: How SQL Query executes?? Order of SQL Query Execution⏳🔄 (7:05)
- Lec-79: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions | DBMS (11:21)
- Lec-80: How Aggregate Functions work on NULL Values | SQL | DBMS (7:23)
- Lec-81: Correlated Subquery in SQL with Example | Imp for Placements, GATE, NET & SQL certification (11:44)
- Lec-82: Non Correlated Subquery in SQL | Imp for Placements, GATE, NET & SQL certification (18:07)
- Lec-83: Difference between Joins, Nested Subquery and Correlated Subquery | Most Imp Concept of SQL (15:57)
- Lec-84: Find Nth(1st,2nd,3rd....N) Highest Salary in SQL | Imp for Competitive & Placement exam (12:54)
- Lec-85: 3 Imp Questions on SQL basic Concepts | DBMS (9:38)
- Lec-86: Introduction to PL-SQL in DBMS (6:25)
- Lec-87: Introduction to Transaction Concurrency in HINDI | Database Management System (12:42)
- Lec-88: ACID Properties of a Transaction | Database Management System (13:58)
- Lec-89: Transaction States | Database Management System (11:57)
- Lec-90: What is Schedule | Serial Vs Parallel Schedule | Database Management System (10:46)
- Lec-91: All Concurrency Problems | Dirty Read | Incorrect Summary | Lost Update | Phantom Read (4:57)
- Lec-92: Write-Read Conflict or Dirty Read Problem | Database Management System (8:24)
- Lec-93: Read-Write Conflict or Unrepeatable Read Problem | Database Management System (7:44)
- Lec-94: Irrecoverable Vs Recoverable Schedules in Transactions | DBMS (6:09)
- Lec-95: Cascading vs Cascadeless Schedule with Example | Recoverability | DBMS (11:33)
- Lec-96: Introduction to Serializability | Transactions Concurrency and Control | DBMS (9:17)
- Lec-97: Conflict Equivalent Schedules with Example | Transaction concurrency and Control | DBMS (7:20)
- Lec-98: Conflict Serializability | Precedence Graph | Transaction | DBMS (12:18)
- Lec-99: Why View Serializability is Used | Introduction to View Serializability | DBMS (11:24)
- Lec-100:Shared Exclusive Locking Protocol with Example | Concurrency Control | DBMS | Part-1 (6:44)
More CS Fundamentals courses
- Compiler Design — Gate Smashers · CS Fundamentals · Hindi
- Computer Networks — Gate Smashers · CS Fundamentals · Hindi
- Computer Organization and Architecture — Gate Smashers · CS Fundamentals · Hindi
- Digital Logic — Gate Smashers · CS Fundamentals · Hindi
- Discrete Mathematics — Gate Smashers · CS Fundamentals · Hindi
- Operating System — Gate Smashers · CS Fundamentals · Hindi