Database Management – BBA-II

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