Back to Database Management System

Relational Algebra & Calculus

Learn the formal, procedural query language of relational algebra and the non-procedural language of relational calculus, which form the theoretical basis for SQL.

2 weeks

Topics in this Chapter

1

Select Operation (σ)

Filter rows from a relation based on a selection condition.

2

Project Operation (π)

Select a subset of columns from a relation.

3

Union Operation (∪)

Combine the tuples of two relations.

4

Join Operation (⨝)

Combine related tuples from two different relations.

5

Set Difference Operation (−)

Find tuples that are in one relation but not in another.

6

Tuple & Domain Calculus

A brief overview of the non-procedural relational calculus.

GeekDost - Roadmaps & Snippets for Developers