Build School Management System | Python, PyQt5 & Qt Designer

欢迎来到学校管理系统 | Python、PyQt5 和 Qt 设计师课程

您想深入了解使用 Pyqt 进行 Python GUI 编程吗？本课程教授如何使用 python pyqt 开发一个完整的学校管理系统项目。该项目教授如何使用 Qt Designer 创建表单设计以及如何将用户界面与 python 文件集成。

本课程教授如何使用 Qt Designer 创建登录表单、学生详细信息表单、出勤详细信息表单、标记详细信息表单、费用详细信息表单。

使用 Qt Designer 解释如何创建标签、图像、文本字段（行编辑）、多行文本字段（文本编辑）、组合框、消息框、按钮、选项卡小部件、菜单栏、表格小部件

本课程讲解了如何创建Mysql数据库，如何在数据库中创建表，如何通过python代码从用户界面插入数据、更新数据、删除数据和选择数据到mysql数据库。

学生将学习如何使用Qt Designer开发以下模块并编写python代码以与用户界面和mysql数据库连接。

登录模块

如何使用Qt Designer创建登录以及如何编写python代码与用户界面连接，管理员将输入用户名和密码，如果用户名和密码正确，则会打开主窗体。如果详细信息不正确，它将显示错误消息。

学生模块

在学生模块中，所有学生详细信息，如注册号、出生日期、年龄、部门、地址、电话号码和电子邮件都被输入到表格中。所有输入的详细信息都存储在数据库中。保存后管理员可以进行编辑或删除，如果管理员要编辑输入的详细信息或删除详细信息。

标记详情

在标记模块中，所有标记详细信息（例如注册号，考试名称，语言标记，英语标记，数学标记，科学标记和社会科学标记）都以表格形式输入。所有输入的详细信息都存储在数据库中。保存后管理员可以进行编辑或删除，如果管理员想要编辑输入的标记详细信息或删除标记详细信息

出席详情

在考勤模块中，所有考勤详细信息，如注册号、考勤日期、早上考勤状态、晚上考勤状态都被输入到表格中。所有输入的详细信息都存储在数据库中。保存后管理员可以进行编辑或删除，如果管理员要编辑输入的考勤明细或删除考勤明细

MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 44 lectures (7h 7m) | Size: 3.8 GB
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.