Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
SQL for Cyber Security
·
Module 3
Combining Data from Multiple Tables
1
Understanding Primary and Foreign Keys in Database Schemas
Identify primary and foreign key relationships by examining a database schema.
2
Using INNER JOIN to Combine Tables
Write an INNER JOIN to combine matching rows from two or more tables.
3
Understanding LEFT JOIN for Comprehensive Data Retrieval
Use LEFT JOIN to include all records from the 'left' table, even with no match.
4
Combining Result Sets with UNION
Use UNION to combine the result sets of two or more SELECT statements.
5
Joining Log Data for User Activity Analysis
Practice correlating user, login, and access log tables using JOINs.
Previous module
Manipulating Data with Functions
Next module
Advanced Queries with Subqueries