Python PyQt5 and Qt creator course for advanced learners

Create a main window menu and toolbar in Qt Creator for PyQt5, add a new vehicle menu item with actions and shortcuts, and wire it to open a new window.

Create a new add new vehicle window in PyQt5, set the window title and font, apply a stylesheet, and connect it to the main window's menu and toolbar.

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.

Create and customize a vehicle window in PyQt5 by styling buttons, populating combo boxes, and labeling fields, then fix layout by adding vertical spacers and a table view for responsiveness.

Create and iterate lists with for loops in python, including nested lists. Build an example list with name, last name, and address, and print its items.

Create a PyQt5 connection function for a push button that opens a file dialog to upload a vehicle picture, display and resize it, and save it to the pictures folder.

Create a connection function for the submit button to save the uploaded picture and insert vehicle part data from line edits and the physical condition combo box into the database.

Learn to build a submit function that validates vehicle part fields, constructs an insert query, handles errors with try-except, commits changes, and provides user feedback via message boxes.

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.

Create a PyQt5 layout in Qt creator for a display, adding a line edit, push buttons, radio buttons, and a 10-column table widget; apply font styling and a yellow background.

Adjust vehicle table layout by setting widths via index from zero to nine with values 35, 360, 200, 230, 150, 120, 100, 140, 130, 155 in PyQt5 and Qt creator.

Display records from the database in a PyQt5 table in part 1 by creating a new class method to fetch and show selected fields through a select query and execution.

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.

Learn how to use QMessageBox types in PyQt5, including information, warning, question, and critical message boxes, validate a line edit, handle submit actions, and implement update and delete workflows.

Create the push button search connection to query vehicles by name or manufacturer. Retrieve line edit input, execute a database query, and show results or a not-found warning.

Build a push-button search for vehicle parts in a PyQt5 app, populate a table widget from query results, and clear on no match. Handle empty results with a message box.

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.

Double-click a vehicle row to fetch its data by the primary key id and display it; collect each column's text into a list and store the id globally for updates.

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.

Enable double-click to open a new window from the tableWidgetDisplyVehicle, then interact with its inner widgets, such as line edits, radio buttons, tables, and push buttons, via the window instance.

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.

Develop and connect functions in a PyQt5 and Qt creator project to update vehicle pictures and data, handling line edits, combo boxes, and a global vehicle id for single-vehicle edits.

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.

Learn to design a new cars seller window in PyQt5 by placing labels, an image label, lines, and push buttons, then style fonts and center align texts.

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.

Finish the new cars seller window layout in the PyQt5 and Qt Creator course by adding placeholders, vertical groups, a table view, and adjusting font sizes for keyboard shortcuts.

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.

Finish the connection function in a PyQt5 Qt creator project by adding a new seller and picture, validating fields, updating the seller table in the database, and showing success messages.

Import the new UI into the Python PyQt5 project, create a show seller table window, and connect the menu to open it from the main window using Qt creator.

Learn to adjust your window layout later by canceling the table view and editing inside to resize groups. Save changes and run the app to see the updated layout.

Fetch records from the database and display them in the seller table of a PyQt5 app. Build and execute a query, clear the table, and populate it with row data.

Create and show a single seller window in PyQt5, enabling double-click to display a record, update the seller picture, and delete data, with a new UI class in Qt creator.

Create a single seller window layout in a PyQt5 project by adding labels, line edits, and push buttons, then style fonts, alignment, and colors, and name widgets clearly.

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.

Implement a PyQt5 push-button connection to update seller data: read line edits, validate fields, run a parameterized SQL update, commit, and refresh the seller table with a confirmation message.

Learn to create an add new customer menu and toolbar in a PyQt5 Qt Creator project, implement a close event, and style actions with icons and shortcuts.

Create a new customer UI in PyQt5, connect menu and toolbar actions to open the new customer window, and return to the main window on close, with an icon.

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.

Learn to customize a customer table in PyQt5 using stylesheets for button colors and headers. Explore adding columns, setting fonts, and creating line edit placeholders in the interface.

Display records from the database in the customer table using PyQt5, populating the table widget, iterating results, converting data to strings, and adjusting font size and row colors.

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 a PyQt5 delete function connected to a push button that deletes a selected customer record from the database, with a confirmation dialog and status messages.

Finish the deal window layout in a PyQt5 Qt Creator project by configuring labels and line edits. Add Turkish placeholders and a submit button, then run the app.

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.

Learn how to fetch customer data from a database and populate a PyQt5 combo box with each customer's last name and hidden ID, then prepare for car sales integration.

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.

Create make deal window layout with 14 labels and a push button, center label text with font size 30 bold italic, and add two vertical spacers in PyQt5 Qt Creator.

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.

Learn to fetch currency and price for a selected vehicle from the database using a hidden id from combo box, then calculate and display the amount in PyQt5 interface.

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 connection function confirm part 2 demonstrates updating vehicle stock and availability when selling car pieces, querying current pieces, updating the database, and marking sold-out status.

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.

Create a monthly statistics window in PyQt5 by assembling a group box with three labels, three line edits, and a push button, then adjust fonts and text for the interface.

Finish the window layout by creating placeholders and line edits for month and year in PyQt5, apply a stylesheet to set black text on green, and update Turkish labels.

Implement the connection function to show monthly overviews by verifying month and year, handling empty results, and querying vehicle count and total amount from the database.

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.

Create a PyQt5 window layout for annual statistics with labels, group boxes, and a push button. Set fonts to 12 bold italic and add placeholders for year and total amount.

Create a PyQt5 connection function that reads year and filler last name from line edits, validates inputs, and queries the deal table to list sold cars by year and seller.

Create a customer per year statistics menu and toolbar, link them to a new abacus statistic window, and customize font, icons, tooltips, and window styling.

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.

learn to build a PyQt5 connection function that computes yearly customer statistics using sql sums from the deal table, handle query results, and manage list indexing to avoid runtime errors.

Create a new window monthly overview layout in PyQt5 and Qt Creator, using a group box with labels, two line edits, a push button, and six labels.

Finish the connection function to show a monthly overview by querying the deal table for a month and year, returning total cars sold and total amount for display in labels.

Create a menu annual overview and a menu toolbar in a PyQt5 Qt Creator project, configure fonts and icons, and wire actions to display the overview from menu and toolbar.

Create a window layout for an annual overview in PyQt5 and Qt Creator, arranging a group, label, line edit, push button, and six labels with font and placeholder adjustments.

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.