In this course, you will learn about Database Management Systems. You will learn about 2 tier and 3 tier architecture, schema, data independence, keys, ER model, relationships, normalization, function dependency, normal forms, decomposition, joins, relational algebra, Structured Query Language, commands, constraints, queries and subqueries, functions, PL-SQL, transaction, schedule, serializability, locking protocol, timestamp ordering protocol, indexing, B-tree and B+tree, database modification, and much more.
Overview
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
