Lecture No. | Description | Watch Videos |
---|---|---|
Lecture 1 | Introduction to Database Systems: File System versus a DBMS | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 2 | Advantages of a DBMS | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 3 | Describing and Storing Data in a DBMS | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 4 | Queries in a DBMS | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 5 | Structure of a DBMS | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 6 | People who deal with Database | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 7 | Introduction to Data Models | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 8 | Introduction to Data Models | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 9 | Architecture of DBMS | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 10 | Entity Relationship Model: Overview of Database Design | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 11 | Entities, attributes, and Entity Sets | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 12 | Relationships and Relationship Sets | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 13 | Additional Features of the ER Model | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 14 | Conceptual Database Design with the ER Model | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 15 | Entity versus Attribute, Entity versus Relationship | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 16 | Relational Model: Introduction to Relational Model | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 17 | Foreign Key Constraints, Enforcing Integrity Constraints, Querying Relational Data | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 18 | Logical Database Design: ER to Relation, Introduction to Views | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 19 | Destroying/Altering Tables and Views | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 20 | Codd’s Rules | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 21 | Schema Refinement & Normal Forms: Introduction to Schema Refinement | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 22 | Introduction to Schema Refinement | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 23 | Functional Dependencies | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 24 | Functional Dependencies | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 25 | Examples Motivation Schema Refinement | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 26 | Reasoning About Functional Dependencies | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 27 | Normal Forms | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 28 | Decompositions-1 | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 29 | Decompositions-2 | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 30 | Normalization-1 (Up to 3rd Normal Form) | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 31 | Normalization-2 (Up to 3rd Normal Form) | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 32 | Concept of Objects: Objects, Tables, Queries, Forms, Reports, Modules | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 33 | Tables, Queries, Forms, Reports, Modules | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 34 | Database Creation and Manipulation | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 35 | Database Creation and Manipulation | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 36 | SQL Queries: the Form of a Basic SQL Query-1 | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 37 | SQL Queries: the Form of a Basic SQL Query-2 | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 38 | Union | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 39 | Intersect | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 40 | Expect | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 41 | Introduction to Nested Queries | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 42 | Introduction to Nested Queries | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 43 | Aggregate Operators-1 | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 44 | Aggregate Operators-2 | Lecture by A, Lecture by B, Lecture by C, Lecture by D |
Lecture 45 | Null Values | Lecture by A, Lecture by B, Lecture by C, Lecture by D |