Complete Course on Database Management System (DBMS) - Part I
PREVIEW
English
Complete Course on Database Management System (DBMS) - Part I
Ravindrababu Ravula
In this course, Ravindra Babu Ravula will cover DBMS. All the important topics will be discussed in detail and would be helpful for aspirants preparing for the GATE exam. Learners at any stage of their preparati... Read more
Ended on May 24
Mar 17 - May 24, 2021
42 lessons
0 practices
0 questions by educators
Week 1
Mar 15 - 21
4 lessons
Mar
17
Introduction to DBMS, Database Models, Introduction to ER Model and Attributes
Lesson 1 • Mar 17 • 1h 9m
Mar
18
Relationships 1: Many, Relationships 1:, Relationships M:N Examples and Recursive Relationships
Lesson 2 • Mar 18 • 59m
Mar
19
Attributes to Relationships, Weak Entity and ER Diagram Notations
Lesson 3 • Mar 19 • 58m
Mar
20
Introduction to Relational Database, Terminology of Relational Database, Tuple, Tuple Values & Null
Lesson 4 • Mar 20 • 55m
Week 2
Mar 22 - 28
5 lessons
Mar
22
Constraints on Relational DB Schema
Lesson 5 • Mar 22 • 1h 1m
Mar
23
Actions upon Constraint Violations, Entity and Referential Integrity Constraints
Lesson 6 • Mar 23 • 56m
Mar
25
Conversion of ER Model to Relational Model Steps
Lesson 7 • Mar 25 • 55m
Mar
26
Summary of ER to RDB Conversion & GATE Questions
Lesson 8 • Mar 26 • 54m
Mar
27
GATE Questions on Converting ER to RDB, Questions on Referential Integrity
Lesson 9 • Mar 27 • 55m
Week 3
Mar 29 - Apr 4
6 lessons
Mar
29
Introduction to FDs, Formal Definition of FDs and Various Usages of FDs
Lesson 10 • Mar 29 • 57m
Mar
30
Closure Set of Attributes & GATE Questions
Lesson 11 • Mar 30 • 51m
Mar
31
Examples on Candidate Key - Candidate Key for Sub Relation - Examples
Class was cancelled by the Educator
Apr
1
Checking Additional FDs and Equivalence of FDs with Examples
Lesson 13 • Apr 1 • 58m
Apr
2
Minimal Cover with Examples, Lossless Decomposition, FD Preserving and Decomposition Examples
Lesson 14 • Apr 2 • 55m
Apr
3
First Normal Form, Second Normal Form Introduction, Third Normal Form Introduction with Examples
Lesson 15 • Apr 3 • 58m