Database Management System(DBMS) Full Course (Hindi) (Part 4)

CSE/IT SERIES

Database Management System(DBMS) Full Course (Hindi) (Part 4)

   Saturday, October 18, 2025   

Starting a new Lecture Notes Series on Database Management System(DBMS) Full Course

Youtube Lecture Playlist Credits 

Channel Name: Easy Engineering Classes

So Let Us Start to This Journey of Learning 

Database Management System(DBMS) Full Course By Lecture Notes together!

Lecture 145: DBMS 2013 GGSIPU 2nd term question paper(Questions on Normalization and Transaction Mgmt)

Lecture 146: DBMS 2012 GGSIPU 2nd term question paper(Questions on Normalization and Transaction Mgmt)

Lecture 147: Solved Question on FD Closure, Finding Candidate Key, Canonical Cover

Lecture 148: Solved Question on finding Function Dependency Closure

Lecture 149: Solved Question on Relational Algebra - Problem on Select, Project, Union, Intersect, Minus

Lecture 150: Important Solved Numerical Problems on Normalization – DBMS Questions

Lecture 151: Important Solved Numerical Problems on Decomposition(Lossless/Lossy) – DBMS Questions

Lecture 152: Important Solved Numerical Problems on Canonical Cover – DBMS Questions

Lecture 153: Important Solved Numerical Problems on Functional Dependency – DBMS Questions

Lecture 154: Explain the ACID Concepts in DBMS - #DOEACC #NIELIT – DBMS Previous Year Questions

Lecture 155: What are Views - Explain How Views are different from Tables | Doeacc Nielit Questions

Lecture 156: Responsibilities of DBA and Relevance of Data Dictionary in Database - Placement Preparation

Lecture 157: Disadvantages of File Processing System, Difference between Physical and Logical Data Independence

Lecture 158: Difference between Candidate and Super Key | Short Note on Derived Attribute

Lecture 159: Three Level Architecture of Database System

Lecture 160: Basic and Aggregate Operations in Relational Algebra with Examples

Lecture 161: Shadow Paging and Shared/Exclusive Locking Mechanism - DBMS Question Answers

Lecture 162: Explain Two Phase Commit Protocol in Distributed Database System

Lecture 163: Three Schema Architecture of DBMS and need of Mapping between Schema Levels

Lecture 164: Audit Trail in DBMS and its Usage with respect to Security

Lecture 165: Dependency Preservation in DBMS – Solved Question on BCNF

Lecture 166: What is Database | Describe Advantages and Disadvantages of using DBMS

Lecture 167: Discretionary Access Control Based Privilege Grant and Revoke in DBMS System

Lecture 168: Different Types of Failures in Oracle Database - DBMS Important questions

Lecture 169: Different Types of Database Failures that occur in database environment

Lecture 170: How Grant Function relates with Security | Types of Privileges and How to Revoke them

Lecture 171: What happens when COMMIT is not executed after any SQL statement | Side effect of Commit

Lecture 172: What are different types of Database Users who interact with the database System

Lecture 173: DBMS Imp Terms : Authorization, Authentication, Audit Trail, Encryption, Grant Revoke

Lecture 174: How does Encryption Support in Database | Transparent Database Encryption

Lecture 175: Why Recovery of Interactive Transactions is more difficult to deal with Batch recovery transactions

Lecture 176: P1: PRACTICE PROBLEMS ON Database Design(Normal Forms) | GATE, ESE, PSU, UGC NET 2023 Preparation

Lecture 177: P2: PRACTICE PROBLEMS ON Database Design(Normal Forms) | GATE, ESE, PSU, UGC NET 2023 Preparation

Lecture 178: P3: PRACTICE PROBLEMS ON Database Design(Normal Forms) | GATE, ESE, PSU, UGC NET 2023 Preparation

Lecture 179: P4: PRACTICE PROBLEMS ON Database Design(Normal Forms) | GATE, ESE, PSU, UGC NET 2023 Preparation

Lecture 180: P5: PRACTICE PROBLEMS ON Database Design(Normal Forms) | GATE, ESE, PSU, UGC NET 2023 Preparation

Lecture 181: P6: PRACTICE PROBLEMS ON Database Design(Normal Forms) | GATE, ESE, PSU, UGC NET 2023 Preparation

Lecture 182: P7: PRACTICE PROBLEMS ON Database Design(FD Equivalence) | GATE, ESE, PSU, UGC NET 2023 Preparation

Lecture 183: P8: PRACTICE PROBLEMS ON Database Design(FD Equivalence) | GATE, ESE, PSU, UGC NET 2023 Preparation

Lecture 184: P9: PRACTICE PROBLEMS ON Database Design(Decomposition) | GATE, ESE, PSU, UGC NET 2023 Preparation

Lecture 185: P10: PRACTICE PROBLEMS ON Database Design(Decomposition) | GATE, ESE, PSU, UGC NET 2023 Preparation

Lecture 186: P11: PRACTICE PROBLEMS ON Database Design(Decomposition) | GATE, ESE, PSU, UGC NET 2023 Preparation

Lecture 187: P12: PRACTICE PROBLEMS ON Database Design(Dependency Preservation) | GATE, ESE, PSU, UGC NET 2023

Lecture 188: P13: PRACTICE PROBLEMS ON Database Design(Dependency Preservation) | GATE, ESE, PSU, UGC NET 2023

Lecture 189: P14: PRACTICE PROBLEMS ON Database Design(Normalization) | GATE, ESE, PSU, UGC NET 2023

Lecture 190: P15: PRACTICE PROBLEMS ON Database Design(Normalization) | GATE, ESE, PSU, UGC NET 2023

Lecture 191: P16: PRACTICE PROBLEMS ON Database Design(Normalization) | GATE, ESE, PSU, UGC NET 2023

Lecture 192: P17: PRACTICE PROBLEMS ON Database Design(Normalization) | GATE, ESE, PSU, UGC NET 2023

Database Management System(DBMS) Full Course (Hindi) (Part 3)

CSE/IT SERIES

Database Management System(DBMS) Full Course (Hindi) (Part 3)

   Friday, October 17, 2025   

Starting a new Lecture Notes Series on Database Management System(DBMS) Full Course

Youtube Lecture Playlist Credits 

Channel Name: Easy Engineering Classes

So Let Us Start to This Journey of Learning 

Database Management System(DBMS) Full Course By Lecture Notes together!

Lecture 97: L94: Solved Question(1) on SQL Queries - Employee, Works, Company, Manages Relation Queries

Lecture 98: L95: Solved Question(2) on SQL Queries - Question on Vehicle, Person and Owner Table | DBMS Lectures

Lecture 99: L96: Solved Question(3) on SQL Queries - Question on Supplier Relation | DBMS Lectures

Lecture 100: L97: Introduction to PL-SQL in Database Management System | DBMS Lectures in Hindi

Lecture 101: L98: PL-SQL Select Into Statement with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 102: L99: PL-SQL Condition Statement - IF Then, If Then else, CASE Statement with Examples | DBMS

Lecture 103: L100: PL-SQL Loops - For Loop, While Loop, Simple PL-SQL Loop with Examples | DBMS Lectures

Lecture 104: L101: PLSQL Cursor, Implicit and Explicit Cursor, How to Open, Fetch, Close Cursor | DBMS Lectures

Lecture 105: L102: PL-SQL Functions, How to Create PL SQL Function using Table with Examples | DBMS Lectures

Lecture 106: L103: PL-SQL Procedure, How to Create Procedure, Call Procedure with Example | DBMS Lectures

Lecture 107: L104: PLSQL Trigger, Row and Statement Level Trigger, How to Write Trigger with Examples | DBMS

Lecture 108: L105: PL SQL Exception Handling | How to Raise Exception in PLSQL with Examples | DBMS Lectures

Lecture 109: L106: Introduction to Transaction Management | ACID Properties in Database Management System(DBMS)

Lecture 110: L107: Transaction States with Diagram | Database Management System(DBMS) Lectures in Hindi

Lecture 111: L108: Database Concurrency Problems | Lost Update, Dirty Read, Unrepeatable Read, Incorrect Summary

Lecture 112: L109: Schedule in Database | Serial, Complete, Recoverable, Cascadeless, Strict Schedule with Eg.

Lecture 113: L110: Introduction to Serializability | Conflict and View Serializable Schedules in Database(DBMS)

Lecture 114: L110-1: Practice Problems on Problems on Conflict Serializability in Database Transaction Management

Lecture 115: L111: Conflict Equivalent Schedules with Example | Transaction concurrency and Control | DBMS

Lecture 116: L112: Concurrency Control - Lock Based Protocol in Database Management System(DBMS) with Examples

Lecture 117: L113: 2 Phase Locking(2PL) Protocol in Transaction Concurrency Control | Database(DBMS) Lectures

Lecture 118: L113-1: Practice Problem on 2PL(Two Phase Locking) - Add Lock/Unlock and check for Deadlock

Lecture 119: L114: Deadlock Detection in Database Transaction | Wait For Graph Explanation with Example | DBMS

Lecture 120: L115: Deadlock Control Techniques | Deadlock Prevention | Timestamps and Time Out based Scheme

Lecture 121: L116: Timestamp Ordering Protocol in Database Transaction Management | DBMS Lectures in Hindi

Lecture 122: L117: Thomas Write Rules in Database Transaction Management | DBMS Lectures in Hindi

Lecture 123: L118: Starvation in Database Transaction | Database Management System(DBMS) in Hindi

Lecture 124: L119: Deadlock Recovery in Database Transaction with example | Database Management System(DBMS)

Lecture 125: L120: Log Based Database Recovery | Write Ahead Log Buffer Strategy | DBMS Lectures in Hindi

Lecture 126: L121: Transaction Recovery Procedure - Deferred Database Vs. Immediate Database Modification

Lecture 127: L121-1: Differentiate between Immediate Update and Deferred Update Recovery Techniques | DBMS

Lecture 128: L122: Shadow Paging in Database Recovery | Advantages over Log Based Method and Drawbacks | DBMS

Lecture 129: L123: Explain Checkpoints and How Does it helps in reducing recovery time | DBMS Lectures in Hindi

Lecture 130: L124: Types of Database Indexes | Ordered, Clustered, Primary, Dense, Sparse, Secondary Index | DBMS

Lecture 131: L125: Database File Organization | B+ Tree and Other Types with Examples | DBMS Lectures in Hindi

Lecture 132: L126: Introduction to Distributed Database | Features, Advantages and Disadvantages | DBMS Lectures

Lecture 133: L127: Types of Distributed Databases | Data Storage (Fragmentation, Replication) | Transparency

Lecture 134: L128: Query Processing & Optimization in Distributed Database | Query Processing Steps, Query Blocks

Lecture 135: L129: Implementation of Select Operation, Complex Select Operation (And, Or) in Distributed Database

Lecture 136: L130: Implementation of Project Operation with Duplication Removal in Distributed Database

Lecture 137: L131: Implementation of Set Operation | Union, Intersection, Minus Operator in Distributed Database

Lecture 138: L132: Distributed Query Processing | Simple Join, Semi Join Processing | Parallelism | DBMS Lectures

Lecture 139: L133: Distributed Database Transactions | Distributed Locking (Single and Distributed Lock Manager)

Lecture 140: L134: Distributed Database Deadlock Handling | Local and Global Wait for Graph | DBMS Lectures

Lecture 141: L135: Distributed Database Recovery | Two Phase and Three Phase Commit Protocol | DBMS Lectures

Lecture 142: L136: Primary Copy | Majority Locking | Timestamping (Centralized and Distributed Scheme) | DBMS

Lecture 143: DBMS 2015 GGSIPU 2nd term question paper(Questions on Normalization and Transaction Mgmt)

Lecture 144: DBMS 2014 GGSIPU 2nd term question paper(Questions on Normalization and Transaction Mgmt)

Database Management System(DBMS) Full Course (Hindi) (Part 2)

CSE/IT SERIES

Database Management System(DBMS) Full Course (Hindi) (Part 2)

   Friday, October 17, 2025   

Starting a new Lecture Notes Series on Database Management System(DBMS) Full Course

Youtube Lecture Playlist Credits 

Channel Name: Easy Engineering Classes

So Let Us Start to This Journey of Learning 

Database Management System(DBMS) Full Course By Lecture Notes together!

Lecture 49: L48: Equivalence of Functional Dependencies in Database Management System in Hindi with Example

Lecture 50: L49: Practice Questions on Functional Dependencies Equivalence in Database Management System(DBMS)

Lecture 51: L50: Lossless and Lossy Decomposition in DBMS with examples | Database Management System

Lecture 52: L51: Practice Questions on Lossless/Lossy Decomposition of a Relation in DBMS in Hindi

Lecture 53: L52: Dependency Preserving Decomposition in Database Management System(DBMS) with Examples in Hindi

Lecture 54: L53: Practice Questions on Dependency Preserving Decomposition of a Relation in DBMS

Lecture 55: L54: Minimal/Canonical Cover in Database Management System(DBMS) with Examples in Hindi

Lecture 56: L55: Practice Questions on Minimal/Canonical Cover in Database Management System(DBMS) in Hindi

Lecture 57: L56: Normalization Introduction in DBMS in Hindi | Why it is required | Types of Normal Forms

Lecture 58: L57: Insertion, Deletion & Updation Anomaly in Normalization | First Normal Form(1NF) with Example

Lecture 59: L57-1: How Functional Dependency is associated with Normalization | Database Management System

Lecture 60: L58: How to Find Candidate Key in Database Relation with Example in Hindi | DBMS in Hindi

Lecture 61: L59: Second Normal Form | 2NF in Database | How to Decompose Relation in 2NF with Example in Hindi

Lecture 62: L60: Third Normal Form(3NF) in Database Management System(DBMS) with examples in Hindi

Lecture 63: L61: Boyce Codd Normal Form(BCNF) in Database Management System(DBMS) with examples in Hindi

Lecture 64: L62: Comparison(Difference) between 3NF and BCNF with example | Database Management System(DBMS)

Lecture 65: L63: Practice Questions on How to Find Normal Form of a Relation in Database Management System(DBMS)

Lecture 66: L64: DBMS GATE Previous Year Questions Part 1 | PYQ | Decomposition, FD, Normal Form, Finding Key

Lecture 67: 65: DBMS GATE Previous Year Questions Part 2 | PYQ | Decomposition, FD, Normal Form, Finding Key

Lecture 68: L66: Fourth Normal Form(4NF) with Multi-Valued Dependency(MVD) in DBMS with Example in Hindi

Lecture 69: L67: Fifth Normal Form(5NF) with Join Dependency in Database Management System(DBMS) in Hindi

Lecture 70: L68: Revision of Normalization with Examples and Practice Problems | DBMS Lectures in Hindi

Lecture 71: L69: Introduction to Structured Query Language(SQL) | Types of SQL Commands with examples

Lecture 72: L70: Create Database, Table Command in SQL | SQL Table Constraints(NOT NULL Example)

Lecture 73: L71: ALTER Command (DDL) in SQL | Add Column, Drop Column, Change Column Datatype Examples

Lecture 74: L72: SQL DROP TABLE, DROP DATABASE, TRUNCATE TABLE Commands with Example | DBMS Lectures in Hindi

Lecture 75: L73: SQL Views, Create Views, DROP Views with examples | SQL Tutorial for Beginners

Lecture 76: L74: Difference between Delete, Drop & Truncate in SQL | Database Management System(DBMS)

Lecture 77: L75: Constraints in SQL | UNIQUE, NOT NULL, PRIMARY KEY, CHECK, FOREIGN KEY, DEFAULT with Examples

Lecture 78: L76: SQL Select Statement with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 79: L77: SQL Where clause with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 80: L78: SQL AND/OR Operator with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 81: L 79: SQL Order By Clause with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 82: L80: SQL Insert Into Statement with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 83: L81 : SQL Update Statement with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 84: L82: SQL Delete Statement with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 85: L83: SQL Like Operator, Use of % and _ operator with examples| Database Management System in Hindi

Lecture 86: L84: SQL SET Operations | UNION Operation with Example | Database Management System(DBMS)

Lecture 87: L85: SQL SET Operations | INTERSECT Operation with Example | Database Management System(DBMS)

Lecture 88: L86: SQL SET Operations | MINUS(-) Operation with Example | Database Management System(DBMS)

Lecture 89: L87: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions with Example | DBMS in Hindi

Lecture 90: L88-1: Difference between Having and Where Clause in SQL with example | Database Management System

Lecture 91: L88: SQL Group By Clause and Having with Examples | Database Management System(DBMS)

Lecture 92: L89: SQL Inner Join with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 93: L90: SQL Left Outer Join with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 94: L91: SQL Right Outer Join with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 95: L92: SQL Full Outer Join with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 96: L93: SQL Nested Query - Insert, Update, Select and Delete using Sub Queries | DBMS in Hindi

Database Management System(DBMS) Full Course (Hindi) (Part 1)

CSE/IT SERIES

Database Management System(DBMS) Full Course (Hindi) (Part 1)

   Friday, October 17, 2025   

Starting a new Lecture Notes Series on Database Management System(DBMS) Full Course

Youtube Lecture Playlist Credits 

Channel Name: Easy Engineering Classes

So Let Us Start to This Journey of Learning 

Database Management System(DBMS) Full Course By Lecture Notes together!

Lecture 1: L1: Introduction to DBMS (Database Management System), Features of Data in Database | What is DBMS

Lecture 2: L2: File System vs DBMS | Disadvantages of File System | DBMS Advantages | Database Lectures

Lecture 3: L3: Functions of Database Administrators(DBA) | Database Management System(DBMS) Complete Course

Lecture 4: L4: Database Architecture Working with the help of Diagram | Database Management System Lectures

Lecture 5: L5: 2 Tier and 3 Tier Architecture with Examples | Database Management System Lectures in Hindi

Lecture 6: L6: DBMS Components(Actors), Types of Users in Database | Database Management System Complete Course

Lecture 7: L7: Database Schema, Instances and Sub Schema | Database management system Lectures in Hindi

Lecture 8: L7-1: Difference between Database Schema & Instance | Relation between External & Conceptual Schema

Lecture 9: L8: Three Schema Architecture | Three Level of Abstraction | External , Conceptual , & Internal View

Lecture 10: L8-1: Categories of Data Models – Conceptual, Physical and Logical | Database Management System

Lecture 11: L9: What is Data Independence | Comparison between Physical and Logical Data Independence

Lecture 12: L10: Database Languages: DDL, DCL and DML with examples | Database Management System in Hindi

Lecture 13: L11: Introduction to ER Model | Notations, Strong and Weak Entity in Database ER Model

Lecture 14: L12: Explain the Need of Weak Entity Sets in ER Diagram | Database Management System in Hindi

Lecture 15: L13: What is Entity and Attributes | Types of Attributes with example | DBMS in Hindi

Lecture 16: L14: Relationship Set, Mapping Cardinality, Participation Constraints in Database ER Model

Lecture 17: L15: Types of Keys in Relation | Super Key, Candidate, Primary, Alternate, Foreign Key with examples

Lecture 18: L16: Extended ER Features, Generalization, Specialization, Aggregation with Examples and Diagram

Lecture 19: L17: Difference between Specialization and Generalization in ER Model | DBMS Lectures in Hindi

Lecture 20: L18: Examples of Aggregation in Database ER Model | Database Management Systems in Hindi

Lecture 21: L19: Recursive and Identifying Relationship in ER Model with examples | DBMS Lectures in Hindi

Lecture 22: L20: What is Relational Database and what are its advantages | Database Management Systems in Hindi

Lecture 23: L21: Relation Schema, Instance, Cardinality, Degree, Database Schema Definition | DBMS Lectures

Lecture 24: L22: Types of Keys and Why Keys are important in Relational Database Model | DBMS Lectures in Hindi

Lecture 25: L23: Introduction to Relationship and Types: One to One, One to Many(Many to One) and Many to Many

Lecture 26: 24: Relational Integrity Constraints in Relational Database with Example | DBMS Lectures in Hindi

Lecture 27: L25: Entity Integrity Rule and Integrity Constraints | Check and Foreign Key in SQL with Example

Lecture 28: L26: Introduction to Relational Algebra | Basic and Derived Operators | Database Management System

Lecture 29: L27: Selection in Relational Algebra | Select Operation Explanation with Examples | DBMS Lectures

Lecture 30: L28: Projection in Relational Algebra | Project Operation in DBMS Relational Algebra with example

Lecture 31: L29: Set Operations Union Compatibility Rule | Union Operation in Relational Algebra with Example

Lecture 32: L30: Intersection in Database Relational Algebra | Intersect Operation with Example in DBMS

Lecture 33: L31: Set Difference in Relational Algebra | Set Difference Operation(R-S) in Database(DBMS)

Lecture 34: L32: Cross/Cartesian Product in Relational Algebra | Database Management System(DBMS) in Hindi

Lecture 35: L33: Rename Operation in Relational Algebra | Database Management System(DBMS) in Hindi

Lecture 36: L34: Introduction to Joins and its types in Relational Algebra | Join Vs. Cartesian Product

Lecture 37: L35: Inner Join(Theta, Equi, Natural Join) Operations with Example | Database Management System

Lecture 38: L36: Outer Join(Left Outer, Right Outer, Full Outer Join) Operation in Relational Database

Lecture 39: L37: Division Operation in Relational Algebra | Database Management System in Hindi

Lecture 40: L38: Aggregate Function, Generalized Projection Operation in Relational Algebra | DBMS Lectures

Lecture 41: L40: Difference b/w Relational Algebra & Relational Calculus | Atoms in Tuple Relational Calculus

Lecture 42: L41: Relational Algebra Revision | All Topics with Examples and Practice Problems | DBMS Lectures

Lecture 43: L42: Introduction to Functional Dependency in Database with Examples | DBMS in Hindi

Lecture 44: L43: Functional Dependency Classification with Examples | Database Management System in Hindi

Lecture 45: L44: Armstrong's Axioms/Inference Rules | Functional Dependency Closure with examples in Database

Lecture 46: L45: Attribute Closure | How to Find Candidate Key in Relation, Find Additional FD with example

Lecture 47: L46: Practice Problem on Finding Functional Dependency Closure and Finding Candidate Keys

Lecture 48: L47: Practice Questions on Finding Key in Relation | Database Management System in Hindi

PL-SQL tutorial for Beginners in Hindi and English

CSE/IT SERIES

PL-SQL tutorial for Beginners in Hindi and English

   Saturday, October 11, 2025   

Starting a new Lecture Notes Series on PL-SQL tutorial for Beginners in Hindi and English

Youtube Lecture Playlist Credits 

Channel Name: Easy Engineering Classes

So Let Us Start to This Journey of Learning 

PL-SQL tutorial for Beginners in Hindi and English By Lecture Notes together!

Lecture 1: L97: Introduction to PL-SQL in Database Management System | DBMS Lectures in Hindi

Lecture 2: L98: PL-SQL Select Into Statement with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 3: L99: PL-SQL Condition Statement - IF Then, If Then else, CASE Statement with Examples | DBMS

Lecture 4: L100: PL-SQL Loops - For Loop, While Loop, Simple PL-SQL Loop with Examples | DBMS Lectures

Lecture 5: L101: PLSQL Cursor, Implicit and Explicit Cursor, How to Open, Fetch, Close Cursor | DBMS Lectures

Lecture 6: L102: PL-SQL Functions, How to Create PL SQL Function using Table with Examples | DBMS Lectures

Lecture 7: L103: PL-SQL Procedure, How to Create Procedure, Call Procedure with Example | DBMS Lectures

Lecture 8: L104: PLSQL Trigger, Row and Statement Level Trigger, How to Write Trigger with Examples | DBMS

Lecture 9: L105: PL SQL Exception Handling | How to Raise Exception in PLSQL with Examples | DBMS Lectures

ADVANCED DATABASE ADMINISTRATION - ETIT-427 - IP University (Hindi)

CSE/IT SERIES

ADVANCED DATABASE ADMINISTRATION - ETIT-427 - IP University (Hindi)

   Friday, October 10, 2025   

Starting a new Lecture Notes Series on ADVANCED DATABASE ADMINISTRATION - ETIT-427 - IP University

Youtube Lecture Playlist Credits 

Channel Name: Easy Engineering Classes

So Let Us Start to This Journey of Learning 

ADVANCED DATABASE ADMINISTRATION - ETIT-427 - IP University By Lecture Notes together!

Lecture 1: Database configuring Assistant (DBCA), Using DBCA to create, delete Database | ADBA/ADBMS Lectures

Lecture 2: Starting and Stopping database control - ETIT 427 - ADBA - IP University Syllabus

Lecture 3: Initialising parameter files - ETIT 427 - ADBA - IP University Syllabus

Lecture 4: Starting Up database instance - ETIT 427 - ADBA - IP University Syllabus

Lecture 5: Shutting Down Database Instance - ETIT 427 - ADBA - IP University Syllabus

Lecture 6: Database Storage structure, How table data is stored? - ETIT 427 - ADBA - IP University Syllabus

Lecture 7: Tablespaces and data files, Types of TableSpaces - ETIT 427 - ADBA - IP University Syllabus

Lecture 8: Creating a user, Authenticating users - ETIT 427 - ADBA - IP University Syllabus

Lecture 9: Unlocking a user account and resetting the password - ETIT 427 - ADBA - IP University Syllabus

Lecture 10: Privileges and role, System privileges, object privileges - ETIT 427 - ADBA - IP University Syllabus

Lecture 11: Data Files - ETIT 427 - ADBA - IP University Syllabus

Lecture 12: Creating Views - ETIT 427 - ADBA - IP University Syllabus

Lecture 13: Index organised tables and heap tables, creating index organised tables

Lecture 14: cluster, cluster types, Index and Hash Cluster - ETIT 427 - ADBA - IP University Syllabus

Lecture 15: What is partition and why use it? Creating a Partition, Partitioning method

Lecture 16: Creating Sequences in SQL, Using Sequences in Insert Statement of SQL

Lecture 17: Detecting and Resolving lock conflicts - ETIT 427 - ADBA - IP University Syllabus

Lecture 18: L70: Create Database, Table Command in SQL | SQL Table Constraints(NOT NULL Example)

Lecture 19: L71: ALTER Command (DDL) in SQL | Add Column, Drop Column, Change Column Datatype Examples

Lecture 20: L72: SQL DROP TABLE, DROP DATABASE, TRUNCATE TABLE Commands with Example | DBMS Lectures in Hindi

Lecture 21: L73: SQL Views, Create Views, DROP Views with examples | SQL Tutorial for Beginners

Lecture 22: L93: SQL Nested Query - Insert, Update, Select and Delete using Sub Queries | DBMS in Hindi

Lecture 23: L97: Introduction to PL-SQL in Database Management System | DBMS Lectures in Hindi

Lecture 24: L102: PL-SQL Functions, How to Create PL SQL Function using Table with Examples | DBMS Lectures

Lecture 25: L103: PL-SQL Procedure, How to Create Procedure, Call Procedure with Example | DBMS Lectures

Lecture 26: L101: PLSQL Cursor, Implicit and Explicit Cursor, How to Open, Fetch, Close Cursor | DBMS Lectures

Lecture 27: L104: PLSQL Trigger, Row and Statement Level Trigger, How to Write Trigger with Examples | DBMS

Lecture 28: L98: PL-SQL Select Into Statement with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 29: L99: PL-SQL Condition Statement - IF Then, If Then else, CASE Statement with Examples | DBMS

Lecture 30: L100: PL-SQL Loops - For Loop, While Loop, Simple PL-SQL Loop with Examples | DBMS Lectures

Lecture 31: L105: PL SQL Exception Handling | How to Raise Exception in PLSQL with Examples | DBMS Lectures

Lecture 32: Monitoring Undo, Administering Undo, Configuring Undo Retention, Sizing Undo tablespace

Lecture 33: Database transparent encryption (TDE), TDE Process, Implementing TDE

Lecture 34: SQL*Loader - Loading data with SQL *loader, Example of Loading MS-Access Data in Oracle

Lecture 35: Flashback database, Architecture, Configuring flashback Database, Monitoring Flashback database

Lecture 36: Moving data- General Architecture, Data pump, Data pump export and Import.

Lecture 37: Recovering from noncritical Losses, recovery from loss of control file, data file

Lecture 38: RMAN - Configuring Recovery Manager, using Recovery manager

Lecture 39: REDO File - Archived Redo Log Mode and NoArchive Redo Log Mode

SQL Tutorial for Beginners in Hindi and English

CSE/IT SERIES

SQL Tutorial for Beginners in Hindi and English

   Friday, October 10, 2025   

Starting a new Lecture Notes Series on SQL Tutorial for Beginners in Hindi and English

Youtube Lecture Playlist Credits 

Channel Name: Easy Engineering Classes

So Let Us Start to This Journey of Learning 

SQL Tutorial for Beginners in Hindi and English By Lecture Notes together!

Lecture 1: L69: Introduction to Structured Query Language(SQL) | Types of SQL Commands with examples

Lecture 2: L76: SQL Select Statement with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 3: L77: SQL Where clause with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 4: L78: SQL AND/OR Operator with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 5: L 79: SQL Order By Clause with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 6: L80: SQL Insert Into Statement with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 7: L81 : SQL Update Statement with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 8: L82: SQL Delete Statement with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 9: L83: SQL Like Operator, Use of % and _ operator with examples| Database Management System in Hindi

Lecture 10: L84: SQL SET Operations | UNION Operation with Example | Database Management System(DBMS)

Lecture 11: L85: SQL SET Operations | INTERSECT Operation with Example | Database Management System(DBMS)

Lecture 12: L86: SQL SET Operations | MINUS(-) Operation with Example | Database Management System(DBMS)

Lecture 13: L87: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions with Example | DBMS in Hindi

Lecture 14: L89: SQL Inner Join with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 15: L90: SQL Left Outer Join with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 16: L91: SQL Right Outer Join with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 17: L92: SQL Full Outer Join with Example | Database Management System(DBMS) Lectures in Hindi

Lecture 18: L70: Create Database, Table Command in SQL | SQL Table Constraints(NOT NULL Example)

Lecture 19: L71: ALTER Command (DDL) in SQL | Add Column, Drop Column, Change Column Datatype Examples

Lecture 20: L72: SQL DROP TABLE, DROP DATABASE, TRUNCATE TABLE Commands with Example | DBMS Lectures in Hindi

Lecture 21: L73: SQL Views, Create Views, DROP Views with examples | SQL Tutorial for Beginners

Lecture 22: L93: SQL Nested Query - Insert, Update, Select and Delete using Sub Queries | DBMS in Hindi

Data Structures(DS) Full Course (Hindi) (Part 2)

CSE/IT SERIES

Data Structures(DS) Full Course (Hindi) (Part 2)

   Friday, October 10, 2025   

Starting a new Lecture Notes Series on Data Structures(DS) Full Course

Youtube Lecture Playlist Credits 

Channel Name: Easy Engineering Classes

So Let Us Start to This Journey of Learning 

Data Structures(DS) Full Course By Lecture Notes together!

Lecture 49: L54: B+ Tree Introduction | Example of Inserting Data Elements in B+ Tree | Data Structures Hindi

Lecture 50: L55: Introduction to Graph Theory | Types of Graph | Graph Terms | Data Structures Lectures in Hindi

Lecture 51: L56: Graph Representation | Adjacency Matrix, Adjacency List | Examples | Data Structures Lectures

Lecture 52: L57: Graph Traversal | Breadth First Search(BFS) Traversal | Example | Data Structures Lectures

Lecture 53: L58: Graph Traversal | Depth First Search(DFS) Traversal | Example | Data Structures Lectures Hindi

Lecture 54: L59: BFS, DFS Graph Traversals | Breadth First Search, Depth First Search | Practice Problems

Lecture 55: L60: Topological Sort | Topological Ordering of Graph with Examples | Data Structures Lectures Hindi

Lecture 56: L61: Prims Algorithm for Minimum Spanning Tree(MST) | Greedy Method | Data Structures Lectures Hindi

Lecture 57: L62: Kruskals Algorithm for Minimum Spanning Tree(MST) | Greedy Method | Data Structures Lectures

Lecture 58: L63: Dijkstra Algorithm | Single Source Shortest Path | Greedy Method | Data Structures Lectures

Lecture 59: L64: Bellman Ford Algorithm | Single Source Shortest Path | Dynamic Programming | Data Structures

Lecture 60: L66: Selection Sort Algorithm | Complexity | Example | Data Structures Lectures in Hindi

Lecture 61: L67: Insertion Sort Algorithm | Example | Code | Data Structures Lectures in Hindi

Lecture 62: L68: Shell Sort Algorithm | Example | Data Structures Lectures in Hindi

Lecture 63: L69: Practice Problem on Shell Sort Algorithm | Question on Sorting Elements | Data Structures

Lecture 64: L70: Bubble Sort Algorithm | Example | Complexity | Data Structures Lectures in Hindi

Lecture 65: L71: Quick Sort Algorithm | Example | Complexity | Data Structures Lectures in Hindi

Lecture 66: L72: Merge Sort Algorithm | Example | Data Structures Lectures in Hindi

Lecture 67: L73: Linear Search Algorithm | Example | Data Structures Lectures in Hindi

Lecture 68: L74: Binary Search Algorithm | Example | Data Structures Lectures in Hindi

Lecture 69: L75: Hashing Techniques | Hash Function | Types of Hashing Techniques | Data Structures Lectures

Lecture 70: L76: Collision Resolution | Types of Collision Resolution Techniques with Example | Data Structures

Lecture 71: 1D Introduction, Finding Address of Linear Array in Memory, Array Initialization Example

Lecture 72: Array Operations – Traversal, Inserting Data and Deleting Data from Array in Hindi and English

Lecture 73: 2D Array Introduction – Insertion in 2D Array, Transpose of Matrix in Hindi and English

Lecture 74: 2D Array Representation in Memory – ROW MAJOR ORDER with Example in Hindi and English

Lecture 75: 2D Array Representation in Memory – COLUMN MAJOR ORDER with Example in Hindi and English

Lecture 76: Sparse Matrix – Representation using 3 Column Technique with Example in Hindi and English

Lecture 77: Sparse Matrix – Representation using Linked List Technique with Example in Hindi and English

Lecture 78: Dijkstra's Algorithm for Shortest Path Problem with Example | #DataStructure Lectures in Hindi

Lecture 79: Solved Question on Finding Resulting Binary Tree when one element with two child are deleted

Lecture 80: Graph Theory in Data Structure with Example | #DataStructure Lectures in Hindi

Lecture 81: Graph Theory - Part 2(Types of Graphs) in with example | #DataStructure Lectures in Hindi

Lecture 82: Breadth First Search Algorithm(BFS) in with Example | #DataStructure Lectures in Hindi

Lecture 83: Depth First Search Algorithm in with Example | #DataStructure Lectures in Hindi

Lecture 84: Practice Problem on Creating Adjacency Matrix from Given Set of Vertices and Edges | #DSLectures

Lecture 85: Topological Sort Algorithm with Example in Hindi | #DataStructure Lectures in Hindi

Lecture 86: Prim's algorithm for Minimum Spanning Tree with Example | #DataStructure Lectures in Hindi

Lecture 87: Kruskal algorithm for Minimum Spanning Tree with Example | #DataStructure Lectures in Hindi

Lecture 88: Data Structure Solved Question P1 - Problems on Circular Queue, Undirected Graph, Binary Tree, BST

Lecture 89: Data Structure Solved Questions P2 - MST, Connected Planar Graph, Find Binary Tree Number of Nodes

Lecture 90: Data Structure Solved Questions P3 - Binary Min Heap, B+ Tree, Connected Graph, Max Heap Problems

Lecture 91: Data Structure Solved Questions P4 - BST Post Order Traversal, Max Order of B+Tree, BST Height Ques