Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Name the six basic relational algebra operators and what each one does.
- Translate a simple SQL query into the relational algebra expression it corresponds to.
- Explain why a join can be defined entirely from a Cartesian product plus a selection.
- Recognize relational algebra notation when it appears in later, deeper modules.
SQL is one way to express a query. Relational algebra is the small set of formal operators underneath it. Seeing the operators named directly makes later modules on query optimization easier to follow, since an optimizer reasons in terms close to these operators, not SQL text.