محتوى الدورة
Lec 1: Introduction to DBMS | Database Management System Lec 2: File processing system in dbms | Disadvantages of file system | File System vs DBMS Lec 3: Super Key | Candidate Key | Primary Key | Types of keys in DBMS Lec 4: Functional dependency in DBMS | What is functional dependency | Database Management System Lec 5: Armstrong's axioms in DBMS | Inference rules of Functional Dependency Lec6:What is Attribute Closure |Closure set of Attribute in DBMS | How to find Closure of Attributes Lec 7: How to Find Number of Candidate Keys in a Relation - part 1 | DBMS Tutorials Lec 8: Finding number of candidate keys in relation - part 2 | DBMS Lec 9: Normalization in DBMS | Need of Normalization | DBMS Tutorials Lec 10: First Normal Form in DBMS | 1NF with example | Normalization in DBMS Lec 11: Second Normal Form in DBMS | 2NF in DBMS | Normalization in DBMS Lec 12: Third Normal Form in DBMS | 3NF with example | Normalization in DBMS Lec 13: BCNF in DBMS | Boyce Codd Normal Form | Normalization in DBMS Lec 14: How to find out Normal form of a Relation| how to identify Highest Normal Form | part1 Lec15: Find Highest Normal Form of a Relation| Practice Problem - part2 | Normalization in DBMS Lec 16: Dependency preserving decomposition in DBMS | with example | DBMS Tutorials for beginners Lec 17: Dependency Preserving Decomposition in DBMS | Practice Problem Lec 18: Lossless Join Decomposition | Non Additive Join Decomposition Property | DBMS Tutorials Lec 19: Practice Problem on Lossless Join Decomposition | DBMS Tutorials Lec 21: What is Canonical Cover in DBMS | Minimal cover Irreducible with example Lec 20: Problem on Lossless Join Decomposition in DBMS | Check whether Decomposition is Lossless Lec 22: How to Decompose a Relation into 2NF (Second Normal Form) | DBMS Lec23: How to Decompose a Relation into 3NF(Third Normal Form) with example | Convert 2NF to 3NF Lec 24: How to Normalize a Relation Table in DBMS | with example

للحصول على شهادة

  • 1- التسجيل
  • 2- مشاهدة الكورس كاملا
  • 3- متابعة نسبة اكتمال الكورس تدريجيا
  • 4- بعد الانتهاء تظهر الشهادة في الملف الشخصي الخاص بك