DBMS (Database Management System) (Hindi) (Part 1)

   Tuesday, May 26, 2020   

Starting a new Lecture Notes Series on DBMS (Database Management System)

Youtube Lecture Playlist Credits 

Channel Name: Gate Smashers

So Let Us Start to This Journey of Learning 

DBMS (Database Management System) By Lecture Notes together!

Lecture 1: Lec-1: DBMS Syllabus for GATE, UGCNET, NIELIT, DSSSB etc.| Full DBMS for College/University Students

Lecture 2: Lec-2: Introduction to DBMS (Database Management System) With Real life examples | What is DBMS

Lecture 3: Lec-3: File System vs DBMS | Disadvantages of File System | DBMS Advantages

Lecture 4: Lec-4: 2 tier and 3 tier Architecture with real life examples | Database Management System

Lecture 5: Lec-5: What is Schema | How to define Schema | Database management system in Hindi

Lecture 6: Lec-6: Three Schema Architecture | Three Level of Abstraction | Database Management System

Lecture 7: Lec-7: What is Data Independence | Logical vs. Physical Independence | DBMS

Lecture 8: Lec-8: Integrity Constraints in Database with Examples

Lecture 9: Lec-9: What is CANDIDATE KEY and PRIMARY key | Full Concept | Most suitable examples | DBMS

Lecture 10: Lec-10: What is Primary Key in DBMS | Primary Key with Examples in Hindi

Lecture 11: Lec-11: Foreign Key in DBMS | Full Concept with examples | DBMS in Hindi

Lecture 12: Lec-12: Insert, Update & Delete from Foreign Key table | Referential Integrity

Lecture 13: Lec-13: Question on Foreign Key | ये Question Competition Exams में अक्सर पूछा गया है

Lecture 14: Lec-14: Foreign Key🔑 with On Delete Cascade with Execution

Lecture 15: Lec-15: Super key in DBMS in HINDI | ये Question Competition Exams में अक्सर पूछा गया है

Lecture 16: Lec-16: Introduction to ER model | ER Model क्या है

Lecture 17: Lec-17: Types of Attributes in ER Model | Full Concept | DBMS in Hindi

Lecture 18: Lec-18: One to One relationship in DBMS in Hindi

Lecture 19: Lec-19: One to Many Relationship in DBMS in Hindi | 1-M Relationship

Lecture 20: Lec-20: Many to Many Relationship in DBMS | M-N Relationship

Lecture 21: Lec-21:Introduction to Weak Entity Set with Example | Database Management System

Lecture 22: Lec-22:Question on Minimize tables in ER Model | ये Question Competition Exams में अक्सर पूछा गया है

Lecture 23: Lec-23: Important Question explanation on ER Model | DBMS

Lecture 24: Lec-24: Introduction to Normalization | Insertion, Deletion & Updation Anomaly

Lecture 25: Lec-25: First Normal form in DBMS in HINDI | 1st Normal form क्या होती है ?

Lecture 26: Lec-26: Finding Closure of Functional dependency in DBMS | Easiest & Simplest way

Lecture 27: Lec-27: Functional Dependency & its properties in DBMS in HINDI

Lecture 28: Lec-28: Second Normal Form | 2NF | Database Management System

Lecture 29: Lec-29: Third Normal Form in dbms with examples in Hindi | Normalization

Lecture 30: Lec-30: Boyce Codd Normal Form #BCNF #DBMS #Normalization with best examples

Lecture 31: Lec-31: BCNF Always Ensures Dependency Preserving Decomposition?? Normalization Examples

Lecture 32: Lec-32: Lossless and Lossy Decomposition| Fifth (5th) Normal Form | Database Management System

Lecture 33: Lec-33: All Normal Forms with Real life examples | 1NF 2NF 3NF BCNF 4NF 5NF | All in One

Lecture 34: Lec-34: Minimal Cover in DBMS With Example | Canonical cover

Lecture 35: Lec-35: Practice Question on Normalization | Database Management System

Lecture 36: Lec-36: How to find out the Normal form of a Relation | DBMS

Lecture 37: Lec-37: How to Solve Normalization Questions | DBMS

Lecture 38: Lec-38: Important Question Explanation on Normalization

Lecture 39: Lec-39: Important Question on Normalization (Schemas) Explanation | DBMS

Lecture 40: Lec-40: Cover and Equivalence of Functional Dependencies | Database Management System

Lecture 41: Lec-41: Dependency Preserving Decomposition in DBMS with Examples in Hindi | DBMS

Lecture 42: Lec-42: Dependency Preserving Decomposition in DBMS | Example 2 in Hindi

Lecture 43: Lec-43: Introduction to Joins and its types | Need of Joins with example | DBMS

Lecture 44: Lec-44: Natural Join operation with Example | Database Management System

Lecture 45: Lec-45: Self Join operation with Example | Database Management System

Lecture 46: Lec-46: Equi Join operation with Example | Database Management System

Lecture 47: Lec-47: Left Outer Join operation with Example | Database Management System

Lecture 48: Lec-48: Right Outer Join operation with Example | Database Management System