Mariadb And Postgresql Crash Course: A Step By Step, Project…

Mariadb And Postgresql Crash Course: A Step By Step, Project...

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

Mariadb And Postgresql Crash Course


Mariadb And Postgresql Crash Course Download Now Read Online

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






Ms Access And Sql Server Crash Course A Step By Step Project Based Introduction To Java Gui Programming


Ms Access And Sql Server Crash Course A Step By Step Project Based Introduction To Java Gui Programming Download Now Read Online

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






Ms Access And Sql Server Crash Course


Ms Access And Sql Server Crash Course Download Now Read Online

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






Access Database Crash Course


Access Database Crash Course Download Now Read Online

Author by : Vivian Siahaan
Languange Used : id
Release Date : 2019-10-12
Publisher by : SPARTA PUBLISHING






Postgresql For Python Gui


Postgresql For Python Gui Download Now Read Online

Author by : Vivian Siahaan
Languange Used : id
Release Date : 2019-08-15
Publisher by : SPARTA PUBLISHING






Java Gui With Postgresql A Practical Approach To Build Database Project For Students And Programmers


Java Gui With Postgresql A Practical Approach To Build Database Project For Students And Programmers Download Now Read Online

Author by : Vivian Siahaan
Languange Used : id
Release Date : 2019-08-21
Publisher by : SPARTA PUBLISHING






The Best Way To Learn Java Gui With Mysql Mariadb And Postgresql


The Best Way To Learn Java Gui With Mysql Mariadb And Postgresql Download Now Read Online

Author by : Vivian Siahaan
Languange Used : id
Release Date : 2020-01-10
Publisher by : SPARTA PUBLISHING






Building Three Java Gui Applications Using Mysql Mariadb And Postgresql


Building Three Java Gui Applications Using Mysql Mariadb And Postgresql Download Now Read Online

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






Mariadb With Python Gui


Mariadb With Python Gui Download Now Read Online

Author by : Vivian Siahaan
Languange Used : id
Release Date : 2019-08-17
Publisher by : SPARTA PUBLISHING






Learning Pyqt5


Learning Pyqt5 Download Now Read Online

Author by : Vivian Siahaan
Languange Used : id
Release Date : 2019-09-07
Publisher by : SPARTA PUBLISHING






Leave a Reply

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