Python Pyqt5 Database Programming with MySql in Qt Designer

Learn Python database programming with Mysql Server step by step with practical examples

Hello students,

Thank you very much for showing interest in this course Python Pyqt5 Database Programming with MySql in Qt Designer.

This course is going to be very useful for the students who want to create to develop a complete software application using python pyqt5 and mysql server as back end.

Python pyqt5 is a moden GUI development library. We can develop a lot of GUI Applications using python pyqt5. If we want to develop GUI based application software, we require a database to store our datas. Mysql server is one of the most used database server in the world. It is very important to store our customer and  companies data in a secured way. So using mysql server to store our data is very important in software development.

In this course you are going  learn the following concepts

Software installation

1. How to install python latest version

2. Install Pyqt5 through pip

3. Install Pyqt5 Tools through pip

4. Configure Qt Designer

5. Install Xampp server for Mysql

6. Install mysql connector

7. Install Python program Editor

Mysql Database creation through Python PyQt5 using Qt Designer

We will design a form in Qt Designer that contains a Line edit and a Push Button. After enter the database name we want to create in the line edit, If we click the push button, the database will be created in the mysql server. We can check the mysql server by opening the in the web browser. Initially we have to start the mysql server and apache server from the xampp control panel.

Mysql Database deletion through Python PyQt5 using Qt Designer

We will design a form in Qt Designer that contains a Line edit and a Push Button. After enter the database name we want to delete in the line edit, If we click the push button, the database will be deleted or dropped in the mysql server. We can check the mysql server by opening the in the web browser. Initially we have to start the mysql server and apache server from the xampp control panel.

Insert into mysql database table through Python PyQt5 using Qt Designer

We will design a form in Qt Designer that contains input for name, address, phone and email. After fill all the details in the Pyqt5 Gui form, If we click the push button, the the entered details will be inserted in the mysql server database table. We can check the mysql server by opening the in the web browser.

Update the data in mysql database table through Python PyQt5 using Qt Designer

We will design a form in Qt Designer that contains combobox filled with all email id in the mysql database table. We use email id as unique field because each persons email id will be unique. When we select a email id from the combo box, the name, address, phone number will be filled in the corresponding input controls. After we made the required changes, if we click the push button, the modified details will be updated in the mysql database table for the selected email id. We can chech the updates in the mysql server database.

Delete the data in mysql database table through Python PyQt5 using Qt Designer

We will design a form in Qt Designer that contains combobox filled with all email id in the mysql database table. We use email id as unique field because each persons email id will be unique. When we select a email id from the combo box and  if we click the push button, the details in the complete row will be deleted in the mysql database table for the selected email id. We can chech the deleted in the mysql server database.

Display the data from mysql database table in the Python PyQt5 using Qt Designer Table widget

We will design a form in Qt Designer that contains QTable Widget filled with all data in the mysql database table. The program will collect all the data from the mysql database table and save it in to an array. Then the data will be added to qtable widget in rows and columns.

This course will be very useful for the students who want to learn how to develop a GUI application using python pyqt5 GUI development library using mysql database.

I welcome you all to join this course and get a strong knowledge in the mysql database programming using python pyqt5 library

Thank you very much.. I will see you in the course.....