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


Here is Download Link

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


Ms Access And Sql Server Crash Course Download Now Read Online

Author by : Vivian Siahaan
Languange Used : en
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 : en
Release Date : 2019-10-12
Publisher by : SPARTA PUBLISHING






Python Gui With Mysql A Step By Step Guide To Database Programming


Python Gui With Mysql A Step By Step Guide To Database Programming Download Now Read Online

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






Learn Python In One Week


Learn Python In One Week Download Now Read Online

Author by : Vivian Siahaan
Languange Used : en
Release Date : 2019-11-17
Publisher by : BALIGE Publishing






Sql For Dummies


Sql For Dummies Download Now Read Online

Author by : Allen G. Taylor
Languange Used : en
Release Date : 2011-02-23
Publisher by : John Wiley & Sons






Postgresql 11 Administration Cookbook


Postgresql 11 Administration Cookbook Download Now Read Online

Author by : Simon Riggs
Languange Used : en
Release Date : 2019-05-03
Publisher by : Packt Publishing Ltd






Php And Mysql Web Development


Php And Mysql Web Development Download Now Read Online

Author by : Luke Welling
Languange Used : en
Release Date : 2008-10-01
Publisher by : Pearson Education






Practical Database Programming With Java


Practical Database Programming With Java Download Now Read Online

Author by : Ying Bai
Languange Used : en
Release Date : 2011-09-09
Publisher by : John Wiley & Sons






Python Gui Programming Cookbook


Python Gui Programming Cookbook Download Now Read Online

Author by : Burkhard A. Meier
Languange Used : en
Release Date : 2015-12-01
Publisher by : Packt Publishing Ltd






Leave a Reply

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