DBMS (Database Management system) Complete Playlist
Complete Database management videos
Curated by: Gate Smashers (140 videos)
Tracks in this Playlist
- Lec-1: DBMS Syllabus for GATE, UGCNET, NIELIT, DSSSB etc.| Full DBMS for College/University Students
- Lec-2: Introduction to DBMS (Database Management System) With Real life examples | What is DBMS
- Lec-3: File System vs DBMS | Disadvantages of File System | DBMS Advantages
- Lec-4: 2 tier and 3 tier Architecture with real life examples | Database Management System
- Lec-5: What is Schema | How to define Schema | Database management system in Hindi
- Lec-6: Three Schema Architecture | Three Level of Abstraction | Database Management System
- Lec-7: What is Data Independence | Logical vs. Physical Independence | DBMS
- Lec-8: Integrity Constraints in Database with Examples
- Lec-9: What is CANDIDATE KEY and PRIMARY key | Full Concept | Most suitable examples | DBMS
- Lec-10: What is Primary Key in DBMS | Primary Key with Examples in Hindi
- Lec-11: Foreign Key in DBMS | Full Concept with examples | DBMS in Hindi
- Lec-12: Insert, Update & Delete from Foreign Key table | Referential Integrity
- Lec-13: Question on Foreign Key | ये Question Competition Exams में अक्सर पूछा गया है
- Lec-14: Foreign Key🔑 with On Delete Cascade with Execution
- Lec-15: Super key in DBMS in HINDI | ये Question Competition Exams में अक्सर पूछा गया है
- Lec-16: Introduction to ER model | ER Model क्या है
- Lec-17: Types of Attributes in ER Model | Full Concept | DBMS in Hindi
- Lec-18: One to One relationship in DBMS in Hindi
- Lec-19: One to Many Relationship in DBMS in Hindi | 1-M Relationship
- Lec-20: Many to Many Relationship in DBMS | M-N Relationship
- Lec-21:Introduction to Weak Entity Set with Example | Database Management System
- Lec-22:Question on Minimize tables in ER Model | ये Question Competition Exams में अक्सर पूछा गया है
- Lec-23: Important Question explanation on ER Model | DBMS
- Lec-24: Introduction to Normalization | Insertion, Deletion & Updation Anomaly
- Lec-25: First Normal form in DBMS in HINDI | 1st Normal form क्या होती है ?
- Lec-26: Finding Closure of Functional dependency in DBMS | Easiest & Simplest way
- Lec-27: Functional Dependency & its properties in DBMS in HINDI
- Lec-28: Second Normal Form | 2NF | Database Management System
- Lec-29: Third Normal Form in dbms with examples in Hindi | Normalization
- Lec-30: Boyce Codd Normal Form #BCNF #DBMS #Normalization with best examples
- Lec-31: BCNF Always Ensures Dependency Preserving Decomposition?? Normalization Examples
- Lec-32: Lossless and Lossy Decomposition| Fifth (5th) Normal Form | Database Management System
- Lec-33: All Normal Forms with Real life examples | 1NF 2NF 3NF BCNF 4NF 5NF | All in One
- Lec-34: Minimal Cover in DBMS With Example | Canonical cover
- Lec-35: Practice Question on Normalization | Database Management System
- Lec-36: How to find out the Normal form of a Relation | DBMS
- Lec-37: How to Solve Normalization Questions | DBMS
- Lec-38: Important Question Explanation on Normalization
- Lec-39: Important Question on Normalization (Schemas) Explanation | DBMS
- Lec-40: Cover and Equivalence of Functional Dependencies | Database Management System
- Lec-41: Dependency Preserving Decomposition in DBMS with Examples in Hindi | DBMS
- Lec-42: Dependency Preserving Decomposition in DBMS | Example 2 in Hindi
- Lec-43: Introduction to Joins and its types | Need of Joins with example | DBMS
- Lec-44: Natural Join operation with Example | Database Management System
- Lec-45: Self Join operation with Example | Database Management System
- Lec-46: Equi Join operation with Example | Database Management System
- Lec-47: Left Outer Join operation with Example | Database Management System
- Lec-48: Right Outer Join operation with Example | Database Management System
- Lec-49: Question on Inner, Left, Right & Full Outer Joins Explanation | DBMS
- Lec-50: Introduction to Relational Algebra | Database Management System
- Lec-51: Projection in Relational Algebra | Database Management System
- Lec-52: Selection in Relational Algebra | Database Management System
- Lec-53: Cross/Cartesian Product in Relational Algebra | Database Management System
- Lec-54: Set Difference in Relational Algebra | Database Management System
- Lec-55: Union Operation in Relational Algebra | Database Management System
- Lec-56: Division Operation in Relational Algebra | Database Management System
- Lec-57: Rename Operator in Relational Algebra | Database Management System (DBMS)
- Lec-58: Tuple Calculus in DBMS with examples
- Lec-59: Introduction to Structured Query Language | All Points regarding its Features and Syllabus
- Lec-60: All Types of SQL Commands with Example | DDL, DML, DCL, TCL and CONSTRAINTS | DBMS
- Lec-61: Create table in SQL with execution | SQL for Beginners | Oracle LIVE
- Lec-62: CREATE Command (DDL) in SQL with Implementation on ORACLE
- Lec-63: ALTER Command (DDL) in SQL with Implementation on ORACLE
- Lec-64: Difference between Alter and Update in SQL with examples in Hindi | DBMS
- Lec-65: Difference between Delete, Drop & Truncate in SQL | DBMS
- Lec-66: Constraints in SQL in Hindi | DBMS
- Lec-67: SQL Queries and Subqueries (part-1) | Database Management System
- Lec-68: SQL Queries and Subqueries (part-2) | 2nd Highest Salary | Nested Queries | DBMS
- Lec-69: SQL Queries and Subqueries (part-3) | Group By clause | Database Management System
- Lec-70: WITH Clause in SQL | SQL CTE (Common Table Expression) | DBMS
- Lec-71: SQL Queries and Subqueries (part-4) | Having clause | Database Management System
- Lec-72: SQL Queries and Subqueries (part-5) | Database Management System
- Lec-73: SQL Queries and Subqueries (part-6)| use of IN and Not IN | Database Management System
- Lec-74: SQL Queries and Subqueries (part-7)| use of IN and Not IN in Subquery | DBMS
- Lec-75: EXIST and NOT EXIST Subqueries(part-8) | Database Management System
- Lec-76: Like Command in SQL with example in Hindi | Learn SQL in Easiest Way| DBMS
- Lec-77: SEQUENCE in SQL with Syntax & Examples
- Lec-78: How SQL Query executes?? Order of SQL Query Execution⏳🔄
- Lec-79: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions | DBMS
- Lec-80: How Aggregate Functions work on NULL Values | SQL | DBMS
- Lec-81: Correlated Subquery in SQL with Example | Imp for Placements, GATE, NET & SQL certification
- Lec-82: Non Correlated Subquery in SQL | Imp for Placements, GATE, NET & SQL certification
- Lec-83: Difference between Joins, Nested Subquery and Correlated Subquery | Most Imp Concept of SQL
- Lec-84: Find Nth(1st,2nd,3rd....N) Highest Salary in SQL | Imp for Competitive & Placement exam
- Lec-85: 3 Imp Questions on SQL basic Concepts | DBMS
- Lec-86: Introduction to PL-SQL in DBMS
- Lec-87: Introduction to Transaction Concurrency in HINDI | Database Management System
- Lec-88: ACID Properties of a Transaction | Database Management System
- Lec-89: Transaction States | Database Management System
- Lec-90: What is Schedule | Serial Vs Parallel Schedule | Database Management System
- Lec-91: All Concurrency Problems | Dirty Read | Incorrect Summary | Lost Update | Phantom Read
- Lec-92: Write-Read Conflict or Dirty Read Problem | Database Management System
- Lec-93: Read-Write Conflict or Unrepeatable Read Problem | Database Management System
- Lec-94: Irrecoverable Vs Recoverable Schedules in Transactions | DBMS
- Lec-95: Cascading vs Cascadeless Schedule with Example | Recoverability | DBMS
- Lec-96: Introduction to Serializability | Transactions Concurrency and Control | DBMS
- Lec-97: Conflict Equivalent Schedules with Example | Transaction concurrency and Control | DBMS
- Lec-98: Conflict Serializability | Precedence Graph | Transaction | DBMS
- Lec-99: Why View Serializability is Used | Introduction to View Serializability | DBMS
- Lec-100:Shared Exclusive Locking Protocol with Example | Concurrency Control | DBMS | Part-1