Book Image

Qt5 C++ GUI Programming Cookbook

By : Eng
Book Image

Qt5 C++ GUI Programming Cookbook

By: Eng

Overview of this book

With the advancement of computer technology, the software market is exploding with tons of software choices for the user, making their expectations higher in terms of functionality and the look and feel of the application. Therefore, improving the visual quality of your application is vital in order to overcome the market competition and stand out from the crowd. This book will teach you how to develop functional and appealing software using Qt5 through multiple projects that are interesting and fun. This book covers a variety of topics such as look-and-feel customization, GUI animation, graphics rendering, implementing Google Maps, and more. You will learn tons of useful information, and enjoy the process of working on the creative projects provided in this book
Table of Contents (11 chapters)
10
Index

Advanced SQL queries


By following this recipe, we will learn how to use advanced SQL statements such as INNER JOIN, COUNT, LIKE, DISTINCT, and so on.

How to do it…

You can do a lot more than just perform simple queries of SQL database:

  1. First of all, we need to add a few tables to our database before we can dive into the programming part. Open up your web browser and access your phpMyAdmin. We need several tables for this example to work:

  2. I will show you the structure of each of the tables required for this project and the dummy data inserted to the tables for testing. The first table is called branch, which is used to store the IDs and names of different branches of the dummy company:

  3. Secondly, we have the department table, which stores the IDs and names of different departments of the dummy company, which is also linked to the branch data by the branch IDs:

  4. Next, we also have an employee table, which stores the information of all the employees in the dummy company. This table is similar to the...