Sign in to confirm you’re not a bot
This helps protect our community. Learn more
1.0 What is DBMS with Syllabus | Database Management System in Hindi
8.8KLikes
1,171,157Views
2018Sep 12
📝 Please message us on WhatsApp: https://wa.me/918000121313 💻 KnowledgeGate Website: https://www.knowledgegate.in/gate 📲 KnowledgeGate Android App: http://tiny.cc/KG_Official_App ➡ Do not miss our Bestseller Courses: 🔴 GATE Guidance-2025: https://www.knowledgegate.in/learn/GA... 🟠 GATE Guidance-2026: https://www.knowledgegate.in/learn/GA... ➡ Contact Us: 🟩 Whatsapp Chat: https://wa.me/918595120657 📞Call on: +91-8000121313 🟦 Telegram Updates: https://t.me/kg_gate 🟩 Whatsapp Updates: https://www.whatsapp.com/channel/0029... 📧 Email: contact@knowledgegate.in ➡ Our One Shot Semester Exam Videos: 👇 ▶ Operating System:    • Complete Operating System in one shot...   ▶ DBMS:    • Complete DBMS Data Base Management Sy...   ▶ Computer Network:    • Complete CN Computer Networks in one ...   ▶ Digital Electronics:    • Complete DE Digital Electronics in on...   ▶ Computer Architecture:    • Complete COA Computer Organization & ...   ▶ Data Structure:    • Complete DS Data Structure in one sho...   ▶ Algorithm:    • Complete DAA Design and Analysis of A...   ▶ Software Engineering:    • Complete Software Engineering in one ...   ▶ Theory of Computation:    • Complete TOC Theory of Computation in...   ▶ Compiler:    • Complete CD Compiler Design in one sh...   ▶ Discrete Maths:    • Complete DM Discrete Maths in one sho...   ➡ Free Subject-Wise Complete PlayList: 👇 ▶️ DBMS: http://tiny.cc/kg_yt_DBMS ▶️ Operating System: http://tiny.cc/kg_yt_OS ▶️ TOC|Automata: http://tiny.cc/kg_yt_toc ▶️ Computer Networks: http://tiny.cc/kg_yt_CN ▶️ Digital Electronics: http://tiny.cc/kg_yt_Digital ▶️ Compiler Design: http://tiny.cc/kg_yt_Compiler ▶️ Computer Architecture: http://tiny.cc/kg_yt_COA ▶️ Data Structure: http://tiny.cc/kg_yt_DataStructures ▶️ Algorithms: http://tiny.cc/kg_yt_Algorithm ▶️ Set, Relation, Function: http://tiny.cc/kg_yt_Discrete_Relations ▶️ Graph Theory: http://tiny.cc/kg_yt_graphtheory ▶️ Group Theory: http://tiny.cc/kg_yt_grouptheory ▶️ Proposition: http://tiny.cc/kg_yt_prepositions #knowledgegate #GATE #sanchitjain *********************************************************

KnowledgeGATE by Sanchit Sir

768K subscribers
3.1- All about Gate Exam & PSU
by KnowledgeGATE by Sanchit Sir

1.1 DBMS In Hindi (Complete Playlist)

1

Complete DBMS Data Base Management System in one shot | Semester Exam | Hindi

KnowledgeGATE by Sanchit Sir
2

Data Base Management System | DBMS in one shot | Complete GATE Course | Hindi #withsanchitsir

KnowledgeGATE by Sanchit Sir
3

GATE 2026 CSE Batch Lauch | 2 Feb, 2025 | 8:00pm | #knowledgegate #withsanchitsir

KnowledgeGATE by Sanchit Sir

1.0 What is DBMS with Syllabus | Database Management System in Hindi

KnowledgeGATE by Sanchit Sir
5

1.1 Difference between Data, Information, DB and DBMS

KnowledgeGATE by Sanchit Sir
6

1.2 Disadvantages Of File Processing System

KnowledgeGATE by Sanchit Sir
7

1.3 OLAP Vs OLTP

KnowledgeGATE by Sanchit Sir
8

2.1 ER Diagram

KnowledgeGATE by Sanchit Sir
9

2.2 Entity, Types of Entity and Entity Sets

KnowledgeGATE by Sanchit Sir
10

2.3 Types of Attributes-Simple Composite Single Valued MultiValued Stored Derived

KnowledgeGATE by Sanchit Sir
11

2.4 Relationship in an ER Diagram

KnowledgeGATE by Sanchit Sir
12

2.5 Degree of a Relationship in a ER Diagram

KnowledgeGATE by Sanchit Sir
13

2.6 Mapping Cardinalities and Cardinality Ratio in ER diagram

KnowledgeGATE by Sanchit Sir
14

2.7 Participation Constraints in ER Diagram

KnowledgeGATE by Sanchit Sir
15

3.1 Functional Dependency in DBMS | Functional Dependency explained

KnowledgeGATE by Sanchit Sir
16

3.2 Functional Dependency Questions Part-1

KnowledgeGATE by Sanchit Sir
17

3.3 Functional Dependency Questions Part-2

KnowledgeGATE by Sanchit Sir
18

3.4 Armstrong's Axioms and Inference Rules in Functional Dependency

KnowledgeGATE by Sanchit Sir
19

3.5 Closure Set Of Attributes With Examples

KnowledgeGATE by Sanchit Sir
20

3.6 Equivalence Of Functional Dependencies

KnowledgeGATE by Sanchit Sir
21

3.7 Equivalence Of Functional Dependencies Examples

KnowledgeGATE by Sanchit Sir
22

3.8 Minimal Cover or Canonical Cover or Irreducible set of Functional Dependencies

KnowledgeGATE by Sanchit Sir
23

3.9 Practice questions on Minimal Cover or Canonical Cover or Irreducible set

KnowledgeGATE by Sanchit Sir
24

3.10 Keys In DBMS

KnowledgeGATE by Sanchit Sir
25

3.11 Super Key, Candidate Key and Primary Key

KnowledgeGATE by Sanchit Sir
26

3.12 Finding Number Of Candidate Key

KnowledgeGATE by Sanchit Sir
27

3.13 Finding Number Of Candidate Key Examples

KnowledgeGATE by Sanchit Sir
28

4.1 Insertion Deletion and Updation Anomalies, Data Redundancy Inconsistency in DBMS

KnowledgeGATE by Sanchit Sir
29

4.2 Basic Concept of Normalization

KnowledgeGATE by Sanchit Sir
30

4.3 Normalization in DBMS

KnowledgeGATE by Sanchit Sir
31

4.4 First Normal Form

KnowledgeGATE by Sanchit Sir
32

4.5 Second Normal Form 2NF

KnowledgeGATE by Sanchit Sir
33

4.6 Reason For Second Normal Form 2NF

KnowledgeGATE by Sanchit Sir
34

4.7 How to Decompose a relation into 2NF

KnowledgeGATE by Sanchit Sir
35

4.8 Third Normal Form 3 NF

KnowledgeGATE by Sanchit Sir
36

4.9 3NF Third Normal Form

KnowledgeGATE by Sanchit Sir
37

4.10 Decomposition into 3NF Third Normal Form

KnowledgeGATE by Sanchit Sir
38

4.11 BCNF Boyce Codd Normal Form

KnowledgeGATE by Sanchit Sir
39

4.12 How To Identify BCNF Boyce Codd Normal Form

KnowledgeGATE by Sanchit Sir
40

4.13 How to Identify Normal Form Practice Question Part-1

KnowledgeGATE by Sanchit Sir
41

4.14 How to Identify Normal Form Practice Question Part-2

KnowledgeGATE by Sanchit Sir
42

4.15 How to Identify Normal Form Practice Question Part-3

KnowledgeGATE by Sanchit Sir
43

4.16 Lossless Join Decomposition in DBMS in HINDI Part-1

KnowledgeGATE by Sanchit Sir
44

4.17 Example Practice Problem of Lossless Join Decomposition Part-2

KnowledgeGATE by Sanchit Sir
45

4.18 Dependency Preserving Decomposition in DBMS in Hindi

KnowledgeGATE by Sanchit Sir
46

4.19 How to normalize a relation table | DBMS |

KnowledgeGATE by Sanchit Sir
47

5.1 Introduction to File Structure in DBMS

KnowledgeGATE by Sanchit Sir
48

5.2 Sorted Unsorted File Structure Spanned Unspanned Mapping in DBMS

KnowledgeGATE by Sanchit Sir
49

5.3 Introduction to Indexing in DBMS

KnowledgeGATE by Sanchit Sir
50

5.4 Types of Indexing in DBMS | Primary | Clustered | Secondary | Sparse | Dense

KnowledgeGATE by Sanchit Sir
51

5.5 Primary Indexing In DBMS In HINDI Part-1

KnowledgeGATE by Sanchit Sir
52

5.6 Numerical on Primary Indexing In DBMS In HINDI Part-2

KnowledgeGATE by Sanchit Sir
53

5.7 Clustering Index in DBMS in HINDI

KnowledgeGATE by Sanchit Sir
54

5.8 Secondary Index in DBMS in HINDI

KnowledgeGATE by Sanchit Sir
55

5.9 Numerical on Secondary Index in DBMS HINDI

KnowledgeGATE by Sanchit Sir
56

5.10 Primary Vs Secondary Index in DBMS HINDI

KnowledgeGATE by Sanchit Sir
57

6.1 Query language Procedural Vs Non-Procedural in DBMS

KnowledgeGATE by Sanchit Sir
58

6.2 Introduction To Relational Algebra in DBMS in Hindi

KnowledgeGATE by Sanchit Sir
59

6.3 Select (Sigma) Operation in DBMS in hindi Part-1

KnowledgeGATE by Sanchit Sir
60

6.4 Select (Sigma) Operation in DBMS in hindi Part-2

KnowledgeGATE by Sanchit Sir
61

6.5 Project operation in DBMS in hindi

KnowledgeGATE by Sanchit Sir
62

6.6 select and project operation in relational algebra examples in hindi

KnowledgeGATE by Sanchit Sir
63

6.7 Union Intersection and Set Difference Operator Relational Algebra in DBMS

KnowledgeGATE by Sanchit Sir
64

6.8 Cartesian Product or Cross Product Operator in Relational Algebra in DBMS in HINDI

KnowledgeGATE by Sanchit Sir
65

6.9 Practice problems on Cartesian Product or Cross Product Operator in DBMS in HINDI

KnowledgeGATE by Sanchit Sir
66

7.1 Introductionto to SQL in DBMS

KnowledgeGATE by Sanchit Sir
67

7.2 Basics Structure of SQL Query

KnowledgeGATE by Sanchit Sir
68

7.3 Select Operation in SQL Query in hindi

KnowledgeGATE by Sanchit Sir
69

7.4 Select clause with where clause in sql in hindi select from where in sql in hindi

KnowledgeGATE by Sanchit Sir
70

7.5 Set Operation in SQL Query Union Intersection Except Minus Set Difference in hindi

KnowledgeGATE by Sanchit Sir
71

7.6 Cartersian Product in SQL Query in DBMS

KnowledgeGATE by Sanchit Sir
72

7.7 Natural Join in SQL in DBMS in HINDI

KnowledgeGATE by Sanchit Sir
73

7.8 Join or Inner Join in SQL in HINDI With Example Part-1

KnowledgeGATE by Sanchit Sir
74

7.9 Join or Inner Join in SQL in HINDI With Example Part-2

KnowledgeGATE by Sanchit Sir
75

7.10 Outer Join Full Outer Join Left Outer Join Right Outer Join Complete Outer Join in SQL

KnowledgeGATE by Sanchit Sir
76

7.11 Rename Operation in SQL in HINDI With Example

KnowledgeGATE by Sanchit Sir
77

7.12 String Operation in SQL in Hindi With Example

KnowledgeGATE by Sanchit Sir
78

7.13 Ordering of Tuples in SQL In HINDI With Example

KnowledgeGATE by Sanchit Sir
79

8.1 Introduction To Transaction and Concurrency Control in DBMS

KnowledgeGATE by Sanchit Sir
80

8.2 Basic Idea of Transaction in DBMS

KnowledgeGATE by Sanchit Sir
81

8.3 ACID Properties Of Transaction In DBMS

KnowledgeGATE by Sanchit Sir
82

8.4 Transaction States In DBMS

KnowledgeGATE by Sanchit Sir
83

8.5 Advantage of Concurrency in Transaction DBMS

KnowledgeGATE by Sanchit Sir
84

8.6 Dirty Read Problem in Transaction In DBMS

KnowledgeGATE by Sanchit Sir
85

8.7 Unrepeatable Read Problem in Transaction DBMS Part-1

KnowledgeGATE by Sanchit Sir
86

8.8 Phantom Read Problem in Transaction in DBMS

KnowledgeGATE by Sanchit Sir
87

8.9 Lost Update Problem Write Write Conflict In Transaction DBMS

KnowledgeGATE by Sanchit Sir
88

8.10 Serial Schedule and Non Serial Schedule in Transaction DBMS

KnowledgeGATE by Sanchit Sir
89

8.11 Conflict Serializable Schedule With Precedence Graph

KnowledgeGATE by Sanchit Sir
90

8.12 Lost Update Problem Write Write Conflict In Transaction DBMS Part-2

KnowledgeGATE by Sanchit Sir
91

8.13 Practice Questions on Conflict Serializability Part-1

KnowledgeGATE by Sanchit Sir
92

8.14 Practice Questions on Conflict Serializability Part-2

KnowledgeGATE by Sanchit Sir
93

8.15 View Serializability in DBMS

KnowledgeGATE by Sanchit Sir
94

8.16 Practice Problem on View Serializability

KnowledgeGATE by Sanchit Sir
95

8.17 Recoverable Schedule in DBMS

KnowledgeGATE by Sanchit Sir
96

8.18 Cascadeless Schedule in DBMS

KnowledgeGATE by Sanchit Sir
97

8.19 Strict Schedule in DBMS

KnowledgeGATE by Sanchit Sir
98

8.20 Concurrency Control In DBMS

KnowledgeGATE by Sanchit Sir
99

8.21 Time Stamping Protocol in DBMS Part-1

KnowledgeGATE by Sanchit Sir
100

8.22 Time Stamping Protocol in DBMS Part-2

KnowledgeGATE by Sanchit Sir
101

8.23 Properties Of Time Stamping Protocol in DBMS Part-3

KnowledgeGATE by Sanchit Sir
102

8.24 Thomas Write Rule in Time Stamping Protocol in DBMS Part-4

KnowledgeGATE by Sanchit Sir
103

8.25 Lock Based Protocol in DBMS Concurrency Control Part-1

KnowledgeGATE by Sanchit Sir
104

8.26 Properties of Lock Based Protocols in Concurrency Control Part-2

KnowledgeGATE by Sanchit Sir
105

8.27 2 Phase Locking Protocol 2PL Part-3

KnowledgeGATE by Sanchit Sir
106

8.28 Conservative 2 Phase Locking 2PL Part-4

KnowledgeGATE by Sanchit Sir
107

8.29 Rigorous 2-Phase Locking 2pl Part-5

KnowledgeGATE by Sanchit Sir
108

8.30 Strict 2 Phase Locking 2PL Part-6

KnowledgeGATE by Sanchit Sir
109

8.31 Graph Based Protocol Concurrency Control Part-1

KnowledgeGATE by Sanchit Sir
110

8.32 Tree-Graph Based Protocol Concurrency Control Part-2

KnowledgeGATE by Sanchit Sir
111

8.33 Properties Of Tree Based Protocol In DBMS Part-3

KnowledgeGATE by Sanchit Sir
112

8.34 Deadlock Handling in Transaction and Concurrency Concurrency Part-1

KnowledgeGATE by Sanchit Sir
113

8.35 Dead Lock Prevention in Transaction and Concurrency Control in DBMS Part-2

KnowledgeGATE by Sanchit Sir