1. Relational Data Model

In this 27 mins Video Lesson

Introduction, Degree / Arity, Domain, Domain Constraint, Key Constraint, Entity Constraint, Referntial Integrity, Integrity Constriants, and other topics.

Introduction, Degree / Arity, Domain, Domain Constraint, Key Constraint, Entity Constraint, Referntial Integrity, Integrity Constriants, and other topics.

2. Relational Algebra - Selection, Projection and Set Operations

In this 33 mins Video Lesson

Introduction, Select Operator, Project Operator, Set Operations, Union Operator, Intersection Operator, Set Difference Operator, and other topics.

Introduction, Select Operator, Project Operator, Set Operations, Union Operator, Intersection Operator, Set Difference Operator, and other topics.

3. Relational Algebra - Rename, Joins, Assignment and Division Operator

In this 42 mins Video Lesson

Introduction, Rename , Cartesian Product, Natural Join, Outer Joins, Assignment Operator, Division Operator, and other topics.

Introduction, Rename , Cartesian Product, Natural Join, Outer Joins, Assignment Operator, Division Operator, and other topics.

4. Generalized Projection, Aggregate Functions, DB Modifications and Views

In this 40 mins Video Lesson

Introduction, Generalized Projection, Aggregate Functions, Database Modification, Deletion, Insertion, Updation, Views, and other topics.

Introduction, Generalized Projection, Aggregate Functions, Database Modification, Deletion, Insertion, Updation, Views, and other topics.

Relational Algebra
(2.07 Mb)

Relational Data Model
(1.16 Mb)

Basic concepts, Attributes and Domains, Relational Integrity: Domain, Entity, Referential Integrities, Enterprise Constraints, Views, Schema Diagram

Relational Algebra