This project simulates a real-world IT security scenario where employee login activities and device usage are analyzed.
- Detect failed login attempts after working hours
- Analyze login behavior by user
- Identify employees based on department and office location
- Understand system usage across operating systems
- employees
- machines
- log_in_attempts
- Detected failed login attempts after 18:00
- Identified users with repeated failed login activity
- Analyzed operating system distribution across employee devices
- Calculated login failure rate
- WHERE
- AND
- OR
- NOT
- LIKE
- BETWEEN
- IN
- JOIN
- GROUP BY
- COUNT
- CASE WHEN
In this project, I practiced SQL queries step by step using a simulated dataset and analyzed login behaviors.
This project was built for learning and practice purposes.
Screenshots of query outputs are available in the /results folder.
- MariaDB / MySQL
Emir Sözal