A Walkthrough, Database-Driven Programming with Python GUI for Pragmatic Programmers

A Walkthrough, Database-Driven Programming with Python GUI for Pragmatic Programmers
Author :
Publisher : BALIGE Publishing
Total Pages : 542
Release :
ISBN-10 :
ISBN-13 :
Rating : 4/5 ( Downloads)

Book Synopsis A Walkthrough, Database-Driven Programming with Python GUI for Pragmatic Programmers by : Vivian Siahaan

Download or read book A Walkthrough, Database-Driven Programming with Python GUI for Pragmatic Programmers written by Vivian Siahaan and published by BALIGE Publishing. This book was released on 2019-11-15 with total page 542 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book covers how to implement SQLite and SQL Server driven programming with Python GUI. Deliberately designed for various levels of programming skill, this book is suitable for students, engineers, and even researchers in various disciplines. There is no need for advanced programming experience, and school-level programming skills are needed. 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; Copy and place text from one Line Edit widget to another; Convert data types and make a simple calculator; Use the Spin Box widget; Use scrollbars and sliders; Using the Widget List; Select a number of list items from one Widget List and display them on another Widget List widget; Add items to the Widget List; Perform operations on the Widget List; Use the Combo Box widget; Displays data selected by the user from the Calendar Widget; Creating a hotel reservation application; and Display tabular data using Table Widgets. In chapter three, 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 chapter four, 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 chapter five, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables. 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 VARBINARY(MAX) data type. 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 the last chapter, 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 Walkthrough, Database-Driven Programming with Python GUI for Pragmatic Programmers Related Books

A Walkthrough, Database-Driven Programming with Python GUI for Pragmatic Programmers
Language: en
Pages: 542
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2019-11-15 - Publisher: BALIGE Publishing

DOWNLOAD EBOOK

This book covers how to implement SQLite and SQL Server driven programming with Python GUI. Deliberately designed for various levels of programming skill, this
A Walkthrough, Database-Driven Programming with Java GUI for Pragmatic Programmers
Language: en
Pages: 529
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2019-11-15 - Publisher: BALIGE Publishing

DOWNLOAD EBOOK

This covers how to implement SQLite and SQL Server driven Java GUI programming. The lessons in this book are a highly organized and well-indexed set of tutorial
Access Database for Pragmatic Programmers: A Step by Step Guide to Create Database-Driven Application Using Python
Language: en
Pages: 371
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2019-10-11 - Publisher: SPARTA PUBLISHER

DOWNLOAD EBOOK

This book covers microsoft acces-based GUI programming using pyqt. Intentionally designed for various levels of interest and ability of learners, this book is s
Programming Ruby
Language: en
Pages: 830
Authors: David Thomas
Categories: Computers
Type: BOOK - Published: 2004 - Publisher:

DOWNLOAD EBOOK

A tutorial and reference to the object-oriented programming language for beginning to experienced programmers, updated for version 1.8, describes the language's
A Pragmatic Approach to Database Programming with JDBC and MySQL
Language: en
Pages: 439
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2019-03-04 - Publisher: SPARTA Publishing

DOWNLOAD EBOOK

You will learn Java/MySQL fast, easy and fun. This book provides you with a complete MySQL guidance presented in an easy-to-follow manner. Each chapter has prac