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