OpenCV-Python with MySQL for Absolute Beginners: A Hands-On,…

OpenCV-Python with MySQL for Absolute Beginners: A Hands-On,...

In the first chapter, you will learn to use several widgets in PyQt5: Display a welcome message; Use the Radio Button widget; Grouping radio buttons; Displays options in the form of a check box; and Display two groups of check boxes.

In chapter two, you will learn to use the following topics: Using Signal / Slot Editor; 

In chapter three, you will learn Basic MySQL statements including how to implement querying data, sorting data, filtering data, joining tables, grouping data, subquerying data, dan setting operators. 

Chapter four will help you get started with MySQL Python connector. You will learn about the MySQL Python connector’s features and how to install MySQL Connector/Python in your local system. Chapter five will help you understand the basics of MySQL data manipulation.

In chapter six, you will create dan configure 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 seven, 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 eight, 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 Vicbtim 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

Opencv Python With Mysql For Absolute Beginners


Opencv Python With Mysql For Absolute Beginners Download Now Read Online

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






Learning Pyqt5 With Mariadb For Absolute Beginners


Learning Pyqt5 With Mariadb For Absolute Beginners Download Now Read Online

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






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 : id
Release Date : 2020-01-16
Publisher by : SPARTA PUBLISHING






Python Gui With Sql Server For Absolute Beginners


Python Gui With Sql Server For Absolute Beginners Download Now Read Online

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






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


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

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






Hands On Learning Using Python For Programmers The Definitive Guide To Learn Pyqt And Database Applications


Hands On Learning Using Python For Programmers The Definitive Guide To Learn Pyqt And Database Applications Download Now Read Online

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






A Guide To Python Gui Programming With Mysql


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

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






Fluent Opencv Python Gui With Sql Server


Fluent Opencv Python Gui With Sql Server Download Now Read Online

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






The Beginner S Guide To Learn Python Gui With Mysql And Sqlite


The Beginner S Guide To Learn Python Gui With Mysql And Sqlite Download Now Read Online

Author by : Vivian Siahaan
Languange Used : id
Release Date : 2020-01-14
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 *