DBMS (Database Management System)
4.0
(2)
19 learners
What you'll learn
This course includes
- 8.5 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 24 lessons • 8.5 hours of video
DBMS (Database Management System)
24 lessons
• 8.5 hours
DBMS (Database Management System)
24 lessons
• 8.5 hours
- Lec 1: Introduction to DBMS | Database Management System 22:21
- Lec 2: File processing system in dbms | Disadvantages of file system | File System vs DBMS 23:18
- Lec 3: Super Key | Candidate Key | Primary Key | Types of keys in DBMS 35:55
- Lec 4: Functional dependency in DBMS | What is functional dependency | Database Management System 25:46
- Lec 5: Armstrong's axioms in DBMS | Inference rules of Functional Dependency 25:05
- Lec6:What is Attribute Closure |Closure set of Attribute in DBMS | How to find Closure of Attributes 27:46
- Lec 7: How to Find Number of Candidate Keys in a Relation - part 1 | DBMS Tutorials 18:49
- Lec 8: Finding number of candidate keys in relation - part 2 | DBMS 20:46
- Lec 9: Normalization in DBMS | Need of Normalization | DBMS Tutorials 23:32
- Lec 10: First Normal Form in DBMS | 1NF with example | Normalization in DBMS 22:10
- Lec 11: Second Normal Form in DBMS | 2NF in DBMS | Normalization in DBMS 21:38
- Lec 12: Third Normal Form in DBMS | 3NF with example | Normalization in DBMS 23:45
- Lec 13: BCNF in DBMS | Boyce Codd Normal Form | Normalization in DBMS 23:53
- Lec 14: How to find out Normal form of a Relation| how to identify Highest Normal Form | part1 22:49
- Lec15: Find Highest Normal Form of a Relation| Practice Problem - part2 | Normalization in DBMS 12:49
- Lec 16: Dependency preserving decomposition in DBMS | with example | DBMS Tutorials for beginners 26:26
- Lec 17: Dependency Preserving Decomposition in DBMS | Practice Problem 18:39
- Lec 18: Lossless Join Decomposition | Non Additive Join Decomposition Property | DBMS Tutorials 21:57
- Lec 19: Practice Problem on Lossless Join Decomposition | DBMS Tutorials 21:23
- Lec 21: What is Canonical Cover in DBMS | Minimal cover Irreducible with example 16:17
- Lec 20: Problem on Lossless Join Decomposition in DBMS | Check whether Decomposition is Lossless 09:30
- Lec 22: How to Decompose a Relation into 2NF (Second Normal Form) | DBMS 23:30
- Lec23: How to Decompose a Relation into 3NF(Third Normal Form) with example | Convert 2NF to 3NF 16:35
- Lec 24: How to Normalize a Relation Table in DBMS | with example 16:21
Take this course with you
Download the app to continue lessons from your phone anytime.
