Apply Filters in SQL

Summary

This project centers on utilizing SQL to investigate potential security issues related to login attempts and employee machines within a large organization. The main objective is to analyze data from the employees and log_in_attempts tables by applying targeted filters to uncover suspicious activity.

Solution

By implementing specific criteria—such as employee IDs, timestamps, and login statuses—this project enhances the accuracy and relevance of data retrieval. It outlines the SQL queries used to extract critical information, thereby facilitating a thorough examination of login patterns and potential security threats.

Approach

The project involved developing and executing SQL queries to filter and analyze relevant datasets effectively. Each step was meticulously documented, highlighting the filtering criteria and their significance in identifying anomalies. This methodical approach strengthens the organization’s capability to monitor login activities and improve its overall security posture.