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 1
Foundational SQL Queries
1
Selecting Specific Columns
Write a SELECT statement to retrieve specific columns from a single table.
2
Filtering Rows with WHERE
Use the WHERE clause to filter rows based on a single condition.
3
Filtering Data with Comparison Operators
Apply comparison operators (=, <>, <, >, LIKE, IN, BETWEEN) in WHERE clauses.
4
Combining Conditions with Logical Operators
Combine multiple conditions using AND, OR, and NOT operators.
5
Checking for Missing Data (IS NULL and IS NOT NULL)
Filter for the presence or absence of data using IS NULL and IS NOT NULL.
6
Sorting Query Results with ORDER BY
Sort query results using ORDER BY with ascending and descending options.
7
Filtering Results with LIMIT/TOP
Limit the number of rows returned using LIMIT/TOP clauses.
8
Querying User Account Databases
Practice retrieving data from a sample user accounts database.
Previous module
Next module
Manipulating Data with Functions