DBMS (Database Management System) (Hindi)

   Tuesday, May 26, 2020   

Starting a new Lecture Notes Series on DBMS

Youtube Lecture Playlist Credits 

Channel Name: Gate Smashers

So Let Us Start to This Journey of Learning DBMS

By Lecture Notes together!

Lecture Description of this above Topic:

Lecture 1: DBMS Syllabus for GATE, UGCNET, NIELIT, DSSSB

Lecture 2: Introduction to Relational Database Management System

Lecture 3: File System vs DBMS

Lecture 4: 2 tier and 3 tier Architecture with real life examples

Lecture 5: What is Schema

Lecture 6: Three Schema Architecture

Lecture 7: What is Data Independence

Lecture 8: What is CANDIDATE KEY and PRIMARY key

Lecture 9: What is Primary Key in DBMS

Lecture 10: Foreign Key in DBMS

Lecture 11: Insert, Update & Delete from Foreign Key table

Lecture 12: Question on Foreign Key

Lecture 13: Super key in DBMS

Lecture 14: Introduction to ER model

Lecture 15: Types of Attributes in ER Model

Lecture 16: One to One Relationship

Lecture 17: One to Many Relationship in DBMS

Lecture 18: Many to Many Relationship in DBMS

Lecture 19: Question on Minimize tables in ER Model

Lecture 20: Normalization in DBMS

Lecture 21: First Normal form in DBMS

Lecture 22: Finding Closure of Functional dependency

Lecture 23: Functional Dependency & its properties

Lecture 24: Second Normal Form

Lecture 25: Third Normal Form in DBMS

Lecture 26: Boyce Codd Normal Form

Lecture 27: Lossless and Lossy Decomposition

Lecture 28: Minimal Cover in DBMS

Lecture 29: Practice Question on Normalization

Lecture 30: Practice Question to find out the Normal form

Lecture 31: How to Solve Normalization Questions

Lecture 32: GATE 2018 Question Explaination on Normalization

Lecture 33: Cover and Equivalence of Functional Dependencies

Lecture 34: Dependency Preserving Decomposition in DBMS

Lecture 35: Dependency Preserving Decomposition

Lecture 36: Introduction to Joins and its types

Lecture 37: Natural Join operation

Lecture 38: Self Join operation with Example

Lecture 39: Equi Join operation with Example

Lecture 40: Left Outer Join operation

Lecture 41: Right Outer Join operation

Lecture 42: Introduction to Relational Algebra

Lecture 43: Projection in Relational Algebra

Lecture 44: Selection in Relational Algebra

Lecture 45: Cross/Cartesian Product in Relational Algebra

Lecture 46: Set Difference in Relational Algebra

Lecture 47: Union Operation in Relational Algebra

Lecture 48: Division Operation in Relational Algebra

Lecture 49: Introduction to Structured Query Language

Lecture 50: All Types of SQL Commands with Example

Lecture 51: ALTER Command (DDL) in SQL with Implementation on ORACLE

Lecture 52: Difference between Alter and Update in SQL

Lecture 53: Difference between Delete, Drop & Truncate in SQL

Lecture 54: Constraints in SQL

Lecture 55: SQL Queries and Subqueries (part-1)

Lecture 56: SQL Queries and Subqueries (part-2)

Lecture 57: SQL Queries and Subqueries (part-3)

Lecture 58: SQL Queries and Subqueries (part-4)

Lecture 59: SQL Queries and Subqueries (part-5)

Lecture 60: SQL Queries and Subqueries (part-6)

Lecture 61: SQL Queries and Subqueries (part-7)

Lecture 62: EXIST and NOT EXIST Subqueries(part-8)

Lecture 63: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions

Lecture 64: Correlated Subquery in SQL

Lecture 65: Difference between Joins, Nested Subquery and Correlated Subquery

Lecture 66: Find Nth

Lecture 67: 3 Imp Questions on SQL basic Concepts

Lecture 68: Introduction to PL-SQL in DBMS

Lecture 69: Introduction to Transaction Concurrency

Lecture 70: ACID Properties of a Transaction

Lecture 71: Transaction States

Lecture 72: What is Schedule

Lecture 73: Read-Write Conflict or Unrepeatable Read Problem

Lecture 74: Irrecoverable Vs Recoverable Schedules in Transactions

Lecture 75: Cascading vs Cascadeless Schedule with Example

Lecture 76: Introduction to Serializability

Lecture 77: Conflict Equivalent Schedules with Example

Lecture 78: Conflict Serializability

Lecture 79: Why View Serializability is Used

Lecture 80: Shared Exclusive Locking Protocol with Example

Lecture 81: Drawbacks in Shared/Exclusive Locking Protocol

Lecture 82: 2 Phase Locking(2PL) Protocol in Transaction Concurrency Control

Lecture 83: Drawbacks in 2 Phase Locking(2PL) Protocol

Lecture 84: Strict 2PL, Rigorous 2PL and Conservative 2PLSchedule

Lecture 85: Basic Timestamp Ordering Protocol with Example

Lecture 86: How to Solve Question on Timestamp Ordering Protocol

Lecture 87: Lec-66: Why Indexing is used

Lecture 88: Lec-67: Numerical Example on I/O Cost in Indexing | Part 1

Lecture 89: Numerical Example on I/O Cost in Indexing | Part 2

Lecture 90: Types Of Indexes

Lecture 91: Primary Index With Example

Lecture 92: Clustered Index in Database

Lecture 93: Secondary Index in Database with Example

Lecture 94: Introduction to B-Tree and its Structure

Lecture 95: Insertion in B-Tree

Lecture 96: Difference b/w B-Tree & B+Tree

Lecture 97: Order of B+ Tree | Order of Leaf Node & Non Leaf Node in B+Tree

Lecture 98: How to find Order of B-Tree

Lecture 99: Immediate Database Modification in DBMS

Lecture 100: Questions on DBMS basic concepts and Data Modelling

Lecture 101: 4 Imp Questions on Advance DBMS