<investigations using sql>

In this project, I demonstrated my proficiency in using SQL with various filters to enhance system security and perform targeted investigations. I crafted queries to retrieve specific data from two tables: log_in_attempts and employees. My tasks included identifying after-hours failed login attempts, investigating login activities on specific dates, examining login attempts from outside Mexico, and gathering information on employee machines for security updates.

My SQL queries showcased the use of WHERE clauses with AND, OR, and NOT operators to filter data precisely. I also utilized the LIKE operator with wildcards to match patterns in the data. These queries allowed me to extract valuable information such as suspicious login activities and employee details from specific departments or office locations. This project highlights my ability to leverage SQL for security-related tasks, demonstrating skills crucial for maintaining and improving an organization's cybersecurity posture.