Join us on a literary world trip!
Add this book to bookshelf
Grey
Write a new comment Default profile 50px
Grey
Subscribe to read the full book or read the first pages for free!
I want to read the book!
All characters reduced
The Beginner’s Guide to Learn Python GUI with PostgreSQL and SQLite - cover

We are sorry! The publisher (or author) gave us the instruction to take down this book from our catalog. But please don't worry, you still have more than 500,000 other books you can enjoy!

The Beginner’s Guide to Learn Python GUI with PostgreSQL and SQLite

Vivian Siahaan, Rismon Hasiholan Sianipar

Publisher: SPARTA PUBLISHING

  • 0
  • 0
  • 0

Summary

This book explains relational theory in practice, and demonstrates through two projects how you can apply it to your use of PostgreSQL and SQLite 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 SQLite 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 and chapter seven, 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 eight, 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. 
In chapter nine, 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 a VARCHAR data type (200). You will also create GUI to display, edit, insert, and delete for this table.
Available since: 01/31/2020.

Other books that might interest you

  • Hacking the Future - Privacy Identity and Anonymity on the Web - cover

    Hacking the Future - Privacy...

    Cole Stryker

    • 0
    • 0
    • 0 
    Is anonymity a crucial safeguard—or a threat to society? “One of the most well-informed examinations of the Internet available today” (Kirkus Reviews).   “The author explores the rich history of anonymity in politics, literature and culture, while also debunking the notion that only troublemakers fear revealing their identities to the world. In relatively few pages, the author is able to get at the heart of identity itself . . . Stryker also introduces the uninitiated into the ‘Deep Web,’ alternative currencies and even the nascent stages of a kind of parallel Web that exists beyond the power of governments to switch it off. Beyond even that is the fundamental question of whether or not absolute anonymity is even possible.” —Kirkus Reviews   “Stryker explains how significant web anonymity is to those key companies who mine user data personal information of, for example, the millions of members on social networks. . . . An impassioned, rational defense of web anonymity and digital free expression.” —Publishers Weekly
    Show book
  • A Taste for Poison - Eleven Deadly Molecules and the Killers Who Used Them - cover

    A Taste for Poison - Eleven...

    Neil Bradbury Ph.D.

    • 0
    • 0
    • 0 
    This program includes an epilogue and acknowledgements read by the author“A fascinating tale of poisons and poisonous deeds which both educates and entertains.” --Kathy ReichsAs any reader or listener of murder mysteries can tell you, poison is one of the most enduring—and popular—weapons of choice for a scheming murderer. It can be slipped into a drink, smeared onto the tip of an arrow or the handle of a door, even filtered through the air we breathe. But how exactly do these poisons work to break our bodies down, and what can we learn from the damage they inflict?In a fascinating blend of popular science, medical history, and true crime, Dr. Neil Bradbury explores this most morbidly captivating method of murder from a cellular level. Alongside real-life accounts of murderers and their crimes—some notorious, some forgotten, some still unsolved—are the equally compelling stories of the poisons involved: eleven molecules of death that work their way through the human body and, paradoxically, illuminate the way in which our bodies function.Drawn from historical records and current news headlines, A Taste for Poison weaves together the tales of spurned lovers, shady scientists, medical professionals and political assassins to show how the precise systems of the body can be impaired to lethal effect through the use of poison. From the deadly origins of the gin & tonic cocktail to the arsenic-laced wallpaper in Napoleon’s bedroom, A Taste for Poison leads listeners on a fascinating tour of the intricate, complex systems that keep us alive—or don’t.A Macmillan Audio production from St. Martin's Press
    Show book
  • Social Media Tactics Bundle 2 in 1 Bundle - cover

    Social Media Tactics Bundle 2 in...

    Lindsey Hemming, Marvin Rufus

    • 0
    • 0
    • 0 
    Social Media Tactics Bundle, 2 in 1 Bundle: The Social Media Sales Revolution and Social Media Marketing TipsYou can use social media sites as a way to market your business, services or products. Using social media allows the business owner to interact on a more personal level with his or her audience and create a ripple through the internet. One simple video can turn into a plethora of traffic. Social media marketing can be a very daunting task, especially if you are new to the process. Knowing what to do and not to do is the key to your success in this area. A lot of marketers have all sorts of wrong ideas about social media marketing. Some think that you only need to post "viral content" to get tons of traffic overnight. There is an assumption that social traffic, regardless of which platform it comes from and regardless of how you qualify that traffic, converts to sales readily. Sadly, none of these assumptions are true. In fact, all of them are tragically mistaken.In this bundle, you will learn the social media marketing strategies that truly work and will actually get money to your bank account. You will learn what actually works and those that don’t so you don’t waste time, money and resources. It will teach you useful tips that will help you to maximize your return on your social media marketing campaign. It will teach you how to come up with a marketing plan that you can work from to make the social sites on the internet your new marketing domain.This 2 in 1 bundle includes the following audiobooks:1. The Social Media Sales Revolution:  The Ultimate Guide on Social Media Marketing. Discover How Social Media Campaigns Can Translate to More Sales for Your Business2. Social Media Marketing Tips: Get All the Proven Social Media Marketing Strategies that are Guaranteed to Turn Traffic into Hard Cash in Your Bank Account!If you want to learn more, download your copy of Social Media Tactics 2 in 1 Bundle today!
    Show book
  • Summary and Analysis of The Sixth Extinction: An Unnatural History - Based on the Book by Elizabeth Kolbert - cover

    Summary and Analysis of The...

    Worth Books

    • 0
    • 0
    • 0 
    So much to read, so little time? This brief overview of The Sixth Extinction tells you what you need to know—before or after you read Elizabeth Kolbert’s book. Crafted and edited with care, Worth Books set the standard for quality and give you the tools you need to be a well-informed reader.   This short summary and analysis of The Sixth Extinction: An Unnatural History by Elizabeth Kolbert includes: Historical contextChapter-by-chapter overviewsDetailed timeline of key eventsImportant quotesFascinating triviaGlossary of termsSupporting material to enhance your understanding of the original work  About The Sixth Extinction by Elizabeth Kolbert:   Our planet has endured five events of mass extinction, from centuries of catastrophic heating and cooling to the asteroid that fell to earth and ended the Cretaceous Period. We are currently facing the sixth extinction, and this time the human species is to blame.   Elizabeth Kolbert travels the world and meets with scientists who are grappling with the ecological outcomes of human activity. Her Pulitzer Prize–winning modern science classic tells the stories of thirteen different species that have already disappeared or are on the brink of extinction as a result of human activity.   A captivating blend of research and historical anecdotes enlightens readers about the unintentional consequences of our behaviors, from climate change and global warming to invasive species and overexploitation.   The summary and analysis in this ebook are intended to complement your reading experience and bring you closer to a great work of nonfiction.
    Show book
  • Science and Hypothesis - cover

    Science and Hypothesis

    Henri Poincaré

    • 0
    • 0
    • 0 
    Jules Henri Poincaré (1854 – 1912) was one of France's greatest mathematicians and theoretical physicists, and a philosopher of science.As a mathematician and physicist, he made many original fundamental contributions to pure and applied mathematics, mathematical physics and celestial mechanics. He was responsible for formulating the Poincaré conjecture, one of the most famous problems in mathematics. In his research on the three-body problem, Poincaré became the first person to discover a chaotic deterministic system which laid the foundations of modern chaos theory. He is considered to be one of the founders of the field of topology. Poincaré introduced the modern principle of relativity and was the first to present the Lorentz transformations in their modern symmetrical form. He discovered the remaining relativistic velocity transformations and recorded them in a letter to Lorentz in 1905. Thus he obtained perfect invariance of all of Maxwell's equations, an important step in the formulation of the theory of special relativity. (Summary from Wikipedia)
    Show book
  • Planetwalker - 22 Years of Walking 17 Years of Silence - cover

    Planetwalker - 22 Years of...

    John Francis Ph. D.

    • 0
    • 0
    • 0 
    When the struggle to save oil-soaked birds and restore blackened beaches left him feeling frustrated and helpless, John Francis decided to take a more fundamental and personal stand: he stopped using all forms of motorized transportation. Soon after embarking on this quest that would span two decades and two continents, the young man took a vow of silence that endured for seventeen years. It began as a silent environmental protest, but as a young African-American man, walking across the country in the early 1970s, his idea of "the environment" expanded beyond concern about pollution and loss of habitat to include how we humans treat each other and how we can better communicate and work together to benefit the earth. Through his silence and walking, he learned to listen and, along the way, earned college and graduate degrees in science and environmental studies. The United Nations appointed him goodwill ambassador to the world's grassroots communities and the U.S. government recruited him to help address the Exxon Valdez disaster. Was he crazy? How did he live and earn all those degrees without talking? An amazing human-interest story with a vital message, Planetwalker is also a deeply personal and engaging coming-of-age odyssey.
    Show book