Python Pyqt5 Database Programming with MySql in Qt Designer

Learn Python database programming with Mysql Server step by step with practical examples What you'll learn:
Learn how to install PyQt5 and PyQt5 tools and how to configure Qt Designer and MYSQL Server
Learn how to develop a complete Python GUI application from scratch using PyQt5 to Create or Drop MySql Database
Learn how to create mysql database tables and insert Datas entered in Python PyQt5 Gui
Learn how to update mysql tables from Python PyQt5 Gui
Learn how to delete datas mysql tables from Python PyQt5 Gui
Learn how to display mysql tables from Python PyQt5 Gui to a Table Widget
Learn how to fill the selected datas from mysql tables to a combo box using Python PyQt5 Gui
Learn how to fill the mysql table datas to corresponding fields when we select a item from combo box using Python PyQt5 Gui

Requirements
Basic python programming
No paid tools are required as the tools required for this course are free.

Description
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…..

Who this course is for
All students who want to develop GUI database applications in Python using PyQt5 and Mysql
Beginner and advanced developers in python who want to learn PyQt5 database programming concepts using mysql
Engineering and Computer students who want to develop final year project in Python and Mysql
Software developers who want to learn Python GUI database application development completely from scratch
Beginners who want to learn Python GUI and MySql
Beginners who want to learn Python GUI with Database integration
Students who wish to learn a new skill in Python to develop their career in python and pyqt5