1.1 DBMS In Hindi (Complete Playlist) - Complete DBMS Data Base Management System in one shot | Semester Exam | Hindi

💻 KnowledgeGate Website: https://www.knowledgegate.ai For free notes on University exam’s subjects, please check out our course: https://knowledgegate.ai/courses/FREE-SEMESTER-EXAM-COURSE 📝 Please message us on WhatsApp: https://wa.me/918000121313 ➡ Contact Us: 👇 📞Call on: +91-8000121313 🟦 Telegram Updates: https://t.me/kg_gate 🟩 Whatsapp Updates: https://www.whatsapp.com/channel/0029VaC5Weq2Jl85NaTls63w 📧 Email: [email protected] ➡ One Shot Complete Playlist for GATE CSE Exam : 👇 ▶️ http://tiny.cc/GATEoneshotplaylist ➡ Our One Shot Semester Exam Videos: 👇 ▶ Operating System: https://youtu.be/xw_OuOhjauw ▶ DBMS: https://youtu.be/YRnjGeQbsHQ ▶ Computer Network: https://youtu.be/q3Z3Qa1UNBA ▶ Digital Electronics: https://youtu.be/pHNbm-4reIc ▶ Computer Architecture: https://youtu.be/DsK35f8wyUw ▶ Data Structure: https://youtu.be/MdG0Vw9f1A4 ▶ Algorithm: https://youtu.be/z6DY_YSdyww ▶ Software Engineering: https://youtu.be/NlLM3sVF8wY ▶ Theory of Computation: https://youtu.be/9kuynHcM3UA ▶ Compiler: https://youtu.be/OQCjakjCJu4 ▶ Discrete Maths: https://youtu.be/3zOtLEeHygg ▶ Artificial Intelligence: https://youtu.be/yiXAmkimZRQ ▶ Machine Learning: https://youtu.be/2oGsCHlfBUg #knowledgegate #sanchitsir #sanchitjain ********************************************************* Content in this video: 00:00 (Chapter-0: Introduction)- About this video 02:20 (Chapter-1: 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 (Chapter-2: 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 (Chapter-3: 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 (Chapter-4: Normalization)- 1NF, 2NF, 3NF, BCNF, Multivalued Dependency, 4NF, Lossy-Lossless Decomposition, 5NF, Dependency Preserving Decomposition. 2:19:32 (Chapter-5: Indexing)- Overview of indexing, Primary indexing, Clustered indexing and Secondary Indexing, B-Tree. 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 (Chapter-7: 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 (Chapter-8: Relational Calculus)- Overview, Tuple Relation Calculus, Domain Relation Calculus. 4:22:28 (Chapter-9: Transaction)- What is Transaction, ACID Properties, Transaction Sates, Schedule, Conflict Serializability, View Serializability, Recoverability, Cascade lessness, Strict Schedule. 5:01:02 (Chapter-10: 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.