The Quick Tutorial to Learn Database Programming Using Pytho…

The Quick Tutorial to Learn Database Programming Using Pytho...

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.

Download Now Read Online

The Quick Tutorial To Learn Database Programming Using Python Gui With Mariadb And Postgresql


The Quick Tutorial To Learn Database Programming Using Python Gui With Mariadb And Postgresql Download Now Read Online

Author by : Vivian Siahaan
Languange Used : en
Release Date : 2020-01-15
Publisher by : SPARTA PUBLISHING






Learn Pyqt By Example A Quick Start Guide To Mysql And Sqlite Driven Programming


Learn Pyqt By Example A Quick Start Guide To Mysql And Sqlite Driven Programming Download Now Read Online

Author by : Vivian Siahaan
Languange Used : id
Release Date : 2019-11-24
Publisher by : SPARTA PUBLISHING






The Absolute Beginner S Guide To Learn Database Programming Using Python Gui With Postgresql And Sql Server


The Absolute Beginner S Guide To Learn Database Programming Using Python Gui With Postgresql And Sql Server Download Now Read Online

Author by : Vivian Siahaan
Languange Used : en
Release Date : 2020-01-16
Publisher by : SPARTA PUBLISHING






The Best Tutorial To Learn Database Programming With Java Gui Mariadb And Sql Server


The Best Tutorial To Learn Database Programming With Java Gui Mariadb And Sql Server Download Now Read Online

Author by : Vivian Siahaan
Languange Used : en
Release Date : 2020-01-08
Publisher by : SPARTA PUBLISHING






A Step By Step To Database Programming Using Python Gui And Mariadb


A Step By Step To Database Programming Using Python Gui And Mariadb Download Now Read Online

Author by : Vivian Siahaan
Languange Used : en
Release Date : 2020-01-06
Publisher by : SPARTA PUBLISHING






The Self Taught Coder The Definitive Guide To Database Programming With Python And Mysql


The Self Taught Coder The Definitive Guide To Database Programming With Python And Mysql Download Now Read Online

Author by : Vivian Siahaan
Languange Used : id
Release Date : 2019-02-19
Publisher by : SPARTA Publishing






The Ultimate Guide To Professional Database Programming With Python And Postgresql


The Ultimate Guide To Professional Database Programming With Python And Postgresql Download Now Read Online

Author by : Vivian Siahaan
Languange Used : id
Release Date : 2019-01-15
Publisher by : SPARTA Publishing






Learning Python


Learning Python Download Now Read Online

Author by : Mark Lutz
Languange Used : en
Release Date : 2013-06-12
Publisher by : "O'Reilly Media, Inc."






The Hitchhiker S Guide To Python


The Hitchhiker S Guide To Python Download Now Read Online

Author by : Kenneth Reitz
Languange Used : en
Release Date : 2016-08-30
Publisher by : "O'Reilly Media, Inc."






A Quick Way To Learn Python The Step By Step Guide To Learn Pyqt And Database Applications


A Quick Way To Learn Python The Step By Step Guide To Learn Pyqt And Database Applications Download Now Read Online

Author by : Vivian Siahaan
Languange Used : en
Release Date : 2019-11-30
Publisher by : SPARTA PUBLISHING






Leave a Reply

Your email address will not be published. Required fields are marked *