Online Job Portal using Python and SQL database

Published on 02 Jul 2021. Written by Aniruddha Gayake

Online Job portal is a platform where a job-seeking employee comes to find his targeted job and apply for it if liked. Then track his job application.

The job details and description is added, updated and maintained by the employer of the company. Employer scrutinizes the job applications received, update the status of the application and then call the respective candidates for interviews.  There is another entity that plays the main role in keeping up the job portal on the internet that is portal admin. Admin is responsible for maintaining the website is well and good condition and available live for all the time. Admin also has the right to insert, update or delete the jobs.

Read more..

SLNOTE
In this Python project, we are going to develop such a platform for job seekers to find their dream jobs.

Project Description:

There will be three major actors in our project:

1. Employee: The person who visits the portal for job search.

Activities that employee performs:

• Log In or Register in the portal
• Change password
• Search for jobs
• Apply for the job
• Track the application
• Report the fake jobs

2. Employer: The person who posts the job on the portal.

SLLATEST
Activities that the employer performs:

• Log In or Register in the portal
• Change password
• Add a new job to the portal
• Update the existing job
• Delete the job
• Monitoring the job from the admin dashboard
• Taking action on received job applications
• Updating the status of job applications

3. Admin: The person who maintains the website.

Activities that admin can perform:

• Designing and developing the website.
• Creating and maintaining a robust database like SQL.
• Insert, delete or update the data in the database
• Maintaining the servers in good conditions
• In short, keeping the site running all the time.

These three entities will be connected by our job portal system via the internet.

Project Implementation:

The major steps to complete the project:

• Create the front end with web technology scripting and designing languages.
• Create the database using a robust database like SQL.
• Create separate tables for storing employee data, employer data, job data, application data.
• Connect the front-end with a database with the help of Django.
• Create login and registration system for employees and employers.
• Create an option to apply for a job for the employee.
• Give the functionality to add, update or delete the job.

Technologies used in this project:

HTML: Designing of the webpage

CSS: Giving elegant look to the website

Java script: Form validation and animation is done by this

Python: To implement the business logic

Django: As a framework for project

SQL: The database for the project

Server for running this project on the local machine:

Xampp or Apache 

Software requirements: Text editor and Python.

Programming  Languages: Python, Javascript, Django

SLDYK
Kit required to develop Online Job Portal using Python and SQL database:

• No kit

Technologies you will learn by working on Online Job Portal using Python and SQL database:

• MySQL
• Python

Any Questions?