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

Name: Complete DBMS Data Base Management System in one shot | Semester Exam | Hindi
Availability: InStock

No ratings yetBEGINNERHindi

YouTube

Korshub's take

Organized by chapter

This session runs through a full DBMS syllabus in one video, with chapter timestamps for each section. It starts with data, information and database basics, then moves through the ER model and functional dependencies.

Chapters in the video

Data versus information, database types, architecture and the DBA role
ER diagrams, including generalization and aggregation
Keys, normal forms and decomposition
Indexing, relational algebra and relational calculus
SQL, transactions and schedules
Concurrency control and recovery

Who it suits

The lecture is in Hindi and framed around semester exams, so it works well as a revision pass alongside a textbook. Use the timestamps to jump straight to the topic you need.

About this course

💻 KnowledgeGate Website: https://www.knowledgegate.ai

For notes, please check out our course: https://www.knowledgegate.ai/go/kgl_000016

📝 Please message us on WhatsApp: https://wa.me/918000121313

Social Links:
📸 Instagram: https://www.instagram.com/knowledgegate.ai/
💼 LinkedIn: https://www.linkedin.com/company/knowledge-gate/

➡ Contact Us: 👇
📞Call on: +91-8000121313
🟦 Telegram Updates: https://t.me/kg_gate
🟩 Whatsapp Updates: https://www.whatsapp.com/channel/0029VaC5Weq2Jl85NaTls63w
📧 Email: contact@knowledgegate.in

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