DataMonit TopDog

An Automated Course Monitoring System

🖥️ Tech Stack

Backend:

Demo Video »

✧ View Demo ✧ Getting Started ✧ Installing ✧ Author ✧

It is an Automated Course Monitoring System developed using Java, SQL, and JDBC can help different users like Faculty Head (Administrator) and Faculty keep the records of all the courses, batches, and faculties, get daywise updates of every batch and maintain the course plan, as per their roles and eligibility criteria.

Services

• Faculty Services
• Course Services
• Batch Services
• Course-Plan Services

🚀 Faculty Services

• Create faculty username and password
• Faculty registration
• Faculty Login
• Update faculty name using faculty id
• Update faculty name using faculty existing name
• Update faculty address using faculty id or name
• Update faculty mobile number using faculty id or name
• Update faculty email id using faculty id or name
• Get all faculty details
• Get faculty details by faculty name
• Get faculty details by faculty id
• Get faculty address by faculty name

🚀 Course Services

• Create a course
• Update course fee
• Update course name using course id or name
• Update course description using course name
• Update course using course name or id
• Get course by course name
• Get course fee by course name
• Get course description by course name
• Get all course details

🚀 Batch Services

• Create a batch
• Update batch name by batch id or existing name
• Update faculty id by batch id or name
• Update number of students by batch id or name
• Update batch start date by batch id or name
• Update batch duration in months by batch id or name
• Get all batch details
• Get batch details by batch id or name
• Get all batches of a course
• Get all faculties of a batch
• Get all batches of a faculty
• Get daywise update of every batch

🚀 Course-Plan Services

• Create a course plan
• Update course id by plan id
• Update batch id by plan id
• Update day number by plan id
• Update topics by plan id
• Update status by plan id
• Get all course-plan details
• Get all course plans of a course
• Get a course plan by plan id
• Get all course plans by status

Getting Started

This project was built using Java, SQL and JDBC. It is a backend course monitoring system and for running it on your local environment you should follow these guidelines.

Getting Started with Database:

• Install MySql command line client or workbanch on your system.

• Create a database as per the below details and modify the required fields.

Getting started with JDBC:

• Download/get the Jdbc driver related jar file (mysql-connector.jar) from the internat and set that jar file inside the classpath of your java application.

• Load the jdbc driver related main class into the memory.

• Prepare the connection String.

• Establish the connection.

• After performing the CRUD operation close the connection.

Contact

If you want to contact me, you can reach me through below handles.

© 2022 T Roshan Kumar Patro

Show your support

Give a ⭐️ if you like this project!