ConceptSystems & CS
Semi joins
A join operation where the result only contains columns from the left table, used in distributed DBMSs to minimize the amount of data sent over the network.
Know first
Named as a prerequisite by the lectures that define this. The number is how many say so. A grey one has no page yet.
Lecturers
2Each in their own terms, from the easiest level.
Tyler Cloutier
Filtering on a table where you are always querying a table.
Connections
4The lectures that define it or assume it, and the concepts next to it.