Comprehensive Course on DBMS - Part I
PREVIEW
English
Comprehensive Course on DBMS - Part I
Illapu S Srinivasa Rao
In this course, Illapu S Srinivasa Rao will cover DBMS - Part I. The course includes 11 sessions of 120 minutes each. All the important topics will be discussed in detail and would be helpful for aspirants prepa... Read more
Ended on Sep 24
Sep 14 - Sep 24, 2020
11 lessons
0 practices
0 questions by educators
Week 1
Sep 14 - 20
7 lessons
Sep
14
Introduction to DBMS, Relational Data Model, Functional Dependency - Complete Discussion
Lesson 1 • Sep 14 • 2h 2m
Sep
15
Discussion on Functional dependency, Attribute Closure, Keys in Schema Design - complete discussion
Lesson 2 • Sep 15 • 2h 2m
Sep
16
Decomposition and Properties of decomposition - Discussion with shortcuts
Lesson 3 • Sep 16 • 2h 6m
Sep
17
Doubt Clearing Session
Lesson 4 • Sep 17 • 2h 3m
Sep
18
Need of Schema Design in real time , Un-Normalized DB, Conversion Un-Normalized to to 1NF
Lesson 5 • Sep 18 • 2h 4m
Sep
19
1NF, 2NF, 3NF, BCNF -complete discussion with problems of each normal form
Lesson 6 • Sep 19 • 2h 1m
Sep
20
Normalization, Dependencies, MVDS and 4NF
Lesson 7 • Sep 20 • 2h 2m
Week 2
Sep 21 - 27
4 lessons
Sep
21
Doubt Clearing Session
Lesson 8 • Sep 21 • 2h 4m
Sep
22
ER - Model Importance, Terminology, Conversion To Relational Model
Lesson 9 • Sep 22 • 2h 5m
Sep
23
Languages of SQL, Constraints in SQL and Functions
Lesson 10 • Sep 23 • 2h 7m
Sep
24
Importance of Joins, Types of Joins and Doubt Clearing Session
Lesson 11 • Sep 24 • 2h 7m