| 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 |