A PROGRESSIVE TUTORIAL TO DATABASE PROGRAMMING WITH PYTHON GUI AND POSTGRESQL

A PROGRESSIVE TUTORIAL TO DATABASE PROGRAMMING WITH PYTHON GUI AND POSTGRESQL
Author :
Publisher : SPARTA PUBLISHING
Total Pages : 537
Release :
ISBN-10 :
ISBN-13 :
Rating : 4/5 ( Downloads)

Book Synopsis A PROGRESSIVE TUTORIAL TO DATABASE PROGRAMMING WITH PYTHON GUI AND POSTGRESQL by : Vivian Siahaan

Download or read book A PROGRESSIVE TUTORIAL TO DATABASE PROGRAMMING WITH PYTHON GUI AND POSTGRESQL written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2020-01-03 with total page 537 pages. Available in PDF, EPUB and Kindle. Book excerpt: In this book, you will create two desktop applications using Python GUI and PostgreSQL. This book is a Python/PostgreSQL version of the Python/MySQL book which was written by the author. What underlies the writing of this book is the growing popularity of the PostgreSQL database server lately and more and more programmers migrating from MySQL to PostgreSQL. In this book, you will learn to build a school database project, step by step. A number of widgets from PyQt will be used for the user interface. In the first and second chapter, you will get introduction of postgresql. And then, you will learn querying data from the postgresql using Python including establishing a database connection, creating a statement object, executing the query, processing the resultset object, querying data using a statement that returns multiple rows, querying data using a statement that has parameters, inserting data into a table using Python, updating data in postgresql database using Python, calling postgresql stored function using Python, deleting data from a postgresql table using Python, and postgresql Python transaction. In the fourth chapter, you will study: Creating the initial three table in the School database project: Teacher table, Class table, and Subject table; Creating database configuration files; Creating a Python GUI for viewing and navigating the contents of each table. Creating a Python GUI for inserting and editing tables; and Creating a Python GUI to merge and query the three tables. In chapter five, you will learn: Creating the main form to connect all forms; Creating a project that will add three more tables to the school database: the Student table, the Parent table, and the Tuition table; Creating a Python GUI to view and navigate the contents of each table; Creating a Python GUI for editing, inserting, and deleting records in each table; Create a Python GUI to merge and query the three tables and all six tables. In chapter six, 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 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 nine, 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.

A PROGRESSIVE TUTORIAL TO DATABASE PROGRAMMING WITH PYTHON GUI AND POSTGRESQL Related Books

A PROGRESSIVE TUTORIAL TO DATABASE PROGRAMMING WITH PYTHON GUI AND POSTGRESQL
Language: en
Pages: 537
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2020-01-03 - Publisher: SPARTA PUBLISHING

GET EBOOK

In this book, you will create two desktop applications using Python GUI and PostgreSQL. This book is a Python/PostgreSQL version of the Python/MySQL book which
The Quick Tutorial to Learn Database Programming Using Python GUI with MariaDB and PostgreSQL
Language: en
Pages: 534
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2020-01-15 - Publisher: SPARTA PUBLISHING

GET EBOOK

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 confid
POSTGRESQL FOR PYTHON GUI
Language: en
Pages: 363
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2019-08-15 - Publisher: SPARTA PUBLISHING

GET EBOOK

This book is a Python/PostgreSQL version of the Python/MySQL book which was written by the author. What underlies the writing of this book is the growing popula
The Absolute Beginner’s Guide to Learn Database Programming Using Python GUI with PostgreSQL and SQL Server
Language: en
Pages: 522
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2020-01-16 - Publisher: SPARTA PUBLISHING

GET EBOOK

This book is a comprehensive guide to Python as one of the fastest-growing computer languages including Web and Internet applications. This clear and concise in
MariaDB And PostgreSQL Crash Course
Language: en
Pages: 534
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2019-11-13 - Publisher: SPARTA PUBLISHING

GET EBOOK

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 confid