Gate Smashers DBMS: study plan and how long it takes
The Gate Smashers playlist is 140 videos and 25.3 hours long. Here's how long it takes at different paces, a week-by-week schedule built from the real videos, and a planner that turns it into your own daily plan.
140 videos · 25.3 hours · Gate Smashers
Gate Smashers' DBMS playlist is one of the most-watched database courses in India. In 140 short Hindi lectures it covers keys, ER models, normalization up to BCNF, relational algebra, SQL queries and joins, transactions and serializability, concurrency control and indexing.
It follows the GATE and UGC NET syllabus closely, with solved questions after most topics.
Who it's for: GATE, UGC NET and university students, and anyone preparing for DBMS interview questions.
How long does it take?
The full playlist is 25.3 hours across 140 videos. Here's roughly how many days that is at different daily watch times and speeds, counting video time only:
| Daily time | At 1x | At 1.5x | At 2x |
|---|---|---|---|
| 30 min a day | 51 days | 34 days | 26 days |
| 1 h a day | 26 days | 17 days | 13 days |
| 2 h a day | 13 days | 9 days | 7 days |
Make your own schedule
The playlist link is already filled in. Press Plan, set how much time you have each day and your speed, and you'll get a day-by-day schedule with a finish date and a calendar file. It reads the live playlist, so new videos are included.
Week-by-week schedule
A sample plan at 1 hour a day and normal speed, using whole videos so none is split across days. That's 4 weeks in total. For a different pace, start date or speed, use the planner above.
Week 1Videos 1–32 · 6h 21m
Day 1 · 56m
- 1Lec-1: DBMS Syllabus for GATE, UGCNET, NIELIT, DSSSB etc.| Full DBMS for College/University Students18m
- 2Lec-2: Introduction to DBMS (Database Management System) With Real life examples | What is DBMS12m
- 3Lec-3: File System vs DBMS | Disadvantages of File System | DBMS Advantages13m
- 4Lec-4: 2 tier and 3 tier Architecture with real life examples | Database Management System13m
Day 2 · 54m
- 5Lec-5: What is Schema | How to define Schema | Database management system in Hindi5m
- 6Lec-6: Three Schema Architecture | Three Level of Abstraction | Database Management System15m
- 7Lec-7: What is Data Independence | Logical vs. Physical Independence | DBMS10m
- 8Lec-8: Integrity Constraints in Database with Examples7m
- 9Lec-9: What is CANDIDATE KEY and PRIMARY key | Full Concept | Most suitable examples | DBMS5m
- 10Lec-10: What is Primary Key in DBMS | Primary Key with Examples in Hindi12m
Day 3 · 1h
- 11Lec-11: Foreign Key in DBMS | Full Concept with examples | DBMS in Hindi9m
- 12Lec-12: Insert, Update & Delete from Foreign Key table | Referential Integrity18m
- 13Lec-13: Question on Foreign Key | ये Question Competition Exams में अक्सर पूछा गया है9m
- 14Lec-14: Foreign Key🔑 with On Delete Cascade with Execution6m
- 15Lec-15: Super key in DBMS in HINDI | ये Question Competition Exams में अक्सर पूछा गया है10m
- 16Lec-16: Introduction to ER model | ER Model क्या है9m
Day 4 · 56m
- 17Lec-17: Types of Attributes in ER Model | Full Concept | DBMS in Hindi14m
- 18Lec-18: One to One relationship in DBMS in Hindi17m
- 19Lec-19: One to Many Relationship in DBMS in Hindi | 1-M Relationship14m
- 20Lec-20: Many to Many Relationship in DBMS | M-N Relationship11m
Day 5 · 47m
- 21Lec-21:Introduction to Weak Entity Set with Example | Database Management System12m
- 22Lec-22:Question on Minimize tables in ER Model | ये Question Competition Exams में अक्सर पूछा गया है6m
- 23Lec-23: Important Question explanation on ER Model | DBMS9m
- 24Lec-24: Introduction to Normalization | Insertion, Deletion & Updation Anomaly13m
- 25Lec-25: First Normal form in DBMS in HINDI | 1st Normal form क्या होती है ?8m
Day 6 · 53m
- 26Lec-26: Finding Closure of Functional dependency in DBMS | Easiest & Simplest way18m
- 27Lec-27: Functional Dependency & its properties in DBMS in HINDI17m
- 28Lec-28: Second Normal Form | 2NF | Database Management System18m
Day 7 · 56m
- 29Lec-29: Third Normal Form in dbms with examples in Hindi | Normalization16m
- 30Lec-30: Boyce Codd Normal Form #BCNF #DBMS #Normalization with best examples7m
- 31Lec-31: BCNF Always Ensures Dependency Preserving Decomposition?? Normalization Examples10m
- 32Lec-32: Lossless and Lossy Decomposition| Fifth (5th) Normal Form | Database Management System22m
Week 2Videos 33–67 · 6h 23m
Day 8 · 41m
- 33Lec-33: All Normal Forms with Real life examples | 1NF 2NF 3NF BCNF 4NF 5NF | All in One11m
- 34Lec-34: Minimal Cover in DBMS With Example | Canonical cover9m
- 35Lec-35: Practice Question on Normalization | Database Management System20m
Day 9 · 1h
- 36Lec-36: How to find out the Normal form of a Relation | DBMS24m
- 37Lec-37: How to Solve Normalization Questions | DBMS9m
- 38Lec-38: Important Question Explanation on Normalization19m
- 39Lec-39: Important Question on Normalization (Schemas) Explanation | DBMS7m
Day 10 · 58m
- 40Lec-40: Cover and Equivalence of Functional Dependencies | Database Management System13m
- 41Lec-41: Dependency Preserving Decomposition in DBMS with Examples in Hindi | DBMS11m
- 42Lec-42: Dependency Preserving Decomposition in DBMS | Example 2 in Hindi7m
- 43Lec-43: Introduction to Joins and its types | Need of Joins with example | DBMS11m
- 44Lec-44: Natural Join operation with Example | Database Management System16m
Day 11 · 1h
- 45Lec-45: Self Join operation with Example | Database Management System15m
- 46Lec-46: Equi Join operation with Example | Database Management System14m
- 47Lec-47: Left Outer Join operation with Example | Database Management System8m
- 48Lec-48: Right Outer Join operation with Example | Database Management System9m
- 49Lec-49: Question on Inner, Left, Right & Full Outer Joins Explanation | DBMS4m
- 50Lec-50: Introduction to Relational Algebra | Database Management System4m
- 51Lec-51: Projection in Relational Algebra | Database Management System6m
Day 12 · 54m
- 52Lec-52: Selection in Relational Algebra | Database Management System7m
- 53Lec-53: Cross/Cartesian Product in Relational Algebra | Database Management System6m
- 54Lec-54: Set Difference in Relational Algebra | Database Management System6m
- 55Lec-55: Union Operation in Relational Algebra | Database Management System7m
- 56Lec-56: Division Operation in Relational Algebra | Database Management System15m
- 57Lec-57: Rename Operator in Relational Algebra | Database Management System (DBMS)13m
Day 13 · 57m
- 58Lec-58: Tuple Calculus in DBMS with examples16m
- 59Lec-59: Introduction to Structured Query Language | All Points regarding its Features and Syllabus12m
- 60Lec-60: All Types of SQL Commands with Example | DDL, DML, DCL, TCL and CONSTRAINTS | DBMS11m
- 61Lec-61: Create table in SQL with execution | SQL for Beginners | Oracle LIVE7m
- 62Lec-62: CREATE Command (DDL) in SQL with Implementation on ORACLE11m
Day 14 · 52m
- 63Lec-63: ALTER Command (DDL) in SQL with Implementation on ORACLE13m
- 64Lec-64: Difference between Alter and Update in SQL with examples in Hindi | DBMS8m
- 65Lec-65: Difference between Delete, Drop & Truncate in SQL | DBMS10m
- 66Lec-66: Constraints in SQL in Hindi | DBMS12m
- 67Lec-67: SQL Queries and Subqueries (part-1) | Database Management System9m
Week 3Videos 68–104 · 6h 24m
Day 15 · 54m
- 68Lec-68: SQL Queries and Subqueries (part-2) | 2nd Highest Salary | Nested Queries | DBMS12m
- 69Lec-69: SQL Queries and Subqueries (part-3) | Group By clause | Database Management System9m
- 70Lec-70: WITH Clause in SQL | SQL CTE (Common Table Expression) | DBMS10m
- 71Lec-71: SQL Queries and Subqueries (part-4) | Having clause | Database Management System11m
- 72Lec-72: SQL Queries and Subqueries (part-5) | Database Management System12m
Day 16 · 58m
- 73Lec-73: SQL Queries and Subqueries (part-6)| use of IN and Not IN | Database Management System9m
- 74Lec-74: SQL Queries and Subqueries (part-7)| use of IN and Not IN in Subquery | DBMS10m
- 75Lec-75: EXIST and NOT EXIST Subqueries(part-8) | Database Management System14m
- 76Lec-76: Like Command in SQL with example in Hindi | Learn SQL in Easiest Way| DBMS11m
- 77Lec-77: SEQUENCE in SQL with Syntax & Examples7m
- 78Lec-78: How SQL Query executes?? Order of SQL Query Execution⏳🔄7m
Day 17 · 49m
- 79Lec-79: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions | DBMS11m
- 80Lec-80: How Aggregate Functions work on NULL Values | SQL | DBMS7m
- 81Lec-81: Correlated Subquery in SQL with Example | Imp for Placements, GATE, NET & SQL certification12m
- 82Lec-82: Non Correlated Subquery in SQL | Imp for Placements, GATE, NET & SQL certification18m
Day 18 · 58m
- 83Lec-83: Difference between Joins, Nested Subquery and Correlated Subquery | Most Imp Concept of SQL16m
- 84Lec-84: Find Nth(1st,2nd,3rd....N) Highest Salary in SQL | Imp for Competitive & Placement exam13m
- 85Lec-85: 3 Imp Questions on SQL basic Concepts | DBMS10m
- 86Lec-86: Introduction to PL-SQL in DBMS6m
- 87Lec-87: Introduction to Transaction Concurrency in HINDI | Database Management System13m
Day 19 · 58m
- 88Lec-88: ACID Properties of a Transaction | Database Management System14m
- 89Lec-89: Transaction States | Database Management System12m
- 90Lec-90: What is Schedule | Serial Vs Parallel Schedule | Database Management System11m
- 91Lec-91: All Concurrency Problems | Dirty Read | Incorrect Summary | Lost Update | Phantom Read5m
- 92Lec-92: Write-Read Conflict or Dirty Read Problem | Database Management System8m
- 93Lec-93: Read-Write Conflict or Unrepeatable Read Problem | Database Management System8m
Day 20 · 58m
- 94Lec-94: Irrecoverable Vs Recoverable Schedules in Transactions | DBMS6m
- 95Lec-95: Cascading vs Cascadeless Schedule with Example | Recoverability | DBMS12m
- 96Lec-96: Introduction to Serializability | Transactions Concurrency and Control | DBMS9m
- 97Lec-97: Conflict Equivalent Schedules with Example | Transaction concurrency and Control | DBMS7m
- 98Lec-98: Conflict Serializability | Precedence Graph | Transaction | DBMS12m
- 99Lec-99: Why View Serializability is Used | Introduction to View Serializability | DBMS11m
Day 21 · 50m
- 100Lec-100:Shared Exclusive Locking Protocol with Example | Concurrency Control | DBMS | Part-17m
- 101Lec-101: Drawbacks in Shared/Exclusive Locking Protocol with Example | Concurrency Control Part-211m
- 102Lec-102: 2 Phase Locking(2PL) Protocol in Transaction Concurrency Control | DBMS10m
- 103Lec-103: Drawbacks in 2 Phase Locking(2PL) Protocol with examples | Concurrency Control | DBMS11m
- 104Lec-104: Strict 2PL, Rigorous 2PL and Conservative 2PLSchedule | 2 Phase Locking in DBMS12m
Week 4Videos 105–140 · 6h 8m
Day 22 · 51m
- 105Lec-105: Basic Timestamp Ordering Protocol with Example in Hindi | Concurrency Control | DBMS15m
- 106Lec-106: How to Solve Question on Timestamp Ordering Protocol | Concurrency Control | DBMS13m
- 107Lec-107: Why Indexing is used | Indexing Beginning | DBMS10m
- 108Lec-108: Numerical Example on I/O Cost in Indexing | Part-1 | DBMS12m
Day 23 · 54m
- 109Lec-109: Numerical Example on I/O Cost in Indexing | Part 2 | DBMS12m
- 110Lec-110: Types Of Indexes | Most Important Video on Indexing5m
- 111Lec-111: Primary Index With Example | GATE, PSU and UGC NET | DBMS8m
- 112Lec-112: Clustered Index in Database with Example7m
- 113Lec-113: Secondary Index in Database with Example | Multilevel Indexing13m
- 114Lec-114: Introduction to B-Tree and its Structure | Block Pointer, Record Pointer, Key10m
Day 24 · 55m
- 115Lec-115: Insertion in B-Tree with example in Hindi13m
- 116Lec-116: How to find Order of B-Tree | Imp Question on B-Tree11m
- 117Lec-117: Difference b/w B-Tree & B+Tree in Hindi with examples15m
- 118Lec-118: Order of B+ Tree | Order of Leaf Node & Non Leaf Node in B+Tree10m
- 119Lec-119: Immediate Database Modification in DBMS | Log Based Recovery Methods6m
Day 25 · 55m
- 120Lec-120: Deferred Database Modification in DBMS | Log Based Recovery | Imp for UGC NET and KVS11m
- 121Lec-121: Basic PL-SQL Programming With Execution | Part-18m
- 122Lec-122: Basic PL-SQL Programming(While, For Loop) With Execution | Part-26m
- 123Lec-123: Single row and Multi row functions in SQL6m
- 124Lec-124: Character functions in SQL with execution | Oracle LIVE11m
- 125Lec-125: View in Database | Oracle, SQL Server Views | Types of Views14m
Day 26 · 51m
- 126Lec-126: What is RAID? RAID 0, RAID 1, RAID 4, RAID 5, RAID 6, Nested RAID 10 Explained15m
- 127Lec-127: Various objects in Database | Oracle, SQL Server6m
- 128Lec-128: Very Imp. Questions on DBMS basic concepts and Data Modelling | DBMS11m
- 129Lec-129: 4 Imp Questions on Advance DBMS | BIG Data and Data Warehouse | DBMS10m
- 130Lec-130: Important Question on Relational Algebra | DBMS9m
Day 27 · 59m
- 131Lec-131: Codd’s 12 Rules of RDBMS with examples14m
- 132Lec-132: Top 15 SQL Interview Questions Answers | Most Important Questions for Job Interview15m
- 133Lec-133: Introduction to Hadoop🐘| What is Hadoop🐘| Hadoop Framework🖥9m
- 134Lec-134: Introduction to BIG Data in Hindi | Small Data Vs BIG Data | Real Life Examples13m
- 135Lec-135: Simple vs Complex vs Materialized Views with examples | DBMS8m
Day 28 · 42m
- 136Lec-136: Procedures in PL-SQL | Local Procedure vs Stored Procedure7m
- 137Lec-137: How to Fetch Data from Database using Procedures | PL-SQL Procedure7m
- 138Lec-138: What is Cursor in PL-SQL with example12m
- 139Lec-139: %TYPE & %ROWTYPE in PL-SQL with Examples9m
- 140Lec-140: Data Cleaning using SQL Functions with examples7m
Tips for finishing
- Normalization and serializability are the most-asked areas in GATE. Plan extra practice days for them.
- At 1 hour a day you'll finish in about a month; the planner shows exactly when.