As a security analyst, you’ll often need data from more than one table. SQL joins help combine data from related tables in a relational database by matching columns they share.
In this lab activity, I used SQL joins to connect separate tables and retrieve needed information as part of a system investigation.
A recent security incident compromised some machines. I was responsible for retrieving information from the organization’s database to support the investigation.
First, I used an INNER JOIN to identify which employees were using which machines.
Second, I used LEFT JOIN and RIGHT JOIN to find unassigned machines and users without assigned machines.
Finally, I used an INNER JOIN to list login attempts made by all employees.
I successfully completed this activity and gained hands-on experience using joins to combine data from multiple tables.
I used:
INNER JOINLEFT JOINRIGHT JOINThese joins enabled me to investigate system usage and employee login data accurately and efficiently.