Basic SQL Queries Lab

Activity Overview

In this lab, I practiced writing basic SQL queries to retrieve data from a database. I used the SELECT and FROM keywords to pull specific information, and applied the ORDER BY clause to sort results by a given column.

These skills are crucial for identifying important data as a security analyst, such as spotting unusual login activity or verifying which machines require updates.

Scenario

I worked with the organization database in the MariaDB shell. My tasks included:

1. Querying the machines table to identify devices that needed updates.
2. Querying the login_attempts table to examine recent login activity.
3. Using ORDER BY to sort the output by specific columns for better readability.

What I Learned

• How to run a SELECT query to extract information from a SQL database.
• How to retrieve all columns using SELECT *.
• How to organize query output using the ORDER BY clause.

This lab helped me build a foundation in querying databases—an essential skill for data analysis and security monitoring.

← Back to Portfolio