Develop a complete school management system project using Python, PyQt5, Qt Designer & Mysql | Step by step coding guide
What you'll learn
- Learn how to install PyQt5 and PyQt5 tools and how to configure Qt Designer
- Learn how to develop a complete Python GUI application from scratch using PyQt5
- Learn how to create a complete form design for School management system project Qt Designer
- Learn how to create MySql database and connect with Python Project
- Learn how to insert data to database, how to delete and update data from database, how to generate auto numbers
- Learn how to generate reports for the database
- How to generate receipts for fees payments and take the print out of the receipts
Requirements
- Basic python programming
- No paid tools are required as the tools required for this course are free.
- A computer with internet connection.
Description
Dear Student,
Welcome to Build School Management System | Python, PyQt5 & Qt Designer Course
Do you want to get in depth knowledge in Python GUI programming using Pyqt. This course teaches how to develop a complete school management system project using python pyqt. This project teaches how to create form designs using Qt Designer and how to integrate the user interface with python file.
This course teaches how to create a login form, student details form, attendance details form, mark details form, fees details form using Qt Designer.
How to create Labels, Images, Text fields (Line Edit), Multi line text fields (Text Edit), Combo boxes, Message boxes, Buttons, Tab widgets, Menu bars, Table widgets are explained using Qt Designer
How to create Mysql database, how to create tables in the database, how to insert data, update data, delete data and select data from user interface to mysql database through python code are explained in this course.
The students will learn how to develop the following modules using Qt Designer and write python code to connect with user interface and with mysql database.
Login module
How to create a login using Qt Designer and how to write python code to connect with user interface, the administrator will enter the username and password, if the username and password are correct, it will open the main form. If the details are not correct, it will show error message.
Student Module
In the student module, all student details like registration number, date of birth, age, section, address, phone number and email are entered in the form. All the entered details are stored in the database. After save the administrator can perform edit or delete, if the administrator want to edit the entered details or delete the details.
Mark details
In the mark module, all mark details like registration number, exam name, language mark, English mark, maths mark, science mark and social science marks are entered in the form. All the entered details are stored in the database. After save the administrator can perform edit or delete, if the administrator wants to edit the entered mark details or delete the mark details
Attendance details
In the attendance module, all attendance details like registration number, attendance date, morning attendance status, evening attendance status are entered in the form. All the entered details are stored in the database. After save the administrator can perform edit or delete, if the administrator wants to edit the entered attendance details or delete the attendance details
Attendance details
In the fees module, all fees details like receipt number, registration number, fees amount, fees date, reason for fees are entered in the form. All the entered details are stored in the database. After save the administrator can perform edit or delete, if the administrator wants to edit the entered fees details or delete the fees details
Receipt
The administrator can take print out of the receipt after entering the receipt details and edit fees details. The receipt are generated automatically when add fees or edit fees form is executed.
Reports
The system generates the student reports, mark reports, attendance reports and fees reports for the administrator.
Who this course is for:
- All students who want to develop GUI applications in Python using PyQt5
- Beginner and advanced developers in python who want to learn PyQt5 concepts
- Engineering and Computer students who want to develop final year project in Python
- Software developers who want to learn Python GUI app development completely from scratch
- Beginners who want to learn Python GUI
- Beginners who want to learn Python GUI with Database integration
- Students who wish to learn a new skill in Python to develop their career.
