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 Absolute Beginner’s Guide to Learn Python GUI with MySQL and SQL Server Databases - 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 Absolute Beginner’s Guide to Learn Python GUI with MySQL and SQL Server Databases

Vivian Siahaan, Rismon Hasiholan Sianipar

Publisher: SPARTA PUBLISHING

  • 0
  • 0
  • 0

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.

Other books that might interest you

  • The Mantis - A mountaineering novel - cover

    The Mantis - A mountaineering novel

    Philip Temple

    • 0
    • 0
    • 0 
    It is not the courage to go back up that we need. It's the courage to go down. Just to go on … ' In 1977 a British expedition led by Himalayan veteran Geoff Strickland, summiteer of K2 and Everest among others, set off to attempt the first ascent of unclimbed Puthemojar - the 'Mantis' - in the Karakoram. 25,311 feet high, renowned for its difficulty, and with a fearsome reputation, the Mantis had claimed the life of at least one climber on each of the previous expeditions that had attempted to scale its complex series of ridges and icefalls. In order to claim the coveted first ascent, Strickland put together a small team comprising the cream of British mountaineering talent: his long-time Himalayan climbing partner and photographer Michael Blackmore; the redoubtable northerner Joe Dodge, as tough as they come; Dodge's regular partner and another veteran of numerous Himalayan expeditions Doug Lowrie; and two young guns - Brit Alan Wyllie, and Kiwi Peter Chase, a pair who had been tearing up the Alpine rule book with daring ascents on the steepest and most difficult faces. Although Michael Blackmore's 1980 record of the climb - The Last Challenge - has become a classic of mountaineering literature, Blackmore himself was never satisfied it told the full story of the events on Puthemojar in 1977. Before his death in 2000, Blackmore had prepared a draft manuscript - a 'creative narrative' - of the expedition which, with thanks to Blackmore's widow, has now been completed by award-winning author and mountaineer Philip Temple. While perhaps best regarded as a work of fiction, The Mantis tells for the first time the gripping story of that 1977 British expedition to Puthemojar. It is a portrait of these men, their drive, this mountain and a credible testimony of just what went on, high on the Mantis.
    Show book
  • Ossman & Steel's Classic Household Guide to Appalachian Folk Healing - A Collection of Old Time Remedies Charms and Spells - cover

    Ossman & Steel's Classic...

    Silver Ravenwolf

    • 0
    • 0
    • 0 
    A long-treasured but forgotten classic of folk healing, with an introduction and commentary by the author of Backwoods Witchcraft and Doctoring the Devil.Ossman & Steel's Guide to Health or Household Instructor (its original title) is a collection of spells, remedies, and charms. The book draws from the old Pennsylvania Dutch and German powwow healing practices that in turn helped shape Appalachian folk healing, conjure, root work, and many folk healing traditions in America. Jake Richards, author of Backwoods Witchcraft and Doctoring the Devil, puts these remedies in context, with practical advice for modern-day "backwoods" healers interested in using them today.The first part contains spells and charms for healing wounds, sties, broken bones, maladies, and illnesses of all sorts. The second part includes other folk remedies using ingredients based on sympathetic reasoning, including sulfuric acid, gunpowder, or other substances for swelling, toothache, headache, and so on. These remedies are presented here for historic interest, to help better understand how folk medicine evolved in America. It is Jake Richards's hope that reintroducing this work will reestablish its position as a useful household helper in the library of every witch or country healer.
    Show book
  • Hypnosis for Finding Happiness - Rewire Your Mindset And Get Fast Results With Hypnosis! - cover

    Hypnosis for Finding Happiness -...

    Empowered Living

    • 0
    • 0
    • 0 
    The advantages of hypnosis therapy are widespread. A lot of individuals report positive changes with hypnosis and it's recognized as a valid type of holistic alternative medicine. 
Hypnosis is a popular technique utilized for weight loss, overcoming addiction, healing, achieving goals, relaxation and stress relief. It's utilized to get rid of undesired behaviors and beliefs and to manifest new desires and achieve goals in life. 
  
If you wish to influence your subconscious mind to accept new programming for positive alterations hypnosis is an effective technique for doing that. 
Among the chief advantages of hypnosis is that when you in a hypnotic state brain wave frequencies decelerate. You center or focus your awareness and you're actually much more aware than usual. A state of centered awareness almost feels as though you're more of an observer of thought and images rather than a part of them. This allows you to bypass the "gatekeepers" at the entrance to the subconscious and superconscious so you are able to access these levels of consciousness directly, and the brain is much more receptive to suggestion. 
The unconscious, or subconscious may then be reprogrammed so it lets go of old patterns, beliefs and feelings that no longer serve you. They may be replaced with suggestions that are favorable and affirming. The superconscious mind may open you into fresh insights and originative ideas. 
Put this audio on each night before you go to bed and listen to it right before you fall asleep. If you have time also listen to it first thing upon waking. Do this for at least 21 days consistently so that positive change can take affect in your life.
    Show book
  • Backyard Homesteading - Growing Flowers and Beekeeping in an Urban House - cover

    Backyard Homesteading - Growing...

    Mona Greeny

    • 0
    • 0
    • 0 
    If you're looking to find proven and effective ways to start turning your home into a self-sufficient homestead, you've come to the right place. It's about time to start seeing for yourself what you can accomplish by becoming more independent. A little backyard homestead can turn your home into a castle that you can depend on, even on the harshest days. You don't have to worry about the lack of experience with farming or raising animals if you closely follow the detailed steps mentioned in this book. From picking species of flowers for your backyard to making your first beehive, this book will be your best guide. Here's what you can expect to learn from our guides. Understand the historical roots of homesteading and what made it a lucrative option for many individuals in the past.Learn from an overview of the most recommended tools that you'll need when it comes to gardening and beekeeping.Gain insight into what makes a specific design or setup more suitable for you than others.Learn how to look for the ideal types of flowers that suit your garden in various climates.Find input that helps you design the perfect garden for your backyard homestead.Learn how to till soil and plant flowers quickly.Learn from tips that help you keep your garden in tip-top shape.Know what to consideration when you're still a beginner beekeeper.Find out how you can make your own DIY beehive from A to Z. 
There is no need to worry about messing your homestead garden up or mistreating your bees when you have this valuable resource in your possession. While this book will certainly make things easier, it's still your responsibility to put in the required effort if you want to reap the rewards. Click the Buy Now button to get started with this amazing guide for backyard homesteading for the urban house.
    Show book
  • Beekeeping for Beginners - A Comprehensive Beginner’s Guide to Bee farming - cover

    Beekeeping for Beginners - A...

    Melibeth Wilson

    • 0
    • 0
    • 0 
    Welcome to the world of beekeeping! Whether you're looking 
to start your own hive, or simply learn more about these 
fascinating creatures, you've come to the right place. 
What is Beekeeping? 
Beekeeping, also known as apiculture, is the practice of managing 
honey bee colonies, typically in hives, by humans. It is a form of 
agriculture that has been practiced for centuries, and is used to 
produce honey, beeswax, pollen, propolis, and other bee products.
    Show book
  • Isambard Kingdom Brunel - cover

    Isambard Kingdom Brunel

    Robin Jones

    • 0
    • 0
    • 0 
    A biography of the nineteenth-century Englishman who was “one of the most ingenious and prolific figures in engineering history” (Nature).   Civil and mechanical engineer Isambard Kingdom Brunel’s accomplishments were extraordinary—involving the Great Western Railway, the SS Great Britain, the Clifton Suspension Bridge, prefabricated hospital buildings for use during the Crimean War, and more. Born in Portsmouth in 1806, he followed in his French father’s professional footsteps—and went on to play a major role in the Industrial Revolution.   Brunel the great engineer would habitually throw out the rule book of tradition and established practice and start again with a blank sheet of paper, taking the technology of the day to its limits and then going another mile. But there was also Brunel the visionary, who knew that transport technology had the power to change the world, and that he had the ability to deliver those changes. Finally, there was Brunel the artist, who rarely saw technology as just functional, and strove to entwine the fruits of the Industrial Revolution with the elegance and grace of the neoclassical painter. His bridges, tunnels and railway infrastructure have entered a third century of regular use, and the beauty of their design and structure has rarely been equaled.   The three decades from the 1830s to the 1850s saw an explosion of technical excellence, and it was Brunel who in so many cases lit the blue touch paper. He did not always get it right the first time, and it was left to others to reap the fruits of his many labors. Nevertheless, his actions fast-forwarded the march of progress by several decades. This biography tells his impressive story.  Includes color photographs
    Show book