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 4
Advanced Queries with Subqueries
1
Scalar Subqueries in WHERE Clauses
Write a scalar subquery in a WHERE clause to filter based on a single computed value.
2
Filtering with IN and Subqueries
Use IN with a subquery to filter against a set of values from another table.
3
Checking for Related Records with EXISTS
Use EXISTS and NOT EXISTS to check for the presence of related records.
4
Correlated Subqueries
Write correlated subqueries that reference the outer query.
5
Derived Tables with Subqueries
Use a subquery in the FROM clause to create a derived table for further querying.
6
Identifying Repeated Failed Logins with Subqueries
Practice using subqueries to identify repeated failed login attempts from specific IPs.
Previous module
Combining Data from Multiple Tables
Next module
Modifying Data (DML)