Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

DBMS (Database Management system)

via YouTube

Syllabus

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

Taught by

Gate Smashers

Related Courses

Reviews

Start your review of DBMS (Database Management system)

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free