This video explain all Relational Algebra operations under various categories.
Unary Relational Operations
SELECT ( (sigma))
PROJECT ( (pi))
RENAME ( (rho))
Relational Algebra Operations From Set Theory
UNION ( ), INTERSECTION ( ), DIFFERENCE(– )
CARTESIAN PRODUCT ( x )
Binary Relational Operations
JOIN (Natural join, equi join)
DIVISION
Additional Relational Operations
OUTER JOINS
AGGREGATE FUNCTIONS (SUM, COUNT, AVG, MIN, MAX)
