Filtering Data with SQL Lab

Activity Overview

As a security analyst, I learned how to write better SQL queries to retrieve specific pieces of data more efficiently. This lab focused on applying filters using the WHERE clause and the LIKE operator within a MariaDB database to locate precise information.

Scenario

I queried the organization database to:

1. List all organization machines and their operating systems.
2. Filter and list machines that run the OS 2 operating system.
3. List employees who belong to the Finance and Sales departments.
4. Filter machine information based on specific conditions.

This exercise helped me practice narrowing down SQL query results, which is essential for quickly identifying relevant data in large datasets.

What I Learned

• How to apply the WHERE clause to restrict data returned by queries.
• How to use the LIKE operator to search for patterns within data.
• The importance of filtering in data retrieval for cybersecurity investigations.

This lab strengthened my ability to extract actionable information from databases to support security analysis and decision-making.

← Back to Portfolio