Udemyallen

Python Pyqt5 Database Programming with MySql in Qt Designer

Learn Python database programming with MySQL. Practical examples for building database applications. Step-by-step guide for beginners.

4.5(21)
141students
2h 19m
Certificate
Muthu Manavandi
Muthu ManavandiTeacher in Sanyu academy from 2006 & trained 1000+ students

Course Content

Python Pyqt5 Database Programming with MySql in Qt Designer is an all-levels Udemy course taught by Muthu Manavandi. It runs 2h 19m, is taught in English, and includes a certificate of completion. Learners rate it 4.5 out of 5 from 21 reviews, with 141 students enrolled. It is a paid course, last updated August 2021.

This course provides a comprehensive introduction to Python PyQt5 database programming using MySQL. Learn to build complete software applications with a user-friendly graphical interface.

What you'll learn:

  • Setting up your environment:

    • Install the latest version of Python.
    • Install PyQt5 and PyQt5 Tools using pip.
    • Configure Qt Designer for efficient GUI development.
    • Install XAMPP server for MySQL.
    • Install the MySQL Connector to connect Python to your database.
    • Install a Python program editor (e.g., VS Code, PyCharm).
  • MySQL Database Management with PyQt5 & Qt Designer:

    • Create MySQL Databases: Design a simple form in Qt Designer with a line edit for the database name and a button. Upon clicking the button, the form will create the specified database on your MySQL server.
    • Delete MySQL Databases: Create a form with a line edit for the database name and a button to delete the database from the MySQL server.
    • Insert Data into MySQL Tables: Develop a form with input fields (name, address, phone, email) and a button to insert new data into a MySQL table.
    • Update Data in MySQL Tables: Design a form with a combobox populated with email IDs (as unique identifiers) and input fields. Select an email, modify the data, and update the corresponding record in the MySQL database.
    • Delete Data from MySQL Tables: Create a form with a combobox populated with email IDs and a button to delete the entire row associated with the selected email from the MySQL database.
    • Display Data with PyQt5 Table Widget: Build a form using a QTable Widget to display data fetched from a MySQL table. The program will retrieve data from the database and populate the table with rows and columns.

Who is this course for?

This course is ideal for students eager to master GUI development with Python PyQt5 and integrate it with MySQL for robust data management. You'll gain practical skills in creating applications that interact with databases.

Join us and gain a strong foundation in MySQL database programming using the powerful Python PyQt5 library. We look forward to seeing you in the course!

$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

5.0(33)
1h 50m
all
skillshare
5.0(766)
2h 58m
intermediate
skillshare
skillshare