Data & AI
DBMS (Database Management System) Complete Course (Gate Smashers)
Sikhami InstituteHindi
Free
Join for free- 137 video lectures (24h 51m)
- Certificate of completion
- Ask the teacher your doubts
- Watch on the web and in the Android app
About this course
Gate Smashers' full DBMS course for university exams, GATE and UGC NET: keys and ER models, normalisation, relational algebra, SQL, transactions, concurrency and indexing. Who it's for: B.Tech, BCA and MCA students and GATE or UGC NET aspirants. Explained in Hindi with English technical terms. Taught in Hindi. These are the free, official videos of the "DBMS (Database Management system) Complete Playlist" playlist from the Gate Smashers YouTube channel (youtube.com/@gatesmashers). All videos belong to Gate Smashers; Sikhami is not affiliated with Gate Smashers and simply arranges the public playlist into a course, so you can learn one lesson at a time and keep track of your progress.
What you will learn
• Keys, attributes and the ER model • Functional dependencies and normal forms with real-life examples • Relational algebra and joins • SQL queries, subqueries and correlated subqueries • Transactions, schedules, serializability and locking protocols • Indexing, recovery and PL/SQL basics • Common SQL interview questions
Course content
1 section · 137 lectures · 24h 51m
1. DBMS (Database Management system) Complete Playlist
- Lec-1: DBMS Syllabus for GATE, UGCNET, NIELIT, DSSSB etc.| Full DBMS for College/University Students18m
- Lec-2: Introduction to DBMS (Database Management System) With Real life examples | What is DBMS12m
- Lec-3: File System vs DBMS | Disadvantages of File System | DBMS Advantages13m
- Lec-4: 2 tier and 3 tier Architecture with real life examples | Database Management System12m
- Lec-5: What is Schema | How to define Schema | Database management system in Hindi4m
- Lec-6: Three Schema Architecture | Three Level of Abstraction | Database Management System15m
- Lec-7: What is Data Independence | Logical vs. Physical Independence | DBMS10m
- Lec-8: Integrity Constraints in Database with Examples7m
- Lec-9: What is CANDIDATE KEY and PRIMARY key | Full Concept | Most suitable examples | DBMS5m
- Lec-10: What is Primary Key in DBMS | Primary Key with Examples in Hindi11m
- Lec-11: Foreign Key in DBMS | Full Concept with examples | DBMS in Hindi8m
- Lec-12: Insert, Update & Delete from Foreign Key table | Referential Integrity18m
- Lec-13: Question on Foreign Key | ये Question Competition Exams में अक्सर पूछा गया है8m
- Lec-14: Foreign Key🔑 with On Delete Cascade with Execution5m
- Lec-15: Super key in DBMS in HINDI | ये Question Competition Exams में अक्सर पूछा गया है9m
- Lec-16: Introduction to ER model | ER Model क्या है8m
- Lec-17: Types of Attributes in ER Model | Full Concept | DBMS in Hindi14m
- Lec-18: One to One relationship in DBMS in Hindi16m
- Lec-19: One to Many Relationship in DBMS in Hindi | 1-M Relationship13m
- Lec-20: Many to Many Relationship in DBMS | M-N Relationship10m
- Lec-21:Introduction to Weak Entity Set with Example | Database Management System11m
- Lec-22:Question on Minimize tables in ER Model | ये Question Competition Exams में अक्सर पूछा गया है5m
- Lec-23: Important Question explanation on ER Model | DBMS8m
- Lec-24: Introduction to Normalization | Insertion, Deletion & Updation Anomaly12m
- Lec-25: First Normal form in DBMS in HINDI | 1st Normal form क्या होती है ?8m
- Lec-26: Finding Closure of Functional dependency in DBMS | Easiest & Simplest way17m
- Lec-27: Functional Dependency & its properties in DBMS in HINDI17m
- Lec-28: Second Normal Form | 2NF | Database Management System18m
- Lec-29: Third Normal Form in dbms with examples in Hindi | Normalization16m
- Lec-30: Boyce Codd Normal Form #BCNF #DBMS #Normalization with best examples6m
- Lec-31: BCNF Always Ensures Dependency Preserving Decomposition?? Normalization Examples10m
- Lec-32: Lossless and Lossy Decomposition| Fifth (5th) Normal Form | Database Management System22m
- Lec-33: All Normal Forms with Real life examples | 1NF 2NF 3NF BCNF 4NF 5NF | All in One11m
- Lec-34: Minimal Cover in DBMS With Example | Canonical cover9m
- Lec-35: Practice Question on Normalization | Database Management System20m
- Lec-36: How to find out the Normal form of a Relation | DBMS24m
- Lec-37: How to Solve Normalization Questions | DBMS9m
- Lec-38: Important Question Explanation on Normalization19m
- Lec-39: Important Question on Normalization (Schemas) Explanation | DBMS6m
- Lec-40: Cover and Equivalence of Functional Dependencies | Database Management System13m
- Lec-41: Dependency Preserving Decomposition in DBMS with Examples in Hindi | DBMS10m
- Lec-42: Dependency Preserving Decomposition in DBMS | Example 2 in Hindi7m
- Lec-43: Introduction to Joins and its types | Need of Joins with example | DBMS10m
- Lec-44: Natural Join operation with Example | Database Management System16m
- Lec-45: Self Join operation with Example | Database Management System14m
- Lec-46: Equi Join operation with Example | Database Management System14m
- Lec-47: Left Outer Join operation with Example | Database Management System7m
- Lec-48: Right Outer Join operation with Example | Database Management System8m
- Lec-49: Question on Inner, Left, Right & Full Outer Joins Explanation | DBMS4m
- Lec-50: Introduction to Relational Algebra | Database Management System4m
- Lec-51: Projection in Relational Algebra | Database Management System6m
- Lec-52: Selection in Relational Algebra | Database Management System6m
- Lec-53: Cross/Cartesian Product in Relational Algebra | Database Management System6m
- Lec-54: Set Difference in Relational Algebra | Database Management System6m
- Lec-55: Union Operation in Relational Algebra | Database Management System7m
- Lec-56: Division Operation in Relational Algebra | Database Management System14m
- Lec-57: Rename Operator in Relational Algebra | Database Management System (DBMS)13m
- Lec-58: Tuple Calculus in DBMS with examples16m
- Lec-59: Introduction to Structured Query Language | All Points regarding its Features and Syllabus12m
- Lec-60: All Types of SQL Commands with Example | DDL, DML, DCL, TCL and CONSTRAINTS | DBMS10m
- Lec-61: Create table in SQL with execution | SQL for Beginners | Oracle LIVE7m
- Lec-62: CREATE Command (DDL) in SQL with Implementation on ORACLE10m
- Lec-63: ALTER Command (DDL) in SQL with Implementation on ORACLE13m
- Lec-64: Difference between Alter and Update in SQL with examples in Hindi | DBMS8m
- Lec-65: Difference between Delete, Drop & Truncate in SQL | DBMS10m
- Lec-66: Constraints in SQL in Hindi | DBMS12m
- Lec-67: SQL Queries and Subqueries (part-1) | Database Management System8m
- Lec-68: SQL Queries and Subqueries (part-2) | 2nd Highest Salary | Nested Queries | DBMS12m
- Lec-69: SQL Queries and Subqueries (part-3) | Group By clause | Database Management System9m
- Lec-70: WITH Clause in SQL | SQL CTE (Common Table Expression) | DBMS9m
- Lec-71: SQL Queries and Subqueries (part-4) | Having clause | Database Management System11m
- Lec-72: SQL Queries and Subqueries (part-5) | Database Management System11m
- Lec-73: SQL Queries and Subqueries (part-6)| use of IN and Not IN | Database Management System9m
- Lec-74: SQL Queries and Subqueries (part-7)| use of IN and Not IN in Subquery | DBMS9m
- Lec-75: EXIST and NOT EXIST Subqueries(part-8) | Database Management System14m
- Lec-76: Like Command in SQL with example in Hindi | Learn SQL in Easiest Way| DBMS10m
- Lec-77: SEQUENCE in SQL with Syntax & Examples7m
- Lec-78: How SQL Query executes?? Order of SQL Query Execution⏳🔄7m
- Lec-79: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions | DBMS11m
- Lec-80: How Aggregate Functions work on NULL Values | SQL | DBMS7m
- Lec-81: Correlated Subquery in SQL with Example | Imp for Placements, GATE, NET & SQL certification11m
- Lec-82: Non Correlated Subquery in SQL | Imp for Placements, GATE, NET & SQL certification18m
- Lec-83: Difference between Joins, Nested Subquery and Correlated Subquery | Most Imp Concept of SQL15m
- Lec-84: Find Nth(1st,2nd,3rd....N) Highest Salary in SQL | Imp for Competitive & Placement exam12m
- Lec-85: 3 Imp Questions on SQL basic Concepts | DBMS9m
- Lec-86: Introduction to PL-SQL in DBMS6m
- Lec-87: Introduction to Transaction Concurrency in HINDI | Database Management System12m
- Lec-88: ACID Properties of a Transaction | Database Management System13m
- Lec-89: Transaction States | Database Management System11m
- Lec-90: What is Schedule | Serial Vs Parallel Schedule | Database Management System10m
- Lec-91: All Concurrency Problems | Dirty Read | Incorrect Summary | Lost Update | Phantom Read4m
- Lec-92: Write-Read Conflict or Dirty Read Problem | Database Management System8m
- Lec-93: Read-Write Conflict or Unrepeatable Read Problem | Database Management System7m
- Lec-94: Irrecoverable Vs Recoverable Schedules in Transactions | DBMS6m
- Lec-95: Cascading vs Cascadeless Schedule with Example | Recoverability | DBMS11m
- Lec-96: Introduction to Serializability | Transactions Concurrency and Control | DBMS9m
- Lec-97: Conflict Equivalent Schedules with Example | Transaction concurrency and Control | DBMS7m
- Lec-98: Conflict Serializability | Precedence Graph | Transaction | DBMS12m
- Lec-99: Why View Serializability is Used | Introduction to View Serializability | DBMS11m
- Lec-100:Shared Exclusive Locking Protocol with Example | Concurrency Control | DBMS | Part-16m
- Lec-101: Drawbacks in Shared/Exclusive Locking Protocol with Example | Concurrency Control Part-210m
- Lec-102: 2 Phase Locking(2PL) Protocol in Transaction Concurrency Control | DBMS9m
- Lec-103: Drawbacks in 2 Phase Locking(2PL) Protocol with examples | Concurrency Control | DBMS10m
- Lec-104: Strict 2PL, Rigorous 2PL and Conservative 2PLSchedule | 2 Phase Locking in DBMS11m
- Lec-105: Basic Timestamp Ordering Protocol with Example in Hindi | Concurrency Control | DBMS15m
- Lec-106: How to Solve Question on Timestamp Ordering Protocol | Concurrency Control | DBMS12m
- Lec-107: Why Indexing is used | Indexing Beginning | DBMS10m
- Lec-108: Numerical Example on I/O Cost in Indexing | Part-1 | DBMS12m
- Lec-109: Numerical Example on I/O Cost in Indexing | Part 2 | DBMS11m
- Lec-110: Types Of Indexes | Most Important Video on Indexing4m
- Lec-111: Primary Index With Example | GATE, PSU and UGC NET | DBMS7m
- Lec-112: Clustered Index in Database with Example6m
- Lec-113: Secondary Index in Database with Example | Multilevel Indexing13m
- Lec-114: Introduction to B-Tree and its Structure | Block Pointer, Record Pointer, Key10m
- Lec-115: Insertion in B-Tree with example in Hindi12m
- Lec-116: How to find Order of B-Tree | Imp Question on B-Tree11m
- Lec-117: Difference b/w B-Tree & B+Tree in Hindi with examples14m
- Lec-118: Order of B+ Tree | Order of Leaf Node & Non Leaf Node in B+Tree10m
- Lec-119: Immediate Database Modification in DBMS | Log Based Recovery Methods6m
- Lec-120: Deferred Database Modification in DBMS | Log Based Recovery | Imp for UGC NET and KVS10m
- Lec-122: Basic PL-SQL Programming(While, For Loop) With Execution | Part-26m
- Lec-125: View in Database | Oracle, SQL Server Views | Types of Views13m
- Lec-126: What is RAID? RAID 0, RAID 1, RAID 4, RAID 5, RAID 6, Nested RAID 10 Explained14m
- Lec-127: Various objects in Database | Oracle, SQL Server6m
- Lec-128: Very Imp. Questions on DBMS basic concepts and Data Modelling | DBMS10m
- Lec-129: 4 Imp Questions on Advance DBMS | BIG Data and Data Warehouse | DBMS10m
- Lec-130: Important Question on Relational Algebra | DBMS8m
- Lec-131: Codd’s 12 Rules of RDBMS with examples13m
- Lec-132: Top 15 SQL Interview Questions Answers | Most Important Questions for Job Interview15m
- Lec-133: Introduction to Hadoop🐘| What is Hadoop🐘| Hadoop Framework🖥9m
- Lec-134: Introduction to BIG Data in Hindi | Small Data Vs BIG Data | Real Life Examples12m
- Lec-135: Simple vs Complex vs Materialized Views with examples | DBMS7m
- Lec-136: Procedures in PL-SQL | Local Procedure vs Stored Procedure7m
- Lec-137: How to Fetch Data from Database using Procedures | PL-SQL Procedure7m
- Lec-138: What is Cursor in PL-SQL with example12m
- Lec-139: %TYPE & %ROWTYPE in PL-SQL with Examples8m
- Lec-140: Data Cleaning using SQL Functions with examples7m