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 2
Manipulating Data with Functions
1
Summarizing Data with Aggregate Functions
Use aggregate functions (COUNT, SUM, AVG, MIN, MAX) to summarize data.
2
Text Manipulation with String Functions
Use string functions (CONCAT, SUBSTRING, LENGTH) to manipulate text data for extraction.
3
Grouping Data with GROUP BY
Group rows using GROUP BY to compute aggregates for distinct categories.
4
Filtering Grouped Data with HAVING
Filter grouped results using the HAVING clause.
5
Aliasing Columns and Tables with AS
Create column and table aliases using AS for readability and simplifying queries.
6
Log Data Analysis: Aggregation & String Functions
Practice analyzing security log data using aggregation and string functions.
Previous module
Foundational SQL Queries
Next module
Combining Data from Multiple Tables