Students will learn how access data from multiple tables using different types of joins
To combine columns from several tables into a result table we need to use a join operation. The SQL join operation combines information from two tables by forming pairs of related rows from the two tables. The row pairs that make up the joined table are those where the matching columns in each of the two tables have the same value.
If we need to access data from more than one table, the choice is between using a subquery and using a join. If the final result table is to contain columns from different tables, then we must use a join.
To earn PASS status, system is about to evaluate you using multiple choice questions (MCQs) and True/False type questions.