In a nutshell
Relational algebra is the small set of operations every SQL query is built from. Each one takes one or two tables and produces a new table: selection keeps the rows that pass a test, projection keeps only the columns you name, join stitches two tables together on a shared value, and union and difference combine two same-shaped tables. Because the output is itself a table, you can chain the operators to express any query.