Python PyQt5 and Qt creator course for advanced learners

Continue building the add new vehicle window by editing labels, placeholders, and controls; double-click to rename items, set font size, and configure line edits, combo boxes, and push buttons.

Learn to upload and display pictures in a PyQt5 Qt creator project, connect images to the database, and show labeled pictures like mean window and new vehicle from the folder.

Learn to display database records in a pyqt5 table by looping through results, mapping roll numbers and columns, creating QTableWidgetItem items, and adjusting column widths for clarity.

Learn to display records from a database in a PyQt5 table using Qt Creator, handling add-vehicle workflows, closing dialogs, and refreshing the table to show new entries.

Create a single vehicle window layout by dragging labels, line edits, a combo box, and push buttons, adjust vertical spacers, center the update vehicle data title, and save changes.

Create and customize a vehicle window layout in pyqt5 and qt creator by naming labels, editing text, and styling fonts and colors for line edits, combo boxes, and push buttons.

Demonstrates a double click on a PyQt5 table widget to fetch a vehicle by id with a parameterized query and display its name, manufacturer, year, price, and image.

Finish the doubleClicked function for tableWidgetDisplyVehicle to populate line edits, combo boxes, and the vehicle image from the pictures directory, and ensure proper data type handling and database sync.

Learn to create a connection function for push buttons to display all, available, or unavailable vehicles from the database, including clearing the table and building queries to filter by availability.

Create a new window class for adding cars, implement the connection function for the menu and toolbar to open it, and return to the main window on close.

Explore building the add new cars seller window in PyQt5 and Qt Creator, edit labels by double-click, set font styles and placeholders for line edits, and apply stylesheets for colors.

Create the seller table in the PyQt5 and Qt creator project, and define fields: id, name, last name, phone, email, address, and picture.

Explore customizing a Qt Creator project by resizing the main and car-seller windows, adding icons, and separators. Then prepare to connect push buttons, upload cards, and fill pictures.

Implement the double clicked function to query the database using the selected seller ID and fetch name, last name, phone, email, address, and picture for the single seller view.

Wire update and delete connection functions in a PyQt5 Qt creator app, linking line edits for seller details and a picture, then update the seller record using a global id.

Create a new customer window in a PyQt5 app, load a picture, and create a SQLite customer table with id, name, last name, phone, email, and address, saving changes.

Create a connection function for the add new customer button that reads input fields. Validate non-empty values, insert into the customer table, and show a success message.

Create a show existing customer menu and a show customer table window in PyQt5 and Qt creator, wiring the menu to open the new window.

Design and implement a show customer table window in PyQt5 using Qt Creator, adding a table widget, search line edit, and action buttons to manage customer data.

Develop a search function for the customer button that reads name or last name, validates input, executes a like query, handles not found, and reuses the all customers display method.

Implement a double-click on the customer table to fetch a database record and display it in a new PyQt5 window for updating or deleting data.

Extend the double-click function to retrieve the selected customer ID from the table, query the database for that record, and display it for update or deletion.

Double-click a table row to retrieve the customer id, fetch the record, and populate the update customer data window with name, last name, phone, email, and address.

Create sellCars function to fetch available cars from the physical table, fill a combo box with car names, store IDs as hidden values, and load seller pictures from project folders.

Create the sellCars function by executing a query, printing results, and looping to capture seller id and last name for populating a combo box.

Populate a PyQt5 combo box with numbers 1 through 20 from the first vehicle's available pieces in the database, using a for loop and string conversion for selling.

Open the Esquire Lite database, create the deal table, add year (primary key, auto increment), sold, customer id, month, amount, currency, and customer name, then save.

Finish the make deal window layout by naming groups and labels, mapping fields like customer, last name, and total price, and enable table view and resizable window; apply a stylesheet.

Learn to display a picture in a new PyQt5 window, update push button labels, handle close events, and retrieve names, IDs, vehicle count, and sale date for a deal form.

Create a connection function for the push button confirm to invert values in the deal table, insert hidden customer and seller IDs, and commit the transaction while printing results.

Create monthly, yearly, and customer statistics for car sales using the deal table. Clean the database, insert sample data for two sellers, and build monthly and annual overviews.

Master pyqt5 and qt creator by building a seller overview that shows total sales, cars sold, month and year, and currency, updating labels via a push button.

Set up a PyQt5 UI, define a class inheriting from Qt widgets, configure menu and toolbar actions for statistics per year, and connect to open and close the year window.

Build a PyQt5 connection function to fetch customer statistics by birth year and last name, validate inputs, show errors for empty fields, and execute a parameterized sql query.

Finish the connection function to generate an annual overview by querying yearly sales and vehicle counts, extracting year and currency from nested results, and displaying totals in PyQt5 labels.

Explore how to use the blt plot package in a PyQt5 and Qt Creator project to visualize data by supplying x axis and y axis values.

Learn to build a monthly statistics graphic by querying a deal table, extracting daily totals, and rendering the results with matplotlib in a PyQt5 and Qt Creator project.