DBMS Video Lectures

 DBMS Video Lectures

Mumbai University

Second Year Computer Engineering

Syllabus:

1 Introduction Database Concepts 

1.1 Introduction, Characteristics of databases, File system v/s Database system, Data abstraction and data Independence, DBMS system architecture, Database administrator

2 Entity–Relationship Data Model 

2.1 The Entity-Relationship (ER) Model: Entity types: Weak and strong entity sets, Entity sets, Types of Attributes, Keys, Relationship constraints: Cardinality and Participation, Extended Entity-Relationship (EER) Model: Generalization, Specialization and Aggregation

3 Relational Model and relational Algebra 

3.1 Introduction to the Relational Model, relational schema and concept of keys. Mapping the ER and EER Model to the Relational Model, Relational Algebra-operators, Relational Algebra Queries.

4 Structured Query Language (SQL) 

4.1 Overview of SQL, Data Definition Commands, Integrity constraints: key constraints, Domain Constraints, Referential integrity , check constraints, Data Manipulation commands, Data Control commands, Set and string operations, aggregate function-group by, having, Views in SQL, joins, Nested and complex queries, Triggers

5 Relational-Database Design 

5.1 Pitfalls in Relational-Database designs, Concept of normalization, Function 

Dependencies, First Normal Form, 2NF, 3NF, BCNF.

6 Transactions Management and Concurrency and Recovery 

6.1 Transaction concept, Transaction states, ACID properties, Transaction Control Commands, Concurrent Executions, Serializability-Conflict and View, Concurrency Control: Lock-based, Timestamp-based protocols, Recovery System: Log based recovery, Deadlock handling.

Textbooks:

1 Korth, Slberchatz, Sudarshan, Database System Concepts, 6thEdition, McGraw Hill 

2 Elmasri and Navathe, Fundamentals of Database Systems, 5thEdition, Pearson Education 

3 Raghu Ramkrishnan and Johannes Gehrke, Database Management Systems, TMH

References:

1 Peter Rob and Carlos Coronel, Database Systems Design, Implementation and 

Management‖, Thomson Learning, 5thEdition. 

2 Dr. P.S. Deshpande, SQL and PL/SQL for Oracle 10g, Black Book, Dreamtech Press.

3 G. K. Gupta, Database Management Systems, McGraw Hill, 2012

Video Lecture Details:

Module-01  Introduction Database Concepts 

Lecture 01: Drawbacks of File Processing System (FPS)- https://www.youtube.com/watch?v=eU6neWkd82A&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8

Lecture 02: Levels of abstraction in DBMS | Levels of Data Abstraction- https://www.youtube.com/watch?v=ft5BoSp4oiQ&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=2

Lecture 03: Physical Data Independence and Logical Data Independence- https://www.youtube.com/watch?v=9BH2BFUrz94&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=3

Module-02 Entity–Relationship Data Model 

Lecture 04: Types of Attributes | Attributes Representation in ER Diagram- https://www.youtube.com/watch?v=FISIYCyvx4Q&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=4

Lecture 05: Mapping Cardinality Constraints in ER | Mapping Cardinality- https://www.youtube.com/watch?v=AMPhsQxg7Fo&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=5

Lecture 06: Attribute of Relationship Set- https://www.youtube.com/watch?v=WyVDN5SmFcA&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=6

Lecture 07: Roles in ER Diagram- https://www.youtube.com/watch?v=39LweqXJZkw&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=7

Lecture 08: Participation Constraints in ER Diagram- https://www.youtube.com/watch?v=GhjAX_L_ScA&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=8

Lecture 09: Ternary Relationship in ER Diagram- https://www.youtube.com/watch?v=9GIOjXPywOE&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=9

Module-03  Relational Model and relational Algebra

Lecture 10: EER Diagram Features- Specialization, Generalization and Aggregation- https://www.youtube.com/watch?v=sqtWQS8J42w&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=10

Lecture 11: ER Diagram- HOW TO DESIGN? | ER Diagram for Bank Database System- https://www.youtube.com/watch?v=UR6bSz4o_4w&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=11

Lecture 12: How to map an ER Diagram to Relational Schema? | Mapping of an ER Diagram to Relational Schema- https://www.youtube.com/watch?v=f7oC0_QdGwQ&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=12

Lecture 13: Strong Entity Vs Weak Entity- https://www.youtube.com/watch?v=wiwbjuYEAFM&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=13

Module-04 Structured Query Language (SQL) 

Lecture 14: Introduction to SQL| Introduction to Oracle SQL| SQL Tutorial for beginner- https://www.youtube.com/watch?v=7x0BJgEI7ac&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=17

Lecture 15: SQL Datatypes | Datatypes in SQL- https://www.youtube.com/watch?v=29EaVyQthQk&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=15

Lecture 16: How to create trigger in SQL | Trigger for insert, update and delete in SQL Live Demo- https://www.youtube.com/watch?v=LzaoinqcnvU&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=14

Lecture 17: PLSQL program to check the given number is Palindrome or not- https://www.youtube.com/watch?v=t00PoxQRQew&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=15

Module-05 Relational-Database Design 

Lecture 18: Normalization in DBMS | What is Normalization? | Why we need normalization? - https://www.youtube.com/watch?v=SmfRcGo0X_k&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=18

Lecture 19: MCQs on Normalization in DBMS- https://www.youtube.com/watch?v=U7GBGNXY6PA&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=19

Lecture 20: Boyce–Codd normal form (BCNF) & 4NF in DBMS | Boyce Codd normal form- https://www.youtube.com/watch?v=C3OKm3o43ZA&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=20

Lecture 21: 3NF Vs BCNF in DBMS- https://www.youtube.com/watch?v=9zAcc7M2XH0&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=21

Module-06 Transactions Management and Concurrency and Recovery 

Lecture 22: Transaction State Diagram | Transaction State Diagram in DBMS- https://www.youtube.com/watch?v=SBbeS1eP0-A&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=22

Lecture 23: Concurrent Execution of Transactions | Advantages of Concurrent Execution- https://www.youtube.com/watch?v=Mrdznwhsf2g&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=23

Lecture 24: Transaction Schedules in DBMS | Serial Schedule |Concurrent schedule- https://www.youtube.com/watch?v=KnTmTW6oi-o&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=24

Lecture 25: Consistency check of Serial Schedule | Transaction schedule | Schedules- https://www.youtube.com/watch?v=Nx0k8P4qS0s&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=25

Lecture 26: Consistency check for Serial Schedule 2 | Serial Schedule S2- https://www.youtube.com/watch?v=TFQ4BrhH4ZA&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=26

Lecture 27: Consistency check for Concurrent Schedule 3 |Concurrent Schedule S3- https://www.youtube.com/watch?v=ugGn3MrnBEo&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=27

Lecture 28: Consistency check for Concurrent schedule 4- https://www.youtube.com/watch?v=ZBnmRyVgaSk&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=28

Lecture 29: Conflict Serializability | Conflict Serializable Schedule- https://www.youtube.com/watch?v=tDoxfwxAeJA&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=29

Lecture 30: View serializability | View serializability in DBMS- https://www.youtube.com/watch?v=rU832SVZNBU&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=30

Lecture 31: How to test Serializability? | Testing Serializability | Precedence Graph- https://www.youtube.com/watch?v=Vo-Ljf267MM&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=31

Lecture 32: Concurrency Control and Problems Due to concurrency- https://www.youtube.com/watch?v=RLY39p-PIYk&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=32

Lecture 33: Concurrency control protocols |Lock Based Protocols| Timestamp Ordering Protocol- https://www.youtube.com/watch?v=JCzl2Jtfj7E&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=33

Lecture 34: Recovery System | Failure Classification | Log Based Recovery | Checkpoint in DBMS- https://www.youtube.com/watch?v=aiUHH713_K0&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=34

Lecture 35: Deadlock | Deadlock Avoidance | Deadlock Detection | Deadlock Prevention in DBMS- https://www.youtube.com/watch?v=tKYjpH-KVsI&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=35

Lecture 36: MCQs on Database Management System | DBMS top 150 MCQs | MCQs on DBMS and SQL | 150 MCQs- https://www.youtube.com/watch?v=mndVJqjpjcM&list=PL30dC-5PIyXkTebQdXRk6wdW1_QvLpIg8&index=36

For any query feel free to contact me on 7718954854 (What’s up only)

Prepared by,

Prof. Mahendra Patil