As many books as you want!
Add this book to bookshelf
Grey
Write a new comment Default profile 50px
Grey
Read online the first chapters of this 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 1 million other books to choose from, so you can read without limits!

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.

Other books that might interest you

  • Think Little - Essays - cover

    Think Little - Essays

    Wendell Berry

    • 0
    • 1
    • 0
    The first in the new Counterpoints series, Think Little is an evergreen, ever-urgent, and now pocket-sized argument for focused and inclusive climate change activism
    Designed and priced for point-of-sale, the Counterpoints series will feature essays, poems, and stories from Wendell Berry, Gary Snyder, Mary Robison, Betty Fussell, MFK Fisher, and many more
    Berry argues that environmental activism and policy change cannot only be a public, large-scale, corporate- and organization-led; instead, changes must happen at the person, individual, and community levels in order for our attempts to slow climate change to be successful. Just as the Civil Rights movement had to become personal, had to be adopted in homes and communities across the country in order to gain momentum and critical mass, so too does environmental activism
    Berry also reminds us that the forces that would exploit people based on their race, gender, and socioeconomic status are the same forces that are content to exploit the earth for its natural resources
    Show book
  • Listening to the Bees - cover

    Listening to the Bees

    Mark Winston, Renée Sarojini...

    • 0
    • 1
    • 0
    Listening to the Bees is a collaborative exploration by two writers to illuminate the most profound human questions: Who are we? Who do we want to be in the world?
     
    Through the distinct but complementary lenses of science and poetry, Mark Winston and Renée Saklikar reflect on the tension of being an individual living in a society, and about the devastation wrought by overly intensive management of agricultural and urban habitats.
     
    Listening to the Bees takes readers into the laboratory and out to the field, into the worlds of scientists and beekeepers, and to meetings where the research community intersects with government policy and business. The result is an insiders’ view of the way research is conducted—its brilliant potential and its flaws—along with the personal insights and remarkable personalities experienced over a forty-year career that parallels the rise of industrial agriculture.
    Show book
  • Theory of Thought - Symbolism - cover

    Theory of Thought - Symbolism

    Jason Shaw

    • 0
    • 2
    • 0
    Theory of Thought presents a simplified way of understanding the impact of symbolism upon society. It employs a new methodology of using basic shapes and concepts to reveal a unique theory of symbols helping to explain human philosophy, religion, and mathematics. 
     
    It explains how all things and ideas are created and governed by some basic patterns. Discover the simple architecture of the 'hyperdimensional' symbols that rule the world and their forces of attraction that pull directly on the minds of all people.
    Show book
  • Radical Botany - Plants and Speculative Fiction - cover

    Radical Botany - Plants and...

    Natania Meeker, Antónia Szabari

    • 0
    • 1
    • 0
    Radical Botany uncovers a speculative tradition that conjures new languages to grasp the life of plants in all its specificity and vigor. Plants complement and challenge notions of human life. The book traces the implications of the speculative mobilization of plants within literature and art for feminism, queer studies, and posthumanist thought.
    Show book
  • Imagining the Future of Climate Change - World-Making through Science Fiction and Activism - cover

    Imagining the Future of Climate...

    Shelley Streeby

    • 0
    • 2
    • 0
    From the 1960s to the present, activists, artists, and science fiction writers have imagined the consequences of climate change and its impacts on our future. Authors such as Octavia Butler and Leslie Marmon Silko, movie directors such as Bong Joon-Ho, and creators of digital media such as the makers of the Maori web series Anamata Future News have all envisioned future worlds during and after environmental collapse, engaging audiences to think about the earth’s sustainability. As public awareness of climate change has grown, so has the popularity of works of climate fiction that connect science with activism. Today, real-world social movements helmed by Indigenous people and people of color are leading the way against the greatest threat to our environment: the fossil fuel industry. Their stories and movements—in the real world and through science fiction—help us all better understand the relationship between activism and culture, and how both can be valuable tools in creating our future. Imagining the Future of Climate Change introduces readers to the history and most significant flashpoints in climate justice through speculative fictions and social movements, exploring post-disaster possibilities and the art of world-making.
    Show book
  • Honour Restored - The Battle of Britain Dowding and the Fight for Freedom - cover

    Honour Restored - The Battle of...

    Peter Brown AFC

    • 0
    • 1
    • 0
    At the outbreak of the second World War, Air Chief Marshall Dowding was Commander-in-Chief of RAF Fighter Command, which had been set up three years earlier to protect Britain against attacks from the air and the threat of invasion.  London was subjected to extensive night bombing for several months.  However, our fighter squadrons and defence systems enabled us to maintain master of the air.  The Battle of Britain ended in 1940 and our island was never again under the threat of invasion.
    
    Peter Brown, former Battle of Britain Spitfire pilot, presents a vivid account of Britain under the threat of invasion, reminding us of the bravery of our fighter pilots and the courage of the people of Britain who endured the hardships of war and terror bombing from the air.  Through personal experience and years of meticulous research Peter offers a careful analysis of the battle and the tactics involved, vigorously defending Dowding's command and exposing the conspiracy of senior officers that saw him removed from office without due recognition for his achievement.
    
    PETER BROWN joined the RAF in 1938 and was a Spitfire pilot in both 11 and 12 Groups during the Battle of Britain.  He was awarded the Air Force Cross for his service.
    Show book