SQL lab
SQL joins
Run INNER, LEFT, RIGHT, FULL and CROSS joins on the same two tables and compare the rows.
Notice that the outer joins only ever add rows to the inner join's result, and that CROSS is simply every pairing.
Learn the concept
The lesson this lab comes from, with the explanation, a practice task and a quiz.
More labs
All labs- SQLIndex vs sequential scanCount the pages a sequential scan and a B-tree index lookup read to find one row.
- GitGit graphType real Git commands and watch commits, branches and HEAD move on a live commit graph.
- AITokenizerSplit text into tokens with a toy vocabulary and see why code and rare words cost more.