Detailed Course on Database Management Systems - UGC NET Dec 22

PREVIEW

Hindi

Detailed Course on Database Management Systems - UGC NET Dec 22

Nisha Mittal

In this course, Nisha Mittal will cover Database Management Systems. A few other concepts covered are Entity Relationship Diagram and Normalization. All the important topics will be discussed in detail and would... Read more

Started on Oct 22

Oct 22, 2022 - Jan 21, 2023

25 lessons

0 practices

0 questions by educators

Week 1

Oct 17 - 23

2 lessons

Oct

22

Database Normalization: Closure, Keys, Prime, and Non Prime Attributes

Lesson 1 • Oct 22 • 1h

Oct

23

Normalization

Lesson 2 • Oct 23 • 1h 2m

Week 2

Oct 24 - 30

7 lessons

Oct

24

Normalization and Its Types

Lesson 3 • Oct 24 • 1h

Oct

25

ER Model: Basic DBMS Three Levels Architecture

Lesson 4 • Oct 25 • 59m

Oct

26

Doubt Clearing Session

Lesson 5 • Oct 26 • 1h

Oct

27

ER Model: Entity-Relationship Diagram

Lesson 6 • Oct 27 • 59m

Oct

28

ER Model: Relational Model Concepts

Lesson 7 • Oct 28 • 1h

Oct

29

Concurrency Control: Conflict and View Serializability

Lesson 8 • Oct 29 • 1h

Oct

30

Concurrency Control Protocol

Lesson 9 • Oct 30 • 1h

Week 3

Oct 31 - Nov 6

7 lessons

Nov

1

Database Normalization: Recoverable, Cascadeless, and Strict Schedule

Lesson 10 • Nov 1 • 1h

Nov

2

Database Normalization: Decomposition of Tables and Dependency Preservation

Lesson 11 • Nov 2 • 1h

Nov

3

Database Normalization: Armstrong’s Axioms and Minimal Cover

Lesson 12 • Nov 3 • 59m

Nov

4

Concepts and Architecture: Joins

Lesson 13 • Nov 4 • 15m

Nov

5

Doubt Clearing Session

Lesson 14 • Nov 5 • 1h

Nov

5

Concepts and Architecture: Joins

Lesson 15 • Nov 5 • 1h

Nov

6

Relational Algebra and Relational Calculus

Lesson 16 • Nov 6 • 1h 3m