Build Complete School Management Software | Python PyQt5 SQL

Build Complete School Management Software | Python PyQt5 SQL, available at $64.99, has an average rating of 4.4, with 48 lectures, based on 48 reviews, and has 395 subscribers.

You will learn about 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 This course is ideal for individuals who are All students who want to develop GUI applications in Python using PyQt5 or Beginner and advanced developers in python who want to learn PyQt5 concepts or Engineering and Computer students who want to develop final year project in Python or Software developers who want to learn Python GUI app development completely from scratch or Beginners who want to learn Python GUI or Beginners who want to learn Python GUI with Database integration or Students who wish to learn a new skill in Python to develop their career. It is particularly useful for All students who want to develop GUI applications in Python using PyQt5 or Beginner and advanced developers in python who want to learn PyQt5 concepts or Engineering and Computer students who want to develop final year project in Python or Software developers who want to learn Python GUI app development completely from scratch or Beginners who want to learn Python GUI or Beginners who want to learn Python GUI with Database integration or Students who wish to learn a new skill in Python to develop their career.

Enroll now: Build Complete School Management Software | Python PyQt5 SQL

Summary

Title: Build Complete School Management Software | Python PyQt5 SQL

Price: $64.99

Average Rating: 4.4

Number of Lectures: 48

Number of Published Lectures: 48

Number of Curriculum Items: 48

Number of Published Curriculum Objects: 48

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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.

Target Audiences

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.

Dear Student,

Welcome to Build School Management System | Python, PyQt5 & Qt DesignerCourse

I welcome you all to the course to get a good knowledge about PYTHON PYQT5 real time project development.

Students can complete a wonderful complete python software with all requirementsfrom GUI Development, Database design, Table design, back end coding with python.

Students, I am sure this course will be a biggest milestone in your career if you complete this course filly without skipping any lesson.

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.

This login form displays the message using message box. This form uses lineEdit, QPushButton, QLabel controls from Qt Designer.

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.

Export to Excel

The administrator can view the reports in QTableWidget from mysql database table. In the reports page, we have a download button. When the admin click on the download button, the reports will be exported as EXCEL file in the project folder. This export process needs pandas library to be imported.

Course Curriculum

Chapter 1: Introduction

Lecture 1: The complete output of the Python PyQt5 & MySql project we are goint go develop

Chapter 2: Software installation

Lecture 1: How to install Python

Lecture 2: How to install PyQt5 and PyQt5 tools

Lecture 3: How to install xampp and mysql

Lecture 4: How to install text editor for our project

Chapter 3: Download images for ui design

Lecture 1: Right click on each image – select – save image as – and save it

Lecture 2: Complete ui file code – copy the contents of the code and save as school.ui

Chapter 4: New project and menu creation using Qt Designer

Lecture 1: How to create new project and menu

Lecture 2: How to set menu colors and object names in the menu

Chapter 5: Interface Design – Login form and home page design

Lecture 1: Login form creation

Lecture 2: Home page creation

Chapter 6: User interface creation : Student details module

Lecture 1: Add new student interface design

Lecture 2: Edit or Delete student interface design

Chapter 7: User interface creation : Mark management module

Lecture 1: Add mark details

Lecture 2: Edit or delete mark details design

Chapter 8: User interface creation : Attendance management module

Lecture 1: Add attendance Details

Lecture 2: Edit or delete attendance details

Chapter 9: User interface creation : Fees management module

Lecture 1: Add fees details form

Lecture 2: Edit or delette fees form

Chapter 10: User interface creation : Reports generation module

Lecture 1: Report generation

Chapter 11: User interface creation : Receipt generation module

Lecture 1: Receipt generation

Chapter 12: Database and table creation in mysql database and Php my admin

Lecture 1: How to create school database in mysql using phpmyadmin control panel

Lecture 2: How to create student, mark, attendance and fees tables in school database

Chapter 13: Complete project code for python

Lecture 1: Copy the complete python code – copy the complete code and save as school.py

Chapter 14: Python code : How to connect Pyqt5 User interface with Python

Lecture 1: Connect ui to python code

Chapter 15: Python code to login form

Lecture 1: Login form

Chapter 16: Student module python code

Lecture 1: Add student part 1

Lecture 2: Add student 2

Lecture 3: edit student 1

Lecture 4: Edit student part 2

Lecture 5: Delete student

Chapter 17: Mark module python code

Lecture 1: Add marks

Lecture 2: Edit marks

Lecture 3: Delete marks

Chapter 18: Attendance module python code

Lecture 1: Add attendance

Lecture 2: Edit attendance

Lecture 3: Delete Attendance

Chapter 19: Fees module python code

Lecture 1: Addd Fees

Lecture 2: Fees Receipt Generation

Lecture 3: Edit fees

Lecture 4: Delete Fees

Chapter 20: Reports Generation

Lecture 1: Reports Generation

Lecture 2: Report Design Style Generation

Chapter 21: Extra Changes in this project

Lecture 1: Extra changes

Chapter 22: Export reports from QTableWidget to Excel File

Lecture 1: Export to Excel from Pyqt5 tables

Lecture 2: Download the modified python code

Lecture 3: The modified Gui for export to excel

Lecture 4: school.py

Instructors

Muthu Manavandi
Teacher in Sanyu academy from 2006 & trained 1000+ students

Rating Distribution

1 stars: 0 votes
2 stars: 2 votes
3 stars: 3 votes
4 stars: 13 votes
5 stars: 30 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu