Play all

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

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

Description:

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.

DBMS - Database Management System

Add to list

#Programming #Databases #Domain-Specific Languages (DSL) #SQL #PL/SQL #Computer Science #Relational Algebra #Education & Teaching #Competitive Exam Preparation