PySide6 GUI and MySQL Database Operations - Add, Update, Retrieve and Delete Functions (2023)
Create Beautiful Things via YouTube
Power BI Fundamentals - Create visualizations and dashboards from scratch
Live Online Classes in Design, Coding & AI — Small Classes, Free Retakes
Overview
Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
Learn to build a complete database management system using PySide6 GUI and MySQL in this 41-minute tutorial. Master essential database operations including adding, updating, retrieving, and deleting data from MySQL tables while displaying results through QTableWidget. Follow along to set up XAMPP server for MySQL database management, implement database connectivity using MySQL Connector in Visual Studio Code, and create a functional GUI interface. Progress through hands-on demonstrations of inserting demo data, retrieving and displaying information in QTableWidget, adding new records, updating existing entries, and removing data from database tables. Gain practical experience with both frontend GUI development and backend database operations in this comprehensive Python programming guide.
Syllabus
Introduction to video
Install MySql Connector
Create connection to MySql Database
Add Widgets to the GUI
Insert Demo List Data to MySql Database table
Retrieve Data from MySql Database table
Add new row to MySql Database table
Update row in MySql Database table
Delete row in MySQl Database table
Taught by
Create Beautiful Things