Coding For Programmers Using Python: The Step-by-Step Guide to Learn PyQt and Database Applications

Vivian Siahaan, Rismon Hasiholan Sianipar

Summary

This book is a comprehensive guide to Python as one of the fastest-growing computer languages including Web and Internet applications. This clear and concise introduction to the Python language is aimed at readers who are already familiar with programming in at least one language. 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 PostgreSQL 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 PostgreSQL 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 get introduction of postgresql. And then, you will learn querying data from the postgresql using Python including establishing a database connection, creating a statement object, executing the query, processing the resultset object, querying data using a statement that returns multiple rows, querying data using a statement that has parameters, inserting data into a table using Python, updating data in postgresql database using Python, calling postgresql stored function using Python, deleting data from a postgresql table using Python, and postgresql Python transaction. 
In chapter seven, you will create dan configure PotgreSQL 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.

Available since: 11/29/2019.

Science & Technology

Other books that might interest you

Pilgrims of the Air - The Story...

John Wilson Foster

The story of the rapid and brutal extinction of the Passenger Pigeon, once so abundant that they 'blotted out the sky', until the last bird died on 1st September 1914. It is also an evocative story of wild America - the allure of its natural 'productions', its ruthless exploitation, and a morality tale for our times.

Show book

Options Trading - Learn How to...

Dexter Carlile

You Are 1-Click Away From Learning How To Leverage The Power Of Options Trading To Achieve Financial Freedom Whether You Are A Beginner Trader Or An Advanced Investor! 
At first, you may feel very uncertain about the whole idea of trading options but those jitters will dissolve immediately you know what you need to do and at what time in your options trading career. 
And that’s exactly what this audiobook seeks to achieve; so that you can dip your feet into the world of options trading with confidence, just like the pros. 
More precisely, this audiobook covers: The basics of options trading, including what options are, how options work, different types of options, the common terms used in options trading and much moreWhy trading options is a great investment opportunityHow to get started in options tradingHow to read charts and analyze different kinds of data in order to make sound options trading decisionsHow to leverage the power of swing trading and momentum trading to your advantageFinancial strategies that you can use as a beginnerThe ins and outs of buying call options like the pros How to maximize profits and keep your losses low using different strategiesPowerful advice that will keep you making profits and keeping your losses low throughout your options trading lifeAnd much more! 
Everything in here is easy to follow and to implement so you can be sure you won’t get lost! 
Click Buy Now With 1-Click or Buy Now to get started!

Show book

Women and the Machine -...

Julie Wosk

“An engaging study of the ways women and machines have been represented in art, photography, advertising, and literature.” —Arwen Palmer Mohun, University of Delaware 
 
From sexist jokes about women drivers to such empowering icons as Amelia Earhart and Rosie the Riveter, representations of the relationship between women and modern technology in popular culture have been both demeaning and celebratory. Depictions of women as timid and fearful creatures baffled by machinery have alternated with images of them as being fully capable of technological mastery and control—and of lending sex appeal to machines as products. 
 
In Women and the Machine, historian Julie Wosk maps the contradictory ways in which women’s interactions with—and understanding of—machinery has been defined in Western popular culture since the dawn of the Industrial Revolution. Drawing on both visual and literary sources, Wosk illuminates popular gender stereotypes that have burdened women throughout modern history while underscoring their advances in what was long considered the domain of men. Illustrated with more than 150 images, Women and the Machine reveals women rejoicing in their new liberties and technical skill even as they confront society’s ambivalence about these developments, along with male fantasies and fears. 
 
“Engaging and entertaining . . . Using illustrations, cartoons and photographs from the past three centuries, Wosk delineates shifts in social acceptance of women’s relationship to technology . . . her work is complex, comprehensive and highly readable.” —Publishers Weekly  
 
“Art historian Wosk analyzes the overt and covert messages in depictions of women and machines in an array of fiction and, more impressively, in some 150 visual images.” —Booklist

Show book

User Story Mapping - Discover...

Jeff Patton, Peter Economy

User story mapping is a valuable tool for software development, once you understand why and how to use it. This insightful book examines how this often misunderstood technique can help your team stay focused on users and their needs without getting lost in the enthusiasm for individual product features.

Author Jeff Patton shows you how changeable story maps enable your team to hold better conversations about the project throughout the development process. Your team will learn to come away with a shared understanding of what you're attempting to build and why.

Get a high level view of story mapping, with an exercise to learn key concepts quickly
Understand how stories really work, and how they come to life in Agile and Lean projects
Dive into a story's lifecycle, starting with opportunities and moving deeper into discovery
Prepare your stories, pay attention while they're built, and learn from those you convert to working software

Show book

Photography Express

KnowIt Express, Patrick Powers

Get on the express for photography. Know how to get into photography and become a professional photographer.
Welcome, aspiring photographer! You are here because you have a love for, or are interested in taking up the art of photography. Plain and simple. Well, good for you!
On the other hand if you're not, why should you get into photography?
You can invoke powerful feelings that move and inspire people. You can develop your artistic side and eye to see beauty in all things. You can capture people's precious moments to create priceless memories. You can make a difference by telling the world's stories through imagery. You can make money doing something fun, exciting, and stimulating.
Whether you want to be an editorial photographer, fashion photographer, event photographer, portrait photographer, commercial photographer, landscape photographer, etc., there are so many paths you could go with photography - as a profession, hobby, or just for fun.
But anybody can take a photo you say? On the surface, photography does seem like something anybody and their monkey can do; you hold a camera, focus it, and hit the shutter button. And don't think just being able to apply Instagram filters is what makes a photo professional.
It would be an insult to the real professionals out there to say that anybody with a camera or phone is a photographer; however, at the same, anybody certainly can become a photographer. It's simply a matter of having the basic foundation down then building upon that to continue mastering your craft.

Show book

Viruses - A Very Short Introduction

Dorothy H. Crawford

Viruses are big news. From pandemics such as HIV, swine flu, and SARS, we are constantly being bombarded with information about new lethal infections. In this Very Short Introduction, Dorothy Crawford demonstrates how clever these entities really are. From their discovery and the unravelling of their intricate structures, Crawford demonstrates how these tiny parasites are by far the most abundant life forms on the planet.In this fully updated edition, Crawford recounts stories of renowned killer viruses such as the recent Ebola and Zika epidemics, as well as Middle East Respiratory Syndrome, and considers the importance of air travel in facilitating the international spread of viruses in the twenty-first century. Discussing the impact of global warming, which is increasing the range of vector-transmitted viruses such as dengue, yellow fever, and West Nile virus, she also considers the effect this will have on native populations in subtropical and temperate climates of the Americas, Australasia, and Europe. By examining our lifestyle in the twenty-first century, Crawford looks to the future to ask whether we can ever live in harmony with viruses, and considers the ways in which we may need to adapt to prevent emerging viruses with devastating consequences.

Show book