# Module 8: MySQL Joins

MODULE OVERVIEW

This module focuses on using MySQL joins to retrieve and combine related
information from multiple database tables.



Learners will explore different join operations, including INNER JOIN, OUTER
JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN and SELF JOIN.



The module also covers DELETE JOIN and the differences between UNION and JOIN.
These concepts help participants work with relational database structures,
retrieve connected business information and prepare consolidated datasets for
reporting and analysis.






WHAT WILL BE COVERED


8.1 INNER JOIN

 * Understanding the purpose of INNER JOIN in MySQL.

 * Combining records from two or more related tables.

 * Identifying matching records using common columns.

 * Retrieving only records that have matching values in both tables.

 * Using INNER JOIN to connect related business information, such as customer
   orders and product details.


8.2 OUTER JOIN

 * Understanding the concept of OUTER JOIN.

 * Exploring how outer joins retrieve matching and non-matching records.

 * Understanding the role of LEFT OUTER JOIN and RIGHT OUTER JOIN.

 * Identifying records that exist in one table but not in another.

 * Using outer joins to analyse related business information across tables.


8.3 LEFT JOIN

 * Understanding how LEFT JOIN works in MySQL.

 * Retrieving all records from the left table.

 * Including matching records from the right table.

 * Understanding how NULL values appear when no matching record exists.

 * Identifying business records that do not have corresponding information in
   another table.


8.4 RIGHT JOIN

 * Understanding how RIGHT JOIN works in MySQL.

 * Retrieving all records from the right table.

 * Including matching records from the left table.

 * Identifying records without corresponding matches in the left table.

 * Using RIGHT JOIN to analyse relationships between business datasets.


8.5 CROSS JOIN

 * Understanding the purpose of CROSS JOIN.

 * Combining every row from one table with every row from another table.

 * Understanding Cartesian products in relational databases.

 * Exploring the structure of CROSS JOIN results.

 * Applying CROSS JOIN when combinations of records are required.


8.6 SELF JOIN

 * Understanding the concept of SELF JOIN.

 * Joining a table with itself.

 * Using table aliases to distinguish between table references.

 * Identifying relationships between records within the same table.

 * Applying SELF JOIN to analyse hierarchical relationships, such as employee
   and manager records.


8.7 DELETE JOIN

 * Understanding the purpose of DELETE JOIN in MySQL.

 * Deleting records using relationships between multiple tables.

 * Identifying target records through join conditions.

 * Applying conditions to control which records are deleted.

 * Understanding the importance of reviewing affected records before executing
   deletion operations.


8.8 UNION VS JOIN

 * Understanding the purpose of UNION and JOIN in MySQL.

 * Exploring how JOIN combines related columns from multiple tables.

 * Understanding how UNION combines the results of multiple SELECT queries.

 * Comparing the structure and output of UNION and JOIN operations.

 * Identifying when to use each operation for data retrieval and consolidation.


SKILLS YOU WILL GAIN

 * Combining related records using INNER JOIN.

 * Understanding and applying OUTER JOIN operations.

 * Retrieving matching and non-matching records using LEFT JOIN and RIGHT JOIN.

 * Generating combinations of records using CROSS JOIN.

 * Joining a table with itself using SELF JOIN.

 * Managing related records through DELETE JOIN.

 * Understanding the differences between UNION and JOIN.

 * Retrieving information from multiple related database tables.


LEARNING OUTCOMES

By the end of this module, learners will be able to:

 * Combine customer, order, product and transaction records using appropriate
   SQL join operations.

 * Retrieve matching and non-matching business records using INNER JOIN and
   OUTER JOIN techniques.

 * Identify missing relationships between datasets using LEFT JOIN and RIGHT
   JOIN.

 * Apply CROSS JOIN to generate combinations of records for specific business
   analysis requirements.

 * Use SELF JOIN to analyse hierarchical business relationships, such as
   organisational reporting structures.

 * Apply DELETE JOIN carefully when managing related records across database
   tables.

 * Choose between UNION and JOIN based on whether business information needs to
   be combined vertically or horizontally.

 * Develop multi-table SQL queries to support consolidated reporting and
   business data analysis.


CERTIFICATION ALIGNMENT

This module develops relational database querying and join concepts that support
the Oracle MySQL Database Administrator certification pathway. The topics help
learners retrieve related information, understand table relationships and work
with multiple database tables effectively.


CONTINUE TO THE NEXT MODULE

Continue to Module 9: Flow Control and Conditional Functions
[https://teamacademy.help.center/article/1371-module-9-flow-control-and-conditional-functions]
to learn how to use IF(), IFNULL(), NULLIF(), CASE and MySQL control flow
statements such as LOOP, WHILE, REPEAT, ITERATE, LEAVE and RETURN.