
Build software with Python, PyQt5, and Qt Designer to design a database and build a GUI for managing a machinery spare parts warehouse, tracking consumption and monitoring critical inventory levels.
Preview the final graphical interface and database for an inventory system built with PyQt5 and Qt Designer. Demonstrates a parts table with refresh, quantity search, update, delete, and add operations.
Install python 3.6, PyQt5, and sqlite by downloading and setting up Anaconda from the archive, keeping the same installation folder for all tools.
Create and configure a SQLite database named bots, add a table bots_table with nine fields including an auto-incrementing id, and fill it with data from an Excel file before saving.
Design a multi-tab inventory GUI with Qt Designer, featuring identity, inventory statistics, and inventory tabs, plus a detailed QTableWidget for item data.
Design and arrange a Qt Designer GUI to display inventory statistics with labels, text boxes, spin boxes, a table, and navigation plus update, delete, and add actions.
Learn to scaffold a PyQt5 GUI using a reusable template that imports PyQt5 modules, loads a designer .ui file, and defines a main window class with button handlers.
Learn to load data from a database and display it in a PyQt5 GUI table, wire a refresh button, and populate a QTableWidget with query results.
Implement a search filter linked to a GUI button that reads an integer from a widget and uses a parameterized SQL query to filter inventory by count.
Learn to display spare parts inventory statistics in a PyQt5 app using Qt Designer, counting distinct references and parts, and showing minimum and maximum values in QLabels.
Display the top three parts with the minimum inventory in a QTable, table 2, by clicking a button, showing reference, part name, and count. Wire navigation results to text boxes.
Learn how to wire an update button in a PyQt5 GUI to update a database table using a parameterized update query, handling widget values and id-based row updates.
Add a delete button to the GUI to remove a database row by id, connect to the database, execute a delete statement, and commit changes.
Assign the add button in the GUI to perform an insert into the database. Compare the last row and confirm auto-incremented id while entering values.
Apply CSS style sheets to a Qt Designer GUI by loading a style file, editing the main window in the style editor, and previewing color themes and button states.
Learn to turn a PyQt5 project into a standalone .exe by installing PyInstaller and auto-py-to-exe, configuring resources and external files, and generating a distributable executable.
Are you thinking to master PyQt5 for Graphical User Interface Development ? Do you write some codes in Python and you wonder how you can convert everything to a nice interactive user interface that can be used by huge number of people ?
I can grantee to you that you are taking the best decision in today World. After doing this course, you will meet your goal.
I designed this course in a way to cover all the mandatory aspects of Python-PyQt development, starting from Downloading the working tools until the final deployment of our software to other users. The learning method i chooses is particular because we will work on a real case study "nothing better than doing real things" => we will create a software to respond to a customer demand (a Spare Parts Management Software for Manufacturing Company)
What Students Already saying about this course:
Tuhin : "The instructor has prompt knowledge about all the topics he taught us"
Gopal: "Hands-on - Step by step explanation"
Tanmay: "Very Excellent work so far and made easy to understand"
Anurag: "Excellent faculty ... i just loved the way he taught us ... thanks sir for sharing your knowledge"
Mridul: Great contents with real world app development insight with Python. Expecting more in near future"
AND MORE...
......
Special Focus:
What i grantee to you in this course also is that you will get instant feedback on all your questions (less than 24h feedback). This will allow you to learn even faster and get up and solve any issue that you may face during your projects and codes.
Why Python & Why PyQt ?
The Python language has a large number of advantages: it is an object oriented language, interpreted, dynamically typed and benefiting from memory management via a garbage collector.
For all these reasons, Python is a very simple language to use. However, creating interface in Python using basic tools is somewhat tedious. This is why there are many Python modules allowing to realize graphical interfaces, PyQt is the best.
Multi-platform available for Unix, Windows and Mac OS X; native look and feel the applications present the appearance of the operating systems on which they run by default, but it is possible to install another look and feel, even at runtime; it is implemented on the lower layers of graphics systems.
PyQt is a module which allows you to link the Python language with the Qt library. It allows you to create graphical interfaces in Python. An extension of QtDesigner (graphical utility for creating Qt interfaces) makes it possible to manage the python code of graphical interfaces. PyQt has all the advantages of the famous Qt.
What you will learn in this course:
The Skill that you will learn is: Python Desktop Application Development with PyQt
Introduction to the course objectives and modules
Install Anaconda
Install PyQt5
Install SQLITE Manager
Create parts.db database and fill it with data
Create first Python script to connect and query the parts.db
Introduce QT Designer and create GUI
Create beautiful style for the GUI
Create the full code to run the GUI and do the software functionality
How to add and compile ressources like (photos...)
How to make an final executable file and share it with friends.