The Absolute Beginner’s Guide to Learn Python GUI with MySQL and SQL Server Databases

Vivian Siahaan, Rismon Hasiholan Sianipar

Summary

This hands-on book introduces the essential topic of coding and the Python computer language to beginners and pogrammers of all ages. This book explains relational theory in practice, and demonstrates through two projects how you can apply it to your use of MySQL and SQL Server databases. This book covers the important requirements of teaching databases with a practical and progressive perspective. This book offers the straightforward, practical answers you need to help you do your job. This hands-on tutorial/reference/guide to MySQL and SQL Server is not only perfect for students and beginners, but it also works for experienced developers who aren't getting the most from both databases. In designing a GUI and as an IDE, you will make use Qt Designer.
In the first chapter, you will learn to use several widgets in PyQt5: Display a welcome message; Use the Radio Button widget; Grouping radio buttons; Displays options in the form of a check box; and Display two groups of check boxes.
In chapter two, you will learn to use the following topics: Using Signal / Slot Editor; Copy and place text from one Line Edit widget to another; Convert data types and make a simple calculator; Use the Spin Box widget; Use scrollbars and sliders; Using the Widget List; Select a number of list items from one Widget List and display them on another Widget List widget; Add items to the Widget List; Perform operations on the Widget List; Use the Combo Box widget; Displays data selected by the user from the Calendar Widget; Creating a hotel reservation application; and Display tabular data using Table Widgets.
In chapter three, you will learn: How to create the initial three tables project in the School database: Teacher, Class, and Subject tables; How to create database configuration files; How to create a Python GUI for inserting and editing tables; How to create a Python GUI to join and query the three tables.
In chapter four, you will learn how to: Create a main form to connect all forms; Create a project will add three more tables to the school database: Student, Parent, and Tuition tables; Create a Python GUI for inserting and editing tables; Create a Python GUI to join and query over the three tables.
In chapter five, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables.
In chapter six, you will create dan configure database. In this chapter, you will create Suspect table in crime database. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table.
In chapter seven, you will create a table with the name Feature_Extraction, which has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. The six fields (except keys) will have VARBINARY(MAX) data type. You will also create GUI to display, edit, insert, and delete for this table.
In chapter eight, you will create two tables, Police and Investigator. The Police table has six columns: police_id (primary key), province, city, address, telephone, and photo. The Investigator table has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables.

Available since: 02/01/2020.

Science & Technology

Other books that might interest you

Cryptography - A Very Short...

Fred Piper, Sean Murphy

This book is a clear and informative introduction to cryptography and data protection—subjects of considerable social and political importance. It explains what algorithms do, how they are used, the risks associated with using them, and why governments should be concerned. Important areas are highlighted, such as Stream Ciphers, block ciphers, public key algorithms, digital signatures, and applications such as e-commerce. This book highlights the explosive impact of cryptography on modern society, with, for example, the evolution of the internet and the introduction of more sophisticated banking methods.

Show book

The Matter of Vision - Affective...

Peter Wyeth

A filmmaker draws on the fields of neuroscience and evolutionary biology to focus on cinema’s visual nature. 
 
Cinematic analysis has often supported the notion that cinema can be understood by drawing parallels with language. Peter Wyeth contends that this analytical framework often fails to consider the fundamental fact of cinema’s visual nature. 
 
In The Matter of Vision, Wyeth seeks to redress this oversight by grounding his analysis in neuroscience and evolutionary biology, finding herein the potential for a qualitatively superior understanding of the cinematic medium.

Show book

The Opioid Epidemic - What...

Yngvild Olsen, Joshua M. Sharfstein

The opioid epidemic is responsible for longest sustained decline in US life expectancy since the time of World War I and the Great Influenza. In 2017, nearly 50,000 Americans died from an opioid overdose - with an estimated two million more living with opioid addiction every day.
 
The Opioid Epidemic: What Everyone Needs to Know is an accessible, nonpartisan overview of the causes, politics, and treatments tied to the most devastating health crisis of our time. Its comprehensive approach and Q&A format offer listeners a practical path to understanding the epidemic from all sides: the basic science of opioids; the nature of addiction; the underlying reasons for the opioid epidemic; effective approaches to helping individuals, families, communities, and national policy; and common myths related to opioid addiction.
 
Written by two expert physicians and enriched with stories from their experiences in the crosshairs of this epidemic, this audiobook is a critical resource for any general listener - and for the individuals and families fighting this fight in their own lives.

Show book

In Search of Medicine's Moral...

Rob Tenery

A veteran physician shares his opinion on the state of health care in America and what needs to be done to change it. In an age where uncertainty rules the day, Dr. Rob Tenery explains how health care has evolved into a $2.6 trillion enterprise. He does this with carefully researched histories and a series of challenging and thought-provoking commentaries on the most important issues of the day. Dr. Tenery’s book focuses on a time when doctors and patients worked together to determine the best course of treatment—solutions now being ceded to large corporations and the federal government. He relates, as only a physician can, the challenges, fulfillment, and ethical dilemmas of caring for patients and making the best decisions for their health and well-being. Whether contemplating what doctors can do when nothing can be done, or thinking about the state of the medical profession, his insights are based on real-life experiences with his patients and colleagues. Dr. Tenery brings a perspective and a set of values gained from his father and grandfather, who, together with the author, represent over a century of caring for patients. This book gives you the opportunity to step into the shoes of a dedicated third-generation physician and to see the changing nature of health and medical care through his eyes. This physician of over thirty-seven years is sharing his collected writing for a better understanding of why medicine is a profession and not just another business.

Show book

Pinterest - The Ultimate Guide...

George J. Legend

Do you have a business that uses Social Media?Have you traditionally stuck to the big two like Facebook and Twitter?Do you need something a bit different?As far as Social Media goes they are all much the same. Build a profile, post or tweet messages and maybe add a photograph for occasional interest once in a while. Pinterest is different, however, providing a more visual feast for customers to enjoyNow, with Pinterest: The Ultimate Guide to Pinterest for Business with A Proven System to Automate for Profit, you can learn how to expand your business by adding this Social Media revelation to your arsenal, with a look at:- Introduction to Pinterest & the People Who Live There- The Perfect Sites for Pinterest Traffic- How to Drive Huge Traffic from Pinterest to your Site- Increasing your Following and Networking- How to Market to the Pinterest AudienceWith an estimated 250 million active monthly users, Pinterest is growing steadily among the business community and is likely to continue at a pace as it adds new and exciting features.Don’t miss out on the opportunity for your business to reach out to this ever increasing market. Get a copy of Pinterest: The Ultimate Guide to Pinterest for Business with A Proven System to Automate for Profit and make sure your business is getting the coverage it needs.

Show book

How Rwanda became a global...

PBS NewsHour

Rwanda emerged from its genocide in 1994 to build one of the most successful AIDS responses in Africa and is now working mightily to halt mother-to-child HIV transmissions. They’re doing it with a creative mix of science, technology and “aggressive neighborliness.” William Brangham reports with support from the Pulitzer Center on Crisis Reporting for the fourth part of our series, The End of AIDS?

Show book