Think PyQt: A Smarter Way to Explore MariaDB and SQLite Driven Programming

0/5 ( ratings)

This book explains relational theory in practice, and demonstrates through two projects how you can apply it to your use of MariaDB and SQLite databases. This book covers the important requirements of teaching databases with a practical and progressive perspective. This book offers the straightforward, practical answers you need to help you do your job. This hands-on tutorial/reference/guide to MariaDB and SQLite is not only perfect for students and beginners, but it also works for experienced developers who aren't getting the most from both databases. In designing a GUI and as an IDE, you will make use Qt Designer.

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 , 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 , suspect_id , feature1, feature2, feature3, feature4, feature5, and feature6. The six fields will have a VARCHAR 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 , province, city, address, telephone, and photo. The Investigator table has eight columns: investigator_id , 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 , victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven columns: case_file_id , suspect_id , police_id , investigator_id , victim_id , status, and description.

Format: Kindle Edition

Publisher: SPARTA PUBLISHING

Release: November 24, 2019

Think PyQt: A Smarter Way to Explore MariaDB and SQLite Driven Programming

Rismon Hasiholan Sianipar

0/5 ( ratings)

Read Download

Format: Kindle Edition

Publisher: SPARTA PUBLISHING

Release: November 24, 2019

Subscribe to Read | $0.00

Popular Genres

Subscribe to Read | $0.00

Think PyQt: A Smarter Way to Explore MariaDB and SQLite Driven Programming

Think PyQt: A Smarter Way to Explore MariaDB and SQLite Driven Programming

Think PyQt: A Smarter Way to Explore MariaDB and SQLite Driven Programming

More books from Rismon Hasiholan Sianipar

HOUSE PRICE: ANALYSIS AND PREDICTION USING MACHINE LEARNING WITH PYTHON

TIME-SERIES WEATHER FORECASTING AND PREDICTION USING MACHINE LEARNING WITH TKINTER

Dasar Analisis Dan Perancangan Pemrograman Berorientasi Objek Menggunakan Java

Building Three Desktop Applications with SQLite and Java GUI

Building Three Java GUI Applications Using MySQL, MariaDB, and PostgreSQL

Python GUI with SQL Server for Absolute Beginners: Building Responsive, Powerful Cross-platform, and Database-Driven Applications with PyQt

LEARNING PyQt5: A Step by Step Tutorial to Develop MySQL-Based Applications

Learn Java in One Week: The Crash Course to Develop Database-Driven Projects

LEARNING SQL SERVER: A self-study to easy implement database-driven Java GUI applications

OpenCV-Python with MariaDB for Absolute Beginners: A Hands-On, Practical Database-Driven Applications

POSTGRESQL FOR PYTHON GUI: A PROGRESSIVE TUTORIAL TO DEVELOP DATABASE PROJECT

Learn SQLite with Python: Building Database-Driven Desktop Projects

ONLINE RETAIL CLUSTERING AND PREDICTION USING MACHINE LEARNING WITH PYTHON GUI

OPINION MINING AND PREDICTION USING MACHINE LEARNING AND DEEP LEARNING WITH PYTHON GUI

Learning PyQt5 with MariaDB for Absolute Beginners: A Hands-On, Practical Database Programming

Java Programming For Developers: The Definitive Guide to Learn JDBC And Database Applications

JAVA GUI WITH POSTGRESQL: A Practical Approach to Build Database Project for Students and Programmers

Java In Practice: JDBC And Database Applications

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

MS Access And SQL Server Crash Course: A Step by Step, Project-Based Introduction to Java GUI Programming