Step By Step Database Programming using Python GUI & MySQL

Step By Step Database Programming using Python GUI & MySQL
Author :
Publisher : TURIDA Publisher
Total Pages : 384
Release :
ISBN-10 :
ISBN-13 :
Rating : 4/5 ( Downloads)

Book Synopsis Step By Step Database Programming using Python GUI & MySQL by : Hamzan Wadi

Download or read book Step By Step Database Programming using Python GUI & MySQL written by Hamzan Wadi and published by TURIDA Publisher. This book was released on with total page 384 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book provides a practical explanation of database programming using Python GUI & MySQL. The discussion in this book is presented in step by step so that it will help readers understand each material and also will make it easier for the readers to follow all of the instructions. This book is very suitable for students, programmers, and anyone who want to learn database programming using Python GUI & MySQL from scratch. This book is divided into two parts: The first part of this book will discuss about the fundamentals of database programming using Python GUI & MySQL. This part will discuss in detail about how to setup your working environment and how to understand GUI programming using Python. This part will also discuss in detail about how to start your database programming using Python GUI & MySQL. This part will discuss in detail about the basic of database programming using Python GUI & MySQL. The second part of this book will discuss about how to build database application using Python GUI & MySQL. This part will discuss in detail about how to build Multiple Document Interface (MDI) database application through real project-based example. This part will discuss in detail about how to design and create database for Library Management System application, and how to create all forms for the application. The final objective of this book is that the readers are able to create real database application using Python GUI & MySQL. Here are the materials that you will learn in this book. PART I: THE FUNDAMENTAL OF DATABASE PROGRAMMING USING PYTHON GUI & MySQL CHAPTER 1: The discussion in this chapter will guide you in preparing what software are needed to start your database programming using Python GUI. This chapter will guide you to install all software including Python, MySQL, and Qt Designer. In addition, this chapter also will discuss about how to understand and use Qt Designer for user interface design, and how to create a GUI application using Python and Qt Designer. CHAPTER 2: The discussion in this chapter will guide you to start your database programming using Python GUI & MySQL. This chapter will discuss in detail about the basic of database programming using Python GUI & MySQL. The discussion in this chapter will talk about how to create and drop database, how to create and drop table, how to insert data into table, how to display data from table, how to update data in table, and how to delete data in table. All discussions in this chapter will give you deep understanding of database programming using Python GUI & MySQL. PART II: BUILDING DATABASE APPLICATION USING PYTHON GUI & MySQL, CASE STUDY: LIBRARY MANAGEMENT SYSTEM APPLICATION CHAPTER 3: The discussion in this chapter will guide you to design and create database for library management system application. This is the first step that must be taken to create database application using Python GUI & MySQL. This chapter will discuss in detail about how to design the Entity Relationship Diagram (ERD) for library management system application. The discussion in this chapter will also talk about how to create database and its tables based on the ERD design using MySQL server. CHAPTER 4: The discussion in this chapter will guide you to create main form and login form for the application. This chapter will discuss in detail about how to create these two forms. These forms are the first two forms that we will create in building library management system application. This chapter will also discuss about how to run the application. CHAPTER 5: The discussion in this chapter will guide you to create user accounts form and members form for Library Management System application. This chapter will discuss in detail about how to create these two forms. This chapter will also discuss about how to add these two forms as MDI sub windows of the main form. And the final discussion of this chapter will guide you to use the forms to manage user accounts and members data of Library Management System application. CHAPTER 6: The discussion in this chapter will guide you to create authors form, genres form, and books form for Library Management System application. This chapter will discuss in detail about how to create these three forms. This chapter will also discuss about how to add books form as MDI sub window of the main form. And the final discussion of this chapter will guide you to use the forms to manage authors, genres, and books data in Library Management System application. CHAPTER 7: The discussion in this chapter will guide you to create member search form, book search form, and loan transaction form for Library Management System application. This chapter will discuss in detail about how to create these three forms. This chapter will also discuss about how to add loan transaction form as MDI sub window of the main form. And the final discussion of this chapter will guide you to use the forms to manage loan transactions in Library Management System application. CHAPTER 8: The discussion in this chapter will guide you to create members statistic form, books statistic form, and loan statistic form for Library Management System application. This chapter will discuss in detail about how to create these three forms. This chapter will also discuss about how to add all of the forms as MDI sub windows of the main form. And the final discussion of this chapter will guide you to use all of the forms to display the statistics in the library.

Step By Step Database Programming using Python GUI & MySQL Related Books

Step By Step Database Programming using Python GUI & MySQL
Language: en
Pages: 384
Authors: Hamzan Wadi
Categories: Computers
Type: BOOK - Published: - Publisher: TURIDA Publisher

GET EBOOK

This book provides a practical explanation of database programming using Python GUI & MySQL. The discussion in this book is presented in step by step so that it
A Step By Step To Database Programming Using Python GUI and MariaDB
Language: en
Pages: 533
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2020-01-06 - Publisher: SPARTA PUBLISHING

GET EBOOK

In this book, you will create two desktop applications using Python GUI and MariaDB. This book is mariadb-based python programming Intentionally designed for va
Step By Step Java GUI With JDBC & MySQL : Practical approach to build database desktop application with project based examples
Language: en
Pages: 340
Authors: Hamzan Wadi
Categories: Computers
Type: BOOK - Published: - Publisher: TR Publisher

GET EBOOK

This book comes as an answer for students, lecturers, or the general public who want to learn Java GUI programming starting from scratch. This book is suitable
Python GUI with MySQL: A Step By Step Guide to Database Programming
Language: en
Pages: 475
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2019-08-13 - Publisher: SPARTA PUBLISHING

GET EBOOK

In this book, you will learn how to build from scratch a MySQL database management system using PyQt. In designing a GUI, you will make use of the Qt Designer t
Step By Step Database Programming with JDBC and PostgreSQL
Language: en
Pages: 221
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2019-04-08 - Publisher: SPARTA Publishing

GET EBOOK

PostgreSQL was designed to run on UNIX-like platforms. However, PostgreSQL was then also designed to be portable so that it could run on various platforms such