Completed
Tuple Calculus in DBMS with examples
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
DBMS - Database Management System
Automatically move to the next video in the Classroom when playback concludes
- 1 Lec-1: DBMS Syllabus for GATE, UGCNET, NIELIT, DSSSB etc.| Full DBMS for College/University Students
- 2 Lec-2: Introduction to DBMS (Database Management System) With Real life examples | What is DBMS
- 3 Lec-3: File System vs DBMS | Disadvantages of File System | DBMS Advantages
- 4 Lec-4: 2 tier and 3 tier Architecture with real life examples | Database Management System
- 5 Lec-5: What is Schema | How to define Schema | Database management system in Hindi
- 6 Lec-6: Three Schema Architecture | Three Level of Abstraction | Database Management System
- 7 Lec-7: What is Data Independence | Database Management System in Hindi
- 8 Lec-8: What is CANDIDATE KEY and PRIMARY key | Full Concept | Most suitable examples | DBMS
- 9 Lec-9: What is Primary Key in DBMS | Primary Key with Examples in Hindi
- 10 Lec-10: Foreign Key in DBMS | Full Concept with examples | DBMS in Hindi
- 11 Lec-11: Insert, Update & Delete from Foreign Key table | Referential Integrity
- 12 Lec-12: Question on Foreign Key | ये Question Competition Exams में अक्सर पूछा गया है
- 13 Lec-13: Super key in DBMS in HINDI | ये Question Competition Exams में अक्सर पूछा गया है
- 14 Lec-14: Introduction to ER model | ER Model क्या है
- 15 Lec-15: Types of Attributes in ER Model | Full Concept | DBMS in Hindi
- 16 Lec-16: One to One relationship in DBMS in Hindi
- 17 Lec-17: One to Many Relationship in DBMS in Hindi | 1-M Relationship
- 18 Lec-18: Many to Many Relationship in DBMS | M-N Relationship
- 19 Lec-19:Question on Minimize tables in ER Model | ये Question Competition Exams में अक्सर पूछा गया है
- 20 Lec-20: Normalization in DBMS in Hindi | Insertion, Deletion & Updation Anomaly क्या होती है ?
- 21 Lec-21: First Normal form in DBMS in HINDI | 1st Normal form क्या होती है ?
- 22 Lec-22: Finding Closure of Functional dependency in DBMS | Easiest & Simplest way
- 23 Lec-23: Functional Dependency & its properties in DBMS in HINDI
- 24 Lec-24: Second Normal Form | 2NF | Database Management System
- 25 Lec-25: Third Normal Form in dbms with examples in Hindi | Normalization
- 26 Lec-26: Boyce Codd Normal Form #BCNF #DBMS #Normalization with best examples
- 27 Lec-27: Lossless and Lossy Decomposition| Fifth (5th) Normal Form | Database Management System
- 28 All Normal Forms with Real life examples | 1NF 2NF 3NF BCNF 4NF 5NF | All in One
- 29 Lec-28: Minimal Cover in DBMS With Example #Minimalcover#DBMS
- 30 Lec-29: Practice Question on Normalization | Database Management System
- 31 Lec-30: How to find out the Normal form of a Relation | DBMS
- 32 Lec-31 How to Solve Normalization Questions | DBMS
- 33 Lec-32 GATE 2018 Question Explaination on Normalization
- 34 Lec-33: Cover and Equivalence of Functional Dependencies | Database Management System
- 35 Lec-34 Dependency Preserving Decomposition in DBMS with Examples in Hindi | DBMS
- 36 Lec- 35 Dependency Preserving Decomposition in DBMS | Example 2 in Hindi
- 37 Lec-36: Introduction to Joins and its types | Need of Joins with example | DBMS
- 38 Lec-37: Natural Join operation with Example | Database Management System
- 39 Lec-38: Self Join operation with Example | Database Management System
- 40 Lec-39: Equi Join operation with Example | Database Management System
- 41 Lec-40: Left Outer Join operation with Example | Database Management System
- 42 Lec-41: Right Outer Join operation with Example | Database Management System
- 43 Lec-42: Introduction to Relational Algebra | Database Management System
- 44 Lec-43: Projection in Relational Algebra | Database Management System
- 45 Lec-44: Selection in Relational Algebra | Database Management System
- 46 Lec-45: Cross/Cartesian Product in Relational Algebra | Database Management System
- 47 Lec-46: Set Difference in Relational Algebra | Database Management System
- 48 Lec-47: Union Operation in Relational Algebra | Database Management System
- 49 Lec-48: Division Operation in Relational Algebra | Database Management System
- 50 Tuple Calculus in DBMS with examples
- 51 Lec-49: Introduction to Structured Query Language | points regarding its Features and Syllabus
- 52 Lec-50: All Types of SQL Commands with Example | DDL, DML, DCL, TCL and CONSTRAINTS | DBMS
- 53 Create table in SQL with execution | SQL for Beginners | Oracle LIVE
- 54 Lec-51: ALTER Command (DDL) in SQL with Implementation on ORACLE
- 55 Lec-52 Difference between Alter and Update in SQL with examples in Hindi | DBMS
- 56 Lec-53 Difference between Delete, Drop & Truncate in SQL | DBMS
- 57 Lec-54 Constraints in SQL in Hindi | DBMS
- 58 Lec-55: SQL Queries and Subqueries (part-1) | Database Management System
- 59 Lec-56: SQL Queries and Subqueries (part-2) | 2nd Highest Salary | Nested Queries | DBMS
- 60 Lec-57: SQL Queries and Subqueries (part-3) | Group By clause | Database Management System
- 61 Lec-58: SQL Queries and Subqueries (part-4) | Having clause | Database Management System
- 62 Lec-59: SQL Queries and Subqueries (part-5) | Database Management System
- 63 Lec-60: SQL Queries and Subqueries (part-6)| use of IN and Not IN | Database Management System
- 64 Lec-61: SQL Queries and Subqueries (part-7)| use of IN and Not IN in Subquery | DBMS
- 65 Lec-62: EXIST and NOT EXIST Subqueries(part-8) | Database Management System
- 66 Lec-63: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions | DBMS
- 67 Lec-64: Correlated Subquery in SQL with Example | Imp for Placements, GATE, NET & SQL certification
- 68 Lec-65: Difference between Joins, Nested Subquery and Correlated Subquery | Most Imp Concept of SQL
- 69 Lec-66: Find Nth(1st,2nd,3rd....N) Highest Salary in SQL | Imp for Competitive & Placement exam
- 70 Lec-67: 3 Imp Questions on SQL basic Concepts | DBMS | NTA NET CSE June 2021
- 71 Lec-68: Introduction to PL-SQL in DBMS
- 72 Lec-69: Introduction to Transaction Concurrency in HINDI | Database Management System
- 73 Lec-70: ACID Properties of a Transaction | Database Management System
- 74 Lec-71: Transaction States | Database Management System
- 75 Lec-72: What is Schedule | Serial Vs Parallel Schedule | Database Management System
- 76 Lec-73: Read-Write Conflict or Unrepeatable Read Problem | Database Management System
- 77 Lec-74: Irrecoverable Vs Recoverable Schedules in Transactions | DBMS
- 78 Lec-75: Cascading vs Cascadeless Schedule with Example | Recoverability | DBMS
- 79 Lec-76: Introduction to Serializability | Transactions Concurrency and Control | DBMS
- 80 Lec-77: Conflict Equivalent Schedules with Example | Transaction concurrency and Control | DBMS
- 81 Lec-78: Conflict Serializability | Precedence Graph | Transaction | DBMS
- 82 Lec-79: Why View Serializability is Used | Introduction to View Serializability | DBMS
- 83 Lec-80:Shared Exclusive Locking Protocol with Example in Hindi | Concurrency Control | DBMS | Part-1
- 84 Lec-81: Drawbacks in Shared/Exclusive Locking Protocol with Example | Concurrency Control Part-2
- 85 Lec-82: 2 Phase Locking(2PL) Protocol in Transaction Concurrency Control | DBMS
- 86 Lec-83: Drawbacks in 2 Phase Locking(2PL) Protocol with examples | Concurrency Control | DBMS
- 87 Lec-84: Strict 2PL, Rigorous 2PL and Conservative 2PLSchedule | 2 Phase Locking in DBMS
- 88 Lec-85: Basic Timestamp Ordering Protocol with Example in Hindi | Concurrency Control | DBMS
- 89 Lec-86: How to Solve Question on Timestamp Ordering Protocol | Concurrency Control | DBMS
- 90 Lec-87: Why Indexing is used | Indexing Beginning | DBMS
- 91 Lec-88: Numerical Example on I/O Cost in Indexing | Part 1 | DBMS
- 92 Lec-89: Numerical Example on I/O Cost in Indexing | Part 2 | DBMS
- 93 Lec-90: Types Of Indexes | Most Important Video on Indexing
- 94 Lec-91: Primary Index With Example | GATE, PSU and UGC NET | DBMS
- 95 Lec-92: Clustered Index in Database with Example
- 96 Lec-93: Secondary Index in Database with Example | Multilevel Indexing
- 97 Lec-94: Introduction to B-Tree and its Structure | Block Pointer, Record Pointer, Key
- 98 Lec-95: Insertion in B-Tree with example in Hindi
- 99 Lec-96: How to find Order of B-Tree | Imp Question on B-Tree
- 100 Lec-97: Difference b/w B-Tree & B+Tree in Hindi with examples
- 101 Lec-98: Order of B+ Tree | Order of Leaf Node & Non Leaf Node in B+Tree
- 102 Lec-99: Immediate Database Modification in DBMS | Log Based Recovery Methods
- 103 Lec-100: Questions on DBMS basic concepts and Data Modelling | DBMS | NTA NET CSE June 2021
- 104 Lec-101: 4 Imp Questions on Advance DBMS | BIG Data and Data Warehouse | NTA NET CSE June 2021
- 105 Deferred Database Modification in DBMS | Log Based Recovery | Imp for UGC NET and KVS
- 106 Like Command in SQL with example in Hindi | Learn SQL in Easiest Way| DBMS
- 107 Basic PL-SQL Programming With Execution | Part-1
- 108 Basic PL-SQL Programming(While, For Loop) With Execution | Part-2
- 109 Single row and Multi row functions in SQL
- 110 Character functions in SQL with execution | Oracle LIVE
