This project is a simulation of a Job Portal System, designed to model how users, recruiters, companies, jobs, and applications interact on a recruitment platform. It also explores how SQL can be used to extract meaningful insights from structured data.
I’m building a relational database for a job portal and performing recruitment analytics using SQL. The database includes tables for users, companies, job listings, applications, and skills. I use SQL queries to answer business-related questions such as job trends, recruiter activity, and skill demand.
This project helps me strengthen my SQL skills through a real-world use case and prepares me for data analysis tasks commonly required in professional roles. It also showcases my ability to create end-to-end analytical solutions using structured data.
I designed the schema and created sample datasets using Excel, then imported them into MySQL. Using SQL, I wrote queries to analyze the data and generate insights related to hiring trends, user activity, and job market dynamics.
This project demonstrates how to structure a job portal database and derive valuable insights using SQL. It lays the foundation for more advanced work, such as building dashboards or integrating machine learning models for job recommendations.