~Get Your Files Here !

  01 - Keys Candidate key, Primary key, Super key, Foreign Key

   001 Types of keys_en.srt

   002 Candidate Key_en.srt

   003 Primary Key_en.srt

   004 Alternate Key_en.srt

   005 Super Key_en.srt

   006 Foreign Key_en.srt

  02 - Functional Dependency (FD)

   001 Functional Dependency Introduction, Examples_en.srt

   002 Types of Functional Dependencies Trivial and Non-Trivial FD's_en.srt

   003 FD Example_en.srt

   004 Inference Rules_en.srt

   005 Attribute Closure Example 2_en.srt

   006 Attribute Closure Example 3_en.srt

   007 Attribute Closure Example 4_en.srt

   008 Applications of Attribute Closure_en.srt

   009 Application 1 Finding additional FD's_en.srt

   010 Application 2 Finding keys in a relation - Example 1 & 2_en.srt

   011 Application 2 Finding keys in a relation - Example 3 & 4_en.srt

   012 Application 2 Finding keys in a relation - Example 5 & 6_en.srt

   013 Application 2 Finding keys in a relation - Example 7 & 8_en.srt

   014 Application 2 Finding keys in a relation - Example 9 & 10_en.srt

   015 Application 2 Finding keys in a relation - Example 11 & 12_en.srt

   016 Application 2 Finding keys in a relation - Example 13 & 14_en.srt

   017 Application 3 Equivalence of Functional Dependencies - Example 1_en.srt

   018 Application 3 Equivalence of Functional Dependencies - Example 2_en.srt

   019 Application 3 Equivalence of Functional Dependencies - Example 3_en.srt

   020 Application 3 Equivalence of Functional Dependencies - Example 4_en.srt

   021 Application 4 Irreducible set and Algorithm_en.srt

   022 Application 4 Irreducible set - Example 1_en.srt

   023 Application 4 Irreducible set - Example 2_en.srt

   024 Partial Functional Dependency and Full Functional Dependency_en.srt

   025 Anomalies Update, Deletion and Insertion Anomaly_en.srt

  03 - Normalization

   001 Normalization Introduction and types_en.srt

   002 First Normal Form (1NF)_en.srt

   003 Second Normal Form ( 2NF)_en.srt

   004 2NF Examples - 1, 2, 3, 4 and NOTE_en.srt

   005 Third Normal Form ( 3NF)_en.srt

   006 3NF Examples - 1, 2_en.srt

   007 3NF Example - 3_en.srt

   008 3NF Example - 4_en.srt

  04 - Structured Query Language ( SQL )

   001 SELECT statement structure and evaluation order_en.srt

   002 SELECT clause Syntax and examples_en.srt

   003 DISTINCT keyword in SELECT clause_en.srt

   004 WHERE clause Introduction_en.srt

   005 WHERE clause Operators_en.srt

   006 WHERE clause Logical Operators - AND, OR, NOT_en.srt

   007 WHERE clause AND, OR, NOT - Together_en.srt

   008 ORDER BY clause ASC, DESC_en.srt

   009 Aggregate Functions SUM(), AVG(), MIN(), MAX()_en.srt

   010 Aggregate Functions COUNT()_en.srt

   011 Joins Introduction, Cross Join_en.srt

   012 Joins Theta Join Conditional Join_en.srt

   013 Joins Equi Join_en.srt

   014 Joins Natural Join_en.srt

   015 Joins Self Join_en.srt

   016 Outer Join Introduction_en.srt

   017 Joins Left Outer Join_en.srt

   018 Joins Right Outer Join_en.srt

   019 Joins Full Outer Join_en.srt

  05 - Relational Algebra (RA) and Relational Calculus (RC)

   001 Relational Algebra Introduction_en.srt

   002 RA Selection and Projection Operators_en.srt

   003 RA Set Manipulation Operators(Union, Intersection, Difference)_en.srt

   004 RA Set Manipulation Operators - UNION_en.srt

   005 RA Set Manipulation Operators - INTERSECTION_en.srt

   006 RA Set Manipulation Operators - SET DIFFERENCE_en.srt

   007 RA Cartesian Product_en.srt

   008 RA Rename Operator_en.srt

   009 RA Join introduction and Types_en.srt

   010 RA Conditional Join Theta Join_en.srt

   011 RA Equijoin_en.srt

   012 RA Natural Join_en.srt

   013 RA Outer Join_en.srt

   014 RA Left Outer Join_en.srt

   015 RA Right Outer Join_en.srt

   016 RA Full Outer Join_en.srt

  Bonus Resources.txt