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
Mariadb And Postgresql Crash Course: A Step By Step Project-Based Introduction To Python Gui Programming - 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!

Mariadb And Postgresql Crash Course: A Step By Step Project-Based Introduction To Python Gui Programming

Vivian Siahaan, Rismon Hasiholan Sianipar

Publisher: Rismon Hasiholan Sianipar

  • 0
  • 0
  • 0

Summary

In this book, you will create two MariaDB and PostgreSQL driven projects using PyQt. The step-by-step guide in this book is expected to help the reader's confidence to become a programmer who can solve database programming problems. A progressive project is provided to demonstrate how to apply the concepts of MariaDB and PostgreSQL using Python. 
In second chapter, you will learn PyQt that consists of a number of Python bindings for cross-platform applications that combine all the strengths of Qt and Python. By using PyQt, you can include all Qt libraries in Python code, so you can write GUI applications in Python. In other words, you can use PyQt to access all the features provided by Qt through Python code. Because PyQt depends on the Qt libraries at run time, you need to install PyQt. 
In third chapter, 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 fourth chapter, 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 this chapter, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables. 
In chapter five, 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 six, 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. 
In chapter seven, 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. 
In chapter eight, you will create two tables, Victim and Case_File. The Victim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven columns: case_file_id (primary key), suspect_id (foreign key), police_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.
Available since: 11/20/2019.

Other books that might interest you

  • Fulcrum and Torsion of the Helical Myocardium - cover

    Fulcrum and Torsion of the...

    Jorge C. Trainini, Mario...

    • 0
    • 0
    • 0 
    In this new book, Trainini and his team attempt a step forward and make a series of proposals that come to complete cardiac anatomy, physiology and mechanics. Reading this new investigation is a pleasure that demands continuous attention, so that our "neuronal boxes" do not rebel against the effort it means to sometimes destroy what we have firmly installed in them. The text should be read slowly, as it was never easy to tread in swamp-limited grounds and, as in the ascent to the summit of a difficult mountain, stop now and then to take a breath and enjoy the view as we get near the peak, where we will see the final landscape of the new vision. Then we will be conscious that the effort was worthwhile.
    Show book
  • Camping for Kids - cover

    Camping for Kids

    Sharon Ashley

    • 0
    • 0
    • 0 
    Nature is a playground of endless possibilities in "Camping for Kids," memories are made as fresh, fun, and timeless classic adventures unfold.  Fun book for kids that enjoy camping stories.
    Show book
  • To Engineer Is Human - The Role of Failure in Successful Design - cover

    To Engineer Is Human - The Role...

    Henry Petroski

    • 0
    • 0
    • 0 
    How did a simple design error cause one of the great disasters of the 1980s—the collapse of the walkways at the Kansas City Hyatt Regency Hotel? What made the graceful and innovative Tacoma Narrows Bridge twist apart in a mild wind in 1940? How did an oversized waterlily inspire the magnificent Crystal Palace, the crowning achievement of Victorian architecture and engineering? These are some of the failures and successes that Henry Petroski, author of the acclaimed The Pencil, examines in this engaging, wonderfully literate book. More than a series of fascinating case studies, To Engineer Is Human is a work that looks at our deepest notions of progress and perfection, tracing the fine connection between the quantifiable realm of science and the chaotic realities of everyday life.
    Show book
  • A Student's Guide to Natural Science - cover

    A Student's Guide to Natural...

    Stephen M. Barr

    • 0
    • 0
    • 0 
    A concise introduction to scientific history and ideas, with a special emphasis on physics and astronomy. Physicist Stephen M. Barr’s lucid Student’s Guide to Natural Science aims to give students an understanding, in broad outline, of the nature, history, and great ideas of natural science from ancient times to the present, with a primary focus on physics. Barr begins with the contributions of the ancient Greeks, in particular the two great ideas that reality can be understood by the systematic use of reason and that phenomena have natural explanations. He goes on to discuss, among other things, the medieval roots of the scientific revolution of the seventeenth century, the role played by religion in fostering the idea of a lawful natural order, and the major breakthroughs of modern physics, including how many newer “revolutionary” theories are in fact related to much older ones. Throughout this thoughtful guide, Barr draws his readers’ attention to the larger themes and trends of scientific history, including the increasing unification and “mathematization” of our view of the physical world that has resulted in the laws of nature appearing more and more as forming a single harmonious mathematical edifice.
    Show book
  • The Way Of Wisdom - cover

    The Way Of Wisdom

    John Broomfield

    • 0
    • 0
    • 0 
    Examining alternative and complementary ways of learning about reality is a wondrous way to enlarge your perspective and become a more whole human being.  Rediscovering sacred traditions, ancient cultures and your own intuition, as well as communing with nature and discovering the more holistic explanations of how things happen are some of the ways John Broomfield has found to uncover other ways of knowing.
    Show book
  • COMPTIA NETWORK+ - Simple and Effective Strategies for Mastering CompTIA Network+ Certification from A-Z - cover

    COMPTIA NETWORK+ - Simple and...

    Walker Schmidt

    • 0
    • 0
    • 0 
    The CompTIA Network+ certification has become a mainstay staple of the IT world. It is proof that an IT professional is capable of designing, implementing, and configuring functional networks. 
Despite this, there’s a dreadful lack of quality guides made by people with actual experience on the subject. 
Do you want to finish the CompTIA Network+ certification without a hitch? 
Do you want to learn all the knowledge you’ll need to know to maintain, design, and implement your own functional networks? 
Do you want to understand how to troubleshoot your network problems? 
Then this is the guide for you! 
In this 3rd installment of the CompTIA Network+ guides, we’ll be bringing all of the knowledge you gained from the first two full circle and tie everything together for you. Furthermore, we’ll take some of the subjects that we haven’t quite explored entirely and go in even more depth. 
By the end of this book, you’ll be able to walk into any test and pass it with flying colors. 
If you want to be able to confidently not only say that you passed the CompTIA Network+ certification exam, but that you are a true IT professional, then this is the right series for you.
    Show book