DBMS (Database Management system) Complete Playlist
135 videos • 43,670,156 views • by Gate Smashers
Complete Database management videos
1
Lec-1: DBMS Syllabus for GATE, UGCNET, NIELIT, DSSSB etc.| Full DBMS for College/University Students
Gate Smashers
Download
2
Lec-2: Introduction to DBMS (Database Management System) With Real life examples | What is DBMS
Gate Smashers
Download
3
Lec-3: File System vs DBMS | Disadvantages of File System | DBMS Advantages
Gate Smashers
Download
4
Lec-4: 2 tier and 3 tier Architecture with real life examples | Database Management System
Gate Smashers
Download
5
Lec-5: What is Schema | How to define Schema | Database management system in Hindi
Gate Smashers
Download
6
Lec-6: Three Schema Architecture | Three Level of Abstraction | Database Management System
Gate Smashers
Download
7
Lec-7: What is Data Independence | Logical vs. Physical Independence | DBMS
Gate Smashers
Download
8
Lec-8.0: Integrity Constraints in Database with Examples
Gate Smashers
Download
9
Lec-8: What is CANDIDATE KEY and PRIMARY key | Full Concept | Most suitable examples | DBMS
Gate Smashers
Download
10
Lec-9: What is Primary Key in DBMS | Primary Key with Examples in Hindi
Gate Smashers
Download
11
Lec-10: Foreign Key in DBMS | Full Concept with examples | DBMS in Hindi
Gate Smashers
Download
12
Lec-11: Insert, Update & Delete from Foreign Key table | Referential Integrity
Gate Smashers
Download
13
Lec-12: Question on Foreign Key | ये Question Competition Exams में अक्सर पूछा गया है
Gate Smashers
Download
14
Lec-13: Super key in DBMS in HINDI | ये Question Competition Exams में अक्सर पूछा गया है
Gate Smashers
Download
15
Lec-14: Introduction to ER model | ER Model क्या है
Gate Smashers
Download
16
Lec-15: Types of Attributes in ER Model | Full Concept | DBMS in Hindi
Gate Smashers
Download
17
Lec-16: One to One relationship in DBMS in Hindi
Gate Smashers
Download
18
Lec-17: One to Many Relationship in DBMS in Hindi | 1-M Relationship
Gate Smashers
Download
19
Lec-18: Many to Many Relationship in DBMS | M-N Relationship
Gate Smashers
Download
20
Lec-19:Question on Minimize tables in ER Model | ये Question Competition Exams में अक्सर पूछा गया है
Gate Smashers
Download
21
Lec-20: Introduction to Normalization | Insertion, Deletion & Updation Anomaly
Gate Smashers
Download
22
Lec-21: First Normal form in DBMS in HINDI | 1st Normal form क्या होती है ?
Gate Smashers
Download
23
Lec-22: Finding Closure of Functional dependency in DBMS | Easiest & Simplest way
Gate Smashers
Download
24
Lec-23: Functional Dependency & its properties in DBMS in HINDI
Gate Smashers
Download
25
Lec-24: Second Normal Form | 2NF | Database Management System
Gate Smashers
Download
26
Lec-25: Third Normal Form in dbms with examples in Hindi | Normalization
Gate Smashers
Download
27
Lec-26: Boyce Codd Normal Form #BCNF #DBMS #Normalization with best examples
Gate Smashers
Download
28
Lec-27: BCNF Always Ensures Dependency Preserving Decomposition?? Normalization Examples
Gate Smashers
Download
29
Lec-28: Lossless and Lossy Decomposition| Fifth (5th) Normal Form | Database Management System
Gate Smashers
Download
30
Lec-29: All Normal Forms with Real life examples | 1NF 2NF 3NF BCNF 4NF 5NF | All in One
Gate Smashers
Download
31
Lec-30: Minimal Cover in DBMS With Example | Canonical cover
Gate Smashers
Download
32
Lec-31: Practice Question on Normalization | Database Management System
Gate Smashers
Download
33
Lec-32: How to find out the Normal form of a Relation | DBMS
Gate Smashers
Download
34
Lec-33: How to Solve Normalization Questions | DBMS
Gate Smashers
Download
35
Lec-34: Important Question Explanation on Normalization
Gate Smashers
Download
36
Lec-35: Cover and Equivalence of Functional Dependencies | Database Management System
Gate Smashers
Download
37
Lec-36: Dependency Preserving Decomposition in DBMS with Examples in Hindi | DBMS
Gate Smashers
Download
38
Lec-37: Dependency Preserving Decomposition in DBMS | Example 2 in Hindi
Gate Smashers
Download
39
Lec-38: Introduction to Joins and its types | Need of Joins with example | DBMS
Gate Smashers
Download
40
Lec-39: Natural Join operation with Example | Database Management System
Gate Smashers
Download
41
Lec-40: Self Join operation with Example | Database Management System
Gate Smashers
Download
42
Lec-41: Equi Join operation with Example | Database Management System
Gate Smashers
Download
43
Lec-42: Left Outer Join operation with Example | Database Management System
Gate Smashers
Download
44
Lec-43: Right Outer Join operation with Example | Database Management System
Gate Smashers
Download
45
Lec-44: Introduction to Relational Algebra | Database Management System
Gate Smashers
Download
46
Lec-45: Projection in Relational Algebra | Database Management System
Gate Smashers
Download
47
Lec-46: Selection in Relational Algebra | Database Management System
Gate Smashers
Download
48
Lec-47: Cross/Cartesian Product in Relational Algebra | Database Management System
Gate Smashers
Download
49
Lec-48: Set Difference in Relational Algebra | Database Management System
Gate Smashers
Download
50
Lec-49: Union Operation in Relational Algebra | Database Management System
Gate Smashers
Download
51
Lec-50: Division Operation in Relational Algebra | Database Management System
Gate Smashers
Download
52
Lec-51: Tuple Calculus in DBMS with examples
Gate Smashers
Download
53
Lec-52: Introduction to Structured Query Language | All Points regarding its Features and Syllabus
Gate Smashers
Download
54
Lec-53: All Types of SQL Commands with Example | DDL, DML, DCL, TCL and CONSTRAINTS | DBMS
Gate Smashers
Download
55
Lec-54: Create table in SQL with execution | SQL for Beginners | Oracle LIVE
Gate Smashers
Download
56
Lec-55: ALTER Command (DDL) in SQL with Implementation on ORACLE
Gate Smashers
Download
57
Lec-56: Difference between Alter and Update in SQL with examples in Hindi | DBMS
Gate Smashers
Download
58
Lec-57 Difference between Delete, Drop & Truncate in SQL | DBMS
Gate Smashers
Download
59
Lec-58: Constraints in SQL in Hindi | DBMS
Gate Smashers
Download
60
Lec-59: SQL Queries and Subqueries (part-1) | Database Management System
Gate Smashers
Download
61
Lec-60: SQL Queries and Subqueries (part-2) | 2nd Highest Salary | Nested Queries | DBMS
Gate Smashers
Download
62
Lec-61: SQL Queries and Subqueries (part-3) | Group By clause | Database Management System
Gate Smashers
Download
63
Lec-62: SQL Queries and Subqueries (part-4) | Having clause | Database Management System
Gate Smashers
Download
64
Lec-63: SQL Queries and Subqueries (part-5) | Database Management System
Gate Smashers
Download
65
Lec-64: SQL Queries and Subqueries (part-6)| use of IN and Not IN | Database Management System
Gate Smashers
Download
66
Lec-65: SQL Queries and Subqueries (part-7)| use of IN and Not IN in Subquery | DBMS
Gate Smashers
Download
67
Lec-66: EXIST and NOT EXIST Subqueries(part-8) | Database Management System
Gate Smashers
Download
68
Lec-67: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions | DBMS
Gate Smashers
Download
69
Lec-68: Correlated Subquery in SQL with Example | Imp for Placements, GATE, NET & SQL certification
Gate Smashers
Download
70
Lec-69: Difference between Joins, Nested Subquery and Correlated Subquery | Most Imp Concept of SQL
Gate Smashers
Download
71
Lec-70: Find Nth(1st,2nd,3rd....N) Highest Salary in SQL | Imp for Competitive & Placement exam
Gate Smashers
Download
72
Lec-71: 3 Imp Questions on SQL basic Concepts | DBMS
Gate Smashers
Download
73
Lec-72: Introduction to PL-SQL in DBMS
Gate Smashers
Download
74
Lec-73: Introduction to Transaction Concurrency in HINDI | Database Management System
Gate Smashers
Download
75
Lec-74: ACID Properties of a Transaction | Database Management System
Gate Smashers
Download
76
Lec-75: Transaction States | Database Management System
Gate Smashers
Download
77
Lec-76: What is Schedule | Serial Vs Parallel Schedule | Database Management System
Gate Smashers
Download
78
Lec-77: All Concurrency Problems | Dirty Read | Incorrect Summary | Lost Update | Phantom Read
Gate Smashers
Download
79
Lec-78: Write-Read Conflict or Dirty Read Problem | Database Management System
Gate Smashers
Download
80
Lec-79: Read-Write Conflict or Unrepeatable Read Problem | Database Management System
Gate Smashers
Download
81
Lec-80: Irrecoverable Vs Recoverable Schedules in Transactions | DBMS
Gate Smashers
Download
82
Lec-81: Cascading vs Cascadeless Schedule with Example | Recoverability | DBMS
Gate Smashers
Download
83
Lec-82: Introduction to Serializability | Transactions Concurrency and Control | DBMS
Gate Smashers
Download
84
Lec-83: Conflict Equivalent Schedules with Example | Transaction concurrency and Control | DBMS
Gate Smashers
Download
85
Lec-84: Conflict Serializability | Precedence Graph | Transaction | DBMS
Gate Smashers
Download
86
Lec-85: Why View Serializability is Used | Introduction to View Serializability | DBMS
Gate Smashers
Download
87
Lec-86:Shared Exclusive Locking Protocol with Example in Hindi | Concurrency Control | DBMS | Part-1
Gate Smashers
Download
88
Lec-87: Drawbacks in Shared/Exclusive Locking Protocol with Example | Concurrency Control Part-2
Gate Smashers
Download
89
Lec-88: 2 Phase Locking(2PL) Protocol in Transaction Concurrency Control | DBMS
Gate Smashers
Download
90
Lec-89: Drawbacks in 2 Phase Locking(2PL) Protocol with examples | Concurrency Control | DBMS
Gate Smashers
Download
91
Lec-90: Strict 2PL, Rigorous 2PL and Conservative 2PLSchedule | 2 Phase Locking in DBMS
Gate Smashers
Download
92
Lec-91: Basic Timestamp Ordering Protocol with Example in Hindi | Concurrency Control | DBMS
Gate Smashers
Download
93
Lec-92: How to Solve Question on Timestamp Ordering Protocol | Concurrency Control | DBMS
Gate Smashers
Download
94
Lec-93: Why Indexing is used | Indexing Beginning | DBMS
Gate Smashers
Download
95
Lec-94: Numerical Example on I/O Cost in Indexing | Part-1 | DBMS
Gate Smashers
Download
96
Lec-95: Numerical Example on I/O Cost in Indexing | Part 2 | DBMS
Gate Smashers
Download
97
Lec-96: Types Of Indexes | Most Important Video on Indexing
Gate Smashers
Download
98
Lec-97: Primary Index With Example | GATE, PSU and UGC NET | DBMS
Gate Smashers
Download
99
Lec-98: Clustered Index in Database with Example
Gate Smashers
Download
100
Lec-99: Secondary Index in Database with Example | Multilevel Indexing
Gate Smashers
Download
101
Lec-100: Introduction to B-Tree and its Structure | Block Pointer, Record Pointer, Key
Gate Smashers
Download
102
Lec-101: Insertion in B-Tree with example in Hindi
Gate Smashers
Download
103
Lec-102: How to find Order of B-Tree | Imp Question on B-Tree
Gate Smashers
Download
104
Lec-103: Difference b/w B-Tree & B+Tree in Hindi with examples
Gate Smashers
Download
105
Lec-104: Order of B+ Tree | Order of Leaf Node & Non Leaf Node in B+Tree
Gate Smashers
Download
106
Lec-105: Immediate Database Modification in DBMS | Log Based Recovery Methods
Gate Smashers
Download
107
Lec-106: Deferred Database Modification in DBMS | Log Based Recovery | Imp for UGC NET and KVS
Gate Smashers
Download
108
Lec-107: Like Command in SQL with example in Hindi | Learn SQL in Easiest Way| DBMS
Gate Smashers
Download
109
Lec-108: Basic PL-SQL Programming With Execution | Part-1
Gate Smashers
Download
110
Lec-109: Basic PL-SQL Programming(While, For Loop) With Execution | Part-2
Gate Smashers
Download
111
Lec-110: Single row and Multi row functions in SQL
Gate Smashers
Download
112
Lec-111: Character functions in SQL with execution | Oracle LIVE
Gate Smashers
Download
113
Lec-112: View in Database | Oracle, SQL Server Views | Types of Views
Gate Smashers
Download
114
Lec-113: How Aggregate Functions work on NULL Values | SQL | DBMS
Gate Smashers
Download
115
Lec-114: What is RAID? RAID 0, RAID 1, RAID 4, RAID 5, RAID 6, Nested RAID 10 Explained
Gate Smashers
Download
116
Lec-115: Various objects in Database | Oracle, SQL Server
Gate Smashers
Download
117
Lec-116: Important Question explanation on ER Model | DBMS
Gate Smashers
Download
118
Lec-117: Very Imp. Questions on DBMS basic concepts and Data Modelling | DBMS
Gate Smashers
Download
119
Lec-118: Question on Inner, Left, Right & Full Outer Joins Explanation | DBMS
Gate Smashers
Download
120
Lec-119: 4 Imp Questions on Advance DBMS | BIG Data and Data Warehouse | DBMS
Gate Smashers
Download
121
Lec-120: Important Question on Normalization (Schemas) Explanation | DBMS
Gate Smashers
Download
122
Lec-121: Important Question on Relational Algebra | DBMS
Gate Smashers
Download
123
Lec-122: Codd’s 12 Rules of RDBMS with examples
Gate Smashers
Download
124
Lec-123: Top 15 SQL Interview Questions Answers | Most Important Questions for Job Interview
Gate Smashers
Download
125
Lec-124: CREATE Command (DDL) in SQL with Implementation on ORACLE
Gate Smashers
Download
126
Lec-125: SEQUENCE in SQL with Syntax & Examples
Gate Smashers
Download
127
Lec-126: How SQL Query executes?? Order of SQL Query Execution⏳🔄
Gate Smashers
Download
128
Lec-127: Introduction to Hadoop🐘| What is Hadoop🐘| Hadoop Framework🖥
Gate Smashers
Download
129
Lec-128: Introduction to BIG Data in Hindi | Small Data Vs BIG Data | Real Life Examples
Gate Smashers
Download
130
Lec-129: Simple vs Complex vs Materialized Views with examples | DBMS
Gate Smashers
Download
131
Foreign Key🔑 with On Delete Cascade with Execution
Gate Smashers
Download
132
Procedures in PL-SQL | Local Procedure vs Stored Procedure
Gate Smashers
Download
133
How to Fetch Data from Database using Procedures | PL-SQL Procedure
Gate Smashers
Download
134
%TYPE & %ROWTYPE in PL-SQL with Examples
Gate Smashers
Download
135
What is Cursor in PL-SQL with example
Gate Smashers
Download