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

Similar Free eBook

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






The Fast Tutorial To Learn Database Programming Using Python Gui With Access And Sql Server


The Fast Tutorial To Learn Database Programming Using Python Gui With Access And Sql Server Download Now Read Online

Author by : Vivian Siahaan
Languange Used : en
Release Date : 2020-01-15
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






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 Absolute Beginner S Guide To Learn Python Gui With Mysql And Sql Server Databases


The Absolute Beginner S Guide To Learn Python Gui With Mysql And Sql Server Databases Download Now Read Online

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






Python For Data Analysis


Python For Data Analysis Download Now Read Online

Author by : Wes McKinney
Languange Used : en
Release Date : 2013
Publisher by : "O'Reilly Media, Inc."






The Best Guide To Database Programming With Java Gui Postgresql And Sql Server


The Best Guide To Database Programming With Java Gui Postgresql And Sql Server Download Now Read Online

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






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






A Pragmatic Approach To Database Programming With Jdbc And Mysql


A Pragmatic Approach To Database Programming With Jdbc And Mysql Download Now Read Online

Author by : Vivian Siahaan
Languange Used : id
Release Date : 2019-03-04
Publisher by : SPARTA Publishing






Leave a Reply

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