Talk to Sanchit Sir: https://forms.gle/WCAFSzjWHsfH7nrh9
KnowledgeGate Website: https://www.knowledgegate.in/gate
KnowledgeGate Android App: http://tiny.cc/KG_Official_App

Free Notes: https://notes.knowledgegate.in/

➡ Do not miss our Bestseller Courses:
GATE Guidance2025: https://www.knowledgegate.in/learn/GA...
GATE Guidance Plus2025: https://www.knowledgegate.in/learn/GA...

➡ Contact Us:
Whatsapp Chat: https://wa.me/918595120657
Call on: +918000121313
Telegram Updates: https://t.me/kg_gate
Whatsapp Updates: https://www.whatsapp.com/channel/0029...
Email: [email protected]

➡ 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 SubjectWise 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

*********************************************************

Content in this video:
00:00 (Chapter0: Introduction) About this video

02:20 (Chapter1: Basics) Data & information, Database System vs File System, Views of Data Base, Data Independence, Instances & Schema, OLAP Vs OLTP, Types of Data Base, DBA, Architecture.

21:56 (Chapter2: ER Diagram) Entity, Attributes, Relationship, Degree of a Relationship, Mapping, Weak Entity set, Conversion from ER Diagram to Relational Model, Generalization, Specification, Aggregation.

50:08 (Chapter3: RDBMS & Functional Dependency) Basics & Properties, Update Anomalies, Purpose of Normalization, Functional Dependency, Closure Set of Attributes, Armstrong’s axioms, Equivalence of two FD, Canonical cover, Keys.

1:38:28 (Chapter4: Normalization) 1NF, 2NF, 3NF, BCNF, Multivalued Dependency, 4NF, LossyLossless Decomposition, 5NF, Dependency Preserving Decomposition.

2:19:32 (Chapter5: Indexing) Overview of indexing, Primary indexing, Clustered indexing and Secondary Indexing, BTree.

2:49:08 (Chapter 6: Relational Algebra) Query Language, Select, Project, Union, Set Difference, Cross Product, Rename Operator, Additional or Derived Operators.

3:14:00 (Chapter7: SQL) Introduction to SQL, Classification, DDL Commands, Select, Where, Set Operations, Cartesian Product, Natural Join, Outer Join, Rename, Aggregate Functions, Ordering, String, Group, having, Trigger, embedded, dynamic SQL.

4:07:54 (Chapter8: Relational Calculus) Overview, Tuple Relation Calculus, Domain Relation Calculus.

4:22:28 (Chapter9: Transaction) What is Transaction, ACID Properties, Transaction Sates, Schedule, Conflict Serializability, View Serializability, Recoverability, Cascade lessness, Strict Schedule.

5:01:02 (Chapter10: Recovery & Concurrency Control) Log Based Recovery, Shadow Paging, Data Fragmentation, TIME STAMP ORDERING PROTOCOL, THOMAS WRITE RULE, 2 phase locking, Basic 2pl, Conservative 2pl, Rigorous 2pl, Strict 2pl, Validation based protocol Multiple Granularity.