Professional Knowledge (IT)

DBMS

📺 Main playlist (Gate Smashers)

📋 Syllabus topics (PDF ke order mein)

Database Models & DBMS basics 10 video
Difference between File System and RDBMS 1 video
Normalization 9 video
Keys & Constraints 7 video
Transactions & Concurrency Control Management 8 video
E-R Diagram 6 video
View and Trigger 2 video
Cursors (and Stored Procedures) 2 video
SQL Queries 16 video
Recovery & Backup 3 video
Indexing (Oliveboard: "Indexes and Sequences") 6 video
Data Dictionary → doosri file
Data Warehouse & Data Mining 3 video

🔴 Zaroor wale: 0Kul pass: 0

Free mode — lock hata do (sabhi videos khule)

Kaise chalega

Video dekho → 📝 MCQ kholo → 5 sawal karo. 3/5 sahi par ✅ pass aur agla video 🔓 unlock.
🔴 zaroor wale videos order mein khulte hain. 🟡 optional videos lock nahi karte.
Har video ke neeche uska asli YouTube title aur channel diya hai (sab URLs 30 Sep 2026 ko check kiye).

Topic 1Database Models & DBMS basics

Lec 2Introduction to DBMSYouTube: Lec-2: Introduction to DBMS (Database Management System) With Real life examples | What is DBMS — Gate Smashers▶ YouTube
Lec 42-tier & 3-tier ArchitectureYouTube: Lec-4: 2 tier and 3 tier Architecture with real life examples | Database Management System — Gate Smashers▶ YouTube
Lec 5What is SchemaYouTube: Lec-5: What is Schema | How to define Schema | Database management system in Hindi — Gate Smashers▶ YouTube
Lec 6Three Schema ArchitectureYouTube: Lec-6: Three Schema Architecture | Three Level of Abstraction | Database Management System — Gate Smashers▶ YouTube
Lec 7Data IndependenceYouTube: Lec-7: What is Data Independence | Logical vs. Physical Independence | DBMS — Gate Smashers▶ YouTube
Lec 131Codd's 12 RulesYouTube: Lec-131: Codd’s 12 Rules of RDBMS with examples — Gate Smashers▶ YouTube
Lec 128Imp Questions on DBMS basicsYouTube: Lec-128: Very Imp. Questions on DBMS basic concepts and Data Modelling | DBMS — Gate Smashers▶ YouTube
Lec 50Relational Algebra introYouTube: Lec-50: Introduction to Relational Algebra | Database Management System — Gate Smashers🟡 optional▶ YouTube
Lec 51Projection (π)YouTube: Lec-51: Projection in Relational Algebra | Database Management System — Gate Smashers🟡 optional▶ YouTube
Lec 52Selection (σ)YouTube: Lec-52: Selection in Relational Algebra | Database Management System — Gate Smashers🟡 optional▶ YouTube

Topic 2Difference between File System and RDBMS

Lec 3File System vs DBMSYouTube: Lec-3: File System vs DBMS | Disadvantages of File System | DBMS Advantages — Gate Smashers▶ YouTube

Topic 3Normalization

Lec 24Intro + AnomaliesYouTube: Lec-24: Introduction to Normalization | Insertion, Deletion & Updation Anomaly — Gate Smashers▶ YouTube
Lec 251NFYouTube: Lec-25: First Normal form in DBMS in HINDI | 1st Normal form क्या होती है ? — Gate Smashers▶ YouTube
Lec 27Functional DependencyYouTube: Lec-27: Functional Dependency & its properties in DBMS in HINDI — Gate Smashers▶ YouTube
Lec 282NFYouTube: Lec-28: Second Normal Form | 2NF | Database Management System — Gate Smashers▶ YouTube
Lec 293NFYouTube: Lec-29: Third Normal Form in dbms with examples in Hindi | Normalization — Gate Smashers▶ YouTube
Lec 30BCNFYouTube: Lec-30: Boyce Codd Normal Form #BCNF #DBMS #Normalization with best examples — Gate Smashers▶ YouTube
Lec 33All Normal Forms: real-life examples (best for revision)YouTube: Lec-33: All Normal Forms with Real life examples | 1NF 2NF 3NF BCNF 4NF 5NF | All in One — Gate Smashers▶ YouTube
Lec 26Closure of FDYouTube: Lec-26: Finding Closure of Functional dependency in DBMS | Easiest & Simplest way — Gate Smashers🟡 optional▶ YouTube
Lec 32Lossless/Lossy Decomposition, 5NFYouTube: Lec-32: Lossless and Lossy Decomposition| Fifth (5th) Normal Form | Database Management System — Gate Smashers🟡 optional▶ YouTube

Topic 4Keys & Constraints

Lec 8Integrity ConstraintsYouTube: Lec-8: Integrity Constraints in Database with Examples — Gate Smashers▶ YouTube
Lec 9Candidate Key & Primary KeyYouTube: Lec-9: What is CANDIDATE KEY and PRIMARY key | Full Concept | Most suitable examples | DBMS — Gate Smashers▶ YouTube
Lec 10Primary KeyYouTube: Lec-10: What is Primary Key in DBMS | Primary Key with Examples in Hindi — Gate Smashers▶ YouTube
Lec 11Foreign KeyYouTube: Lec-11: Foreign Key in DBMS | Full Concept with examples | DBMS in Hindi — Gate Smashers▶ YouTube
Lec 12Referential IntegrityYouTube: Lec-12: Insert, Update & Delete from Foreign Key table | Referential Integrity — Gate Smashers▶ YouTube
Lec 15Super KeyYouTube: Lec-15: Super key in DBMS in HINDI | ये Question Competition Exams में अक्सर पूछा गया है — Gate Smashers▶ YouTube
Lec 66Constraints in SQLYouTube: Lec-66: Constraints in SQL in Hindi | DBMS — Gate Smashers▶ YouTube

Topic 5Transactions & Concurrency Control Management

Lec 87Intro to TransactionsYouTube: Lec-87: Introduction to Transaction Concurrency in HINDI | Database Management System — Gate Smashers▶ YouTube
Lec 88ACID PropertiesYouTube: Lec-88: ACID Properties of a Transaction | Database Management System — Gate Smashers▶ YouTube
Lec 89Transaction StatesYouTube: Lec-89: Transaction States | Database Management System — Gate Smashers▶ YouTube
Lec 90Serial vs Parallel ScheduleYouTube: Lec-90: What is Schedule | Serial Vs Parallel Schedule | Database Management System — Gate Smashers▶ YouTube
Lec 91Concurrency Problems (Dirty Read etc.)YouTube: Lec-91: All Concurrency Problems | Dirty Read | Incorrect Summary | Lost Update | Phantom Read — Gate Smashers▶ YouTube
Lec 94Recoverable SchedulesYouTube: Lec-94: Irrecoverable Vs Recoverable Schedules in Transactions | DBMS — Gate Smashers🟡 optional▶ YouTube
Lec 100Shared/Exclusive LockingYouTube: Lec-100:Shared Exclusive Locking Protocol with Example | Concurrency Control | DBMS | Part-1 — Gate Smashers🟡 optional▶ YouTube
Lec 1022 Phase LockingYouTube: Lec-102: 2 Phase Locking(2PL) Protocol in Transaction Concurrency Control | DBMS — Gate Smashers🟡 optional▶ YouTube

Topic 6E-R Diagram

Lec 16Introduction to ER ModelYouTube: Lec-16: Introduction to ER model | ER Model क्या है — Gate Smashers▶ YouTube
Lec 17Types of AttributesYouTube: Lec-17: Types of Attributes in ER Model | Full Concept | DBMS in Hindi — Gate Smashers▶ YouTube
Lec 18One-to-One RelationshipYouTube: Lec-18: One to One relationship in DBMS in Hindi — Gate Smashers▶ YouTube
Lec 19One-to-Many RelationshipYouTube: Lec-19: One to Many Relationship in DBMS in Hindi | 1-M Relationship — Gate Smashers▶ YouTube
Lec 20Many-to-Many RelationshipYouTube: Lec-20: Many to Many Relationship in DBMS | M-N Relationship — Gate Smashers▶ YouTube
Lec 21Weak Entity SetYouTube: Lec-21:Introduction to Weak Entity Set with Example | Database Management System — Gate Smashers▶ YouTube

Topic 7View and Trigger

Lec 125ViewsYouTube: Lec-125: View in Database | Oracle, SQL Server Views | Types of Views — Gate Smashers▶ YouTube
SQL Triggers (Gate Smashers)YouTube: Sql Triggers🔫 Real Life Example | SQL Interview♟ Questions🎯 — Gate Smashers▶ YouTube

Topic 8Cursors (and Stored Procedures)

Lec 136Stored ProceduresYouTube: Lec-136: Procedures in PL-SQL | Local Procedure vs Stored Procedure — Gate Smashers▶ YouTube
Lec 138CursorYouTube: Lec-138: What is Cursor in PL-SQL with example — Gate Smashers▶ YouTube

Topic 9SQL Queries

Lec 59Introduction to SQLYouTube: Lec-59: Introduction to Structured Query Language | All Points regarding its Features and Syllabus — Gate Smashers▶ YouTube
Lec 60DDL, DML, DCL, TCL commandsYouTube: Lec-60: All Types of SQL Commands with Example | DDL, DML, DCL, TCL and CONSTRAINTS | DBMS — Gate Smashers▶ YouTube
Lec 65Delete vs Drop vs TruncateYouTube: Lec-65: Difference between Delete, Drop & Truncate in SQL | DBMS — Gate Smashers▶ YouTube
Lec 67Queries & Subqueries (Part 1)YouTube: Lec-67: SQL Queries and Subqueries (part-1) | Database Management System — Gate Smashers▶ YouTube
Lec 682nd Highest Salary, Nested QueriesYouTube: Lec-68: SQL Queries and Subqueries (part-2) | 2nd Highest Salary | Nested Queries | DBMS — Gate Smashers▶ YouTube
Lec 69GROUP BYYouTube: Lec-69: SQL Queries and Subqueries (part-3) | Group By clause | Database Management System — Gate Smashers▶ YouTube
Lec 71HAVINGYouTube: Lec-71: SQL Queries and Subqueries (part-4) | Having clause | Database Management System — Gate Smashers▶ YouTube
Lec 73IN and NOT INYouTube: Lec-73: SQL Queries and Subqueries (part-6)| use of IN and Not IN | Database Management System — Gate Smashers▶ YouTube
Lec 76LIKE commandYouTube: Lec-76: Like Command in SQL with example in Hindi | Learn SQL in Easiest Way| DBMS — Gate Smashers▶ YouTube
Lec 79Aggregate FunctionsYouTube: Lec-79: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions | DBMS — Gate Smashers▶ YouTube
Lec 84Nth Highest SalaryYouTube: Lec-84: Find Nth(1st,2nd,3rd....N) Highest Salary in SQL | Imp for Competitive & Placement exam — Gate Smashers▶ YouTube
Lec 43Intro to Joins & TypesYouTube: Lec-43: Introduction to Joins and its types | Need of Joins with example | DBMS — Gate Smashers▶ YouTube
Lec 44Natural JoinYouTube: Lec-44: Natural Join operation with Example | Database Management System — Gate Smashers▶ YouTube
Lec 45Self JoinYouTube: Lec-45: Self Join operation with Example | Database Management System — Gate Smashers▶ YouTube
Lec 47Left Outer JoinYouTube: Lec-47: Left Outer Join operation with Example | Database Management System — Gate Smashers▶ YouTube
Lec 49Inner/Left/Right/Full Join questionsYouTube: Lec-49: Question on Inner, Left, Right & Full Outer Joins Explanation | DBMS — Gate Smashers▶ YouTube

Topic 10Recovery & Backup

Lec 119Log-based Recovery (Immediate)YouTube: Lec-119: Immediate Database Modification in DBMS | Log Based Recovery Methods — Gate Smashers🟡 optional▶ YouTube
Lec 120Log-based Recovery (Deferred)YouTube: Lec-120: Deferred Database Modification in DBMS | Log Based Recovery | Imp for UGC NET and KVS — Gate Smashers🟡 optional▶ YouTube
Lec 126RAIDYouTube: Lec-126: What is RAID? RAID 0, RAID 1, RAID 4, RAID 5, RAID 6, Nested RAID 10 Explained — Gate Smashers🟡 optional▶ YouTube

Topic 11Indexing (Oliveboard: "Indexes and Sequences")

Lec 107Why IndexingYouTube: Lec-107: Why Indexing is used | Indexing Beginning | DBMS — Gate Smashers🟡 optional▶ YouTube
Lec 110Types of Indexes (important)YouTube: Lec-110: Types Of Indexes | Most Important Video on Indexing — Gate Smashers🟡 optional▶ YouTube
Lec 111Primary IndexYouTube: Lec-111: Primary Index With Example | GATE, PSU and UGC NET | DBMS — Gate Smashers🟡 optional▶ YouTube
Lec 112Clustered IndexYouTube: Lec-112: Clustered Index in Database with Example — Gate Smashers🟡 optional▶ YouTube
Lec 113Secondary IndexYouTube: Lec-113: Secondary Index in Database with Example | Multilevel Indexing — Gate Smashers🟡 optional▶ YouTube
Lec 117B-Tree vs B+TreeYouTube: Lec-117: Difference b/w B-Tree & B+Tree in Hindi with examples — Gate Smashers🟡 optional▶ YouTube

Topic 12Data Dictionary

➡️ Yahan video nahi: Alag video nahi hai. "Codd's 12 Rules" (Rule 4: online catalog) aur DBMS basics mein cover hai.

Topic 13Data Warehouse & Data Mining

Lec 129Big Data & Data Warehouse questionsYouTube: Lec-129: 4 Imp Questions on Advance DBMS | BIG Data and Data Warehouse | DBMS — Gate Smashers🟡 optional▶ YouTube
Lec 134Big Data introYouTube: Lec-134: Introduction to BIG Data in Hindi | Small Data Vs BIG Data | Real Life Examples — Gate Smashers🟡 optional▶ YouTube
Lec 133Hadoop introYouTube: Lec-133: Introduction to Hadoop🐘| What is Hadoop🐘| Hadoop Framework🖥 — Gate Smashers🟡 optional▶ YouTube

🟢 Skip kar sakte ho

Lec 34–42: minimal cover, dependency preserving decomposition
Lec 53–58: advanced relational algebra operators, tuple calculus
Lec 95–99, 103–106: serializability, precedence graph, timestamp protocol
Lec 108–109, 114–116, 118: indexing I/O cost, B-tree order and insertion
PL-SQL programming: Lec 121–124, 137, 139

📝 Notes

Practise SQL queries yourself in MySQL or an online SQL editor.

Progress isi browser mein save hota hai.