C++ ,Qt Creator , Sqlite Database Intermediate Level Course

C++ Desktop Application with Qt Creator and Sqlite database intermediate level course

What you'll learn

You will learn how to program desktop application using C++ and Qt Creator development environment and Sqlite database

You will learn how to use Qt Creator to create professional layouts

You will learn how to access and program the created layouts

You will learn how to work with Qt Creator and Sqlite Database

Requirements

This course is suitable for programmers with C++ programming experience.

Basic programming knowledge and C++ programming knowledge are required!

Description

Desktop application program with C++, Qt Creator and Sqlite database for  intermediate level usersIn this project, we will create a management application for a car dealership.It shows how vehicles, customers and car salespeople are managed and how deals are made. The sales made are recorded and shown in statistics. An independent executable file is then created.We will create our layout with Qt Creator and work with the Sqlite database.You will learn:1- How to work with Qt Creator development environment (e.g. creating widgets, programming code)2- How to work with Sqlite database and Qt Creator development environment. Regarding Sqlite database, the functions required for the project are explained. Please note that no detailed database course can be offered here.3- How to create a professional layout with Qt Creator4- How to create tables in your database. You will learn how to save, update, delete and query the data. Statistics are also generated from the data.From the application we will create an executable exe file.Everything you need for this course: Good programming skills with C++, for example to work routinely with classes, methods, variables and loops.This course is not suitable for beginners without programming knowledge.We focus on querying databases, inserting, updating and deleting data, uploading and saving images in your application and you will learn how to create statistics.To do this, we generate data records from the database and also display them in a table or combo box.After completing this course you will be able to create your own professional application. Everything is explained line by line.At the end of our course, I'll show you how to create an executable independent of Qt Creator and your computer. You will also learn how to use Qt Creator to develop professional user interfaces, create menus and tables, combo boxes, buttons, labels and line edit. Everything is explained step by step. You will also learn how to set and change the layout with text and background colors and much more.Let us begin! I would be very happy to welcome you as a course participant today!

Overview

Section 1: Download and install the development environment

Lecture 1 Download and install the Qt Creator development environment

Lecture 2 Download and DB Browser for Sqlite

Lecture 3 Create Course Project

Lecture 4 Project configuration

Lecture 5 Finish Project configuration

Lecture 6 Create Database

Lecture 7 MainWindow Layout

Lecture 8 Create Database Connection

Lecture 9 Image Animation Part - 1

Lecture 10 Public Or Private Variablen and Slots

Lecture 11 Create Image Animation Part - 2

Lecture 12 Finish Create Image Animation

Lecture 13 Create Click Function For MenuItem and Icon Add New Vehicle

Section 2: Add new Vehicle

Lecture 14 Create Add new Vehicle Window Layout Part - 1

Lecture 15 Create Add new Vehicle Window Layout Part - 2

Lecture 16 Create Add new Vehicle Window Layout Part - 3

Lecture 17 Finish Create Add new Vehicle Window Layout

Lecture 18 Display Picture in Picture Label

Lecture 19 Create Upload Vehicle Picture Pushbutton Function

Lecture 20 Create Save Puschbutton Function Part - 1

Lecture 21 Create Save Puschbutton Function Part - 2

Lecture 22 Create Save Puschbutton Function Part - 3

Lecture 23 Create Table Vehicle in Database

Lecture 24 Finish Create Save Puschbutton Function

Lecture 25 Create Pushbutton Home Page Function

Lecture 26 Create new Menu Overview,MenuItem , Toolbar Icon Vehicle Table

Lecture 27 Create Click Function for MenuItem and Toolbar Icon Vehicle Table

Lecture 28 Create Vehicle Table Window Layout

Lecture 29 Finish Create Vehicle Table Window Layout

Lecture 30 Get Records from Vehicle Table in Database and Display in TableView

Lecture 31 Create TODO in Add New Vehicle CPP File

Lecture 32 Introduction Updating vehicle data

Lecture 33 Create Update Layout Part - 1

Lecture 34 Create Update Layout Part - 2

Lecture 35 Create Update Layout Part - 3

Lecture 36 Finish Create Update Layout

Lecture 37 Create Click Function for Tableview Vehicle Part - 1

Lecture 38 Create Click Function for Tableview Vehicle Part - 2

Lecture 39 Finish Create Click Function for Tableview Vehicle

Lecture 40 Create Click Function for Pushbutton Upload Vehicle Picture

Lecture 41 Create Click Function for Pushbutton Update Vehicle Picture

Lecture 42 Create Click Function for Pushbutton Update Vehicle Data Part - 1

Lecture 43 Create Click Function for Pushbutton Update Vehicle Data Part - 2

Lecture 44 Finish Create Click Function for Pushbutton Update Vehicle Data

Lecture 45 Create Click Function for Pushbutton Delete Vehicle Data Part - 1

Lecture 46 Finish Create Click Function for Pushbutton Delete Vehicle Data

Section 3: Add new Seller

Lecture 47 Create new menuItem , Toolbar Icon and Click Function Add new Seller

Lecture 48 Create Add new Seller Window Layout

Lecture 49 Finish Create Add new Seller Window Layout

Lecture 50 Disply picture in Label picture and Create Table Seller in Database

Lecture 51 Create Pushbutton Upload seller picture Function

Lecture 52 Create Pushbutton Save Function

Lecture 53 Finish Create Pushbutton Save Function

Lecture 54 Create Click Function for Pushbutton Home page Add new Seller Window

Lecture 55 Create neu MenuItem and Toolbar Icon Seller Table and Click Function

Lecture 56 Create Seller Table Window Layout Part - 1

Lecture 57 Create Seller Table Window Layout Part - 2

Lecture 58 Finish Create Seller Table Window Layout

Lecture 59 Get Records from Seller Table in Database and Display in TableView Seller

Lecture 60 Create TODO in Add New Seller CPP File

Lecture 61 Create Click Function for Tableview Seller

Lecture 62 Finish Create Click Function for Tableview Seller

Lecture 63 Create Click Function for Pushbutton Upload Seller Picture

Lecture 64 Create Click Function for Pushbutton Update Seller Picture

Lecture 65 Create Click Function for Pushbutton Update Seller Data

Lecture 66 Create Click Function for Pushbutton Delete Seller Data

Lecture 67 Create Click Funktion for Pushbutton Home Page

Section 4: Add New Customer

Lecture 68 Create MenuItem and Toolbar Icon Add new Customer

Lecture 69 Create Add new Customer Window Layout Part - 1

Lecture 70 Create Add new Customer Window Layout Part - 2

Lecture 71 Finish Create Add new Customer Window Layout

Lecture 72 Create Customer Table in Database

Lecture 73 Create Click Function for Pushbutton Save

Lecture 74 Finish Create Click Function for Pushbutton Save

Lecture 75 Create Click Function for Pushbutton Home Page

Lecture 76 Create neu MenuItem and Toolbar Icon CustomerTable and Click Function for menuIt

Lecture 77 Create Customer Table Window Layout

Lecture 78 Create Customer Table Window Layout Part - 2

Lecture 79 Create Customer Table Window Layout Part - 3

Lecture 80 Finish Create Customer Table Window Layout

Lecture 81 Get Records from Customer Table in Database and Display in TableView Customer

Lecture 82 Create TODO Function in Add new Customer CPP File

Lecture 83 Create Click Function for Tableview Customer

Lecture 84 Finish Create Click Function for Tableview Customer

Lecture 85 Create Click Function for Pushbutton Update Customer Data

Lecture 86 Create Click Function for Pushbutton Delete Customer Data

Lecture 87 Create Click Function for Pushbutton Home Page

Section 5: Sale

Lecture 88 Create new Menu, menuItem and Toolbar Icon and Click Function for Do business

Lecture 89 Create Sale Window Layout Part - 1

Lecture 90 Create Sale Window Layout Part - 2

Lecture 91 Create Sale Window Layout Part - 3

Lecture 92 Create Sale Window Layout Part - 4

Lecture 93 Finish Create Sale Window Layout

Lecture 94 Display pictures in Labels picture

Lecture 95 Add Item in Combobox Vehicle Name

Lecture 96 Add Item in Combobox Customer Name

Lecture 97 Add Item in Combobox Seller Name

Lecture 98 Add Item in Combobox Number of vehicles part - 1

Lecture 99 Add Item in Combobox Number of vehicles part - 2

Lecture 100 Finish Add Item in Combobox Number of vehicles

Lecture 101 Add Item in Combobox Date Day

Lecture 102 Add Item in Combobox Date Month

Lecture 103 Create Click Function for Pushbutton Submit part - 1

Lecture 104 Create Click Function for Pushbutton Submit part - 2

Lecture 105 Create Click Function for Pushbutton Submit part - 3

Lecture 106 Finish Create Click Function for Pushbutton Submit

Lecture 107 Create Click Function for Pushbutton Confirm part - 1

Lecture 108 Create Click Function for Pushbutton Confirm part - 2

Lecture 109 Create Click Function for Pushbutton Confirm part - 3

Lecture 110 Create Click Function for Pushbutton Confirm part - 4

Lecture 111 Create Click Function for Pushbutton Confirm part - 5

Lecture 112 Create Sale Table in Database

Lecture 113 Create Click Function for Pushbutton Confirm part - 6

Lecture 114 Create Click Function for Pushbutton Confirm part - 7

Lecture 115 Finish Create Click Function for Pushbutton Confirm

Lecture 116 Create Click Function for Pushbutton Home Page

Section 6: Statistics

Lecture 117 Introduction Statistics

Lecture 118 Create new Menu, MenuItem and Toolbar Statistics seller per month

Lecture 119 Create Click Funktion for MenuItem, Toolbar Icon Statistics seller per month

Lecture 120 Create Statistics Seller per Month Window Layout Part - 1

Lecture 121 Create Statistics seller per Month Window Layout Part - 2

Lecture 122 Finish Create Statistics seller per Month Window Layout

Lecture 123 Display picture in Label picture and add Items in Combobox seller name

Lecture 124 Create Click Function for Pushbutton Statistics seller per month Part - 1

Lecture 125 Create Click Function for Pushbutton Statistics seller per month Part - 2

Lecture 126 Create Click Function for Pushbutton Statistics seller per month Part - 3

Lecture 127 Finish Create Click Function for Pushbutton Statistics seller per month

Lecture 128 Create Click Function for Pushbutton Home page

Lecture 129 Create new MenuItem and Toolbar Statistics seller per year

Lecture 130 Create Statistics seller per year Window Layout

Lecture 131 Finish Create Statistics seller per year Window Layout

Lecture 132 Display picture in Label picture and add Items in Combobox seller name

Lecture 133 Create Click Function for Pushbutton Statistics seller per year

Lecture 134 Create Click Function for Pushbutton Home page

Lecture 135 Create new MenuItem and Toolbar Statistics Customer per Year

Lecture 136 Create Statistics Customer per year Window Layout

Lecture 137 Finish Create Statistics Customer per year Window Layout

Lecture 138 Display picture in Label picture and add Items in Combobox Customer name

Lecture 139 Create Click Function for Pushbutton Statistics Customer per Year

Lecture 140 Create Click Function for Pushbutton Home page

Lecture 141 Create new menuItem and Toolbar Icon and Click Function for menuItem and Icon St

Lecture 142 Create Statistics Car dealer per Month Window Layout

Lecture 143 Finish Create Statistics Car dealer per Month Window Layout

Lecture 144 Display picture in Label picture

Lecture 145 Create Click Function for Pushbutton Statistics Car dealer per month

Lecture 146 Finish Create Click Function for Pushbutton Statistics Car dealer per month

Lecture 147 Create Click Function for Pushbutton Home page

Lecture 148 Create new MenuItem and Toolbar Statistics car dealer per Year

Lecture 149 Create Statistics Car dealer per year Window Layout

Lecture 150 Finish Create Statistics Car dealer per year Window Layout

Lecture 151 Create Click Function for Pushbutton Statistics Car dealer per year

Lecture 152 Create Click Function for Pushbutton Home page

Lecture 153 Create EXE File

Lecture 154 Finish Create EXE File

The course is ideal for C++ programmers who want to develop professional desktop applications using the Qt Creator development environment.