Building Two Desktop Applications Using Python Gui And Mysql

Download Building Two Desktop Applications Using Python Gui And Mysql full books in PDF, epub, and Kindle. Read online Building Two Desktop Applications Using Python Gui And Mysql ebook anywhere anytime directly on your device. Fast Download speed and no annoying ads. We cannot guarantee that every ebooks is available!

Building Two Desktop Applications Using Python GUI and MySQL

Author : Vivian Siahaan
Publisher : SPARTA PUBLISHING
ISBN 13 :
Total Pages : 541 pages
Book Rating : 4./5 ( download)

DOWNLOAD NOW!

Book Synopsis Building Two Desktop Applications Using Python GUI and MySQL by : Vivian Siahaan

Download or read book Building Two Desktop Applications Using Python GUI and MySQL written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2019-11-07 with total page 541 pages. Available in PDF, EPUB and Kindle. Book excerpt: In this book, you will create two desktop applications using Python GUI and MySQL. 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 tool. Gradually and step by step, you will be taught how to use MySQL in Python. In the first three chapters, 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. Aside from learning basic SQL statements, you will also learn step by step how to develop stored procedures in MySQL. First, we introduce you to the stored procedure concept and discuss when you should use it. Then, we show you how to use the basic elements of the procedure code such as create procedure statement, if-else, case, loop, stored procedure’s parameters. In the fourth chapter, you will learn: How PyQt and Qt Designer are used to create Python GUIs; How to create a basic Python GUI that utilizes a Line Edit and a Push Button. In the fifth 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 six, 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 seven, you will create new database dan configure it. 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 eight, 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 nine, 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 ten, 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.

BUILDING TWO DESKTOP APPLICATIONS USING PYTHON GUI AND POSTGRESQL

Author : Vivian Siahaan
Publisher : SPARTA PUBLISHING
ISBN 13 :
Total Pages : 537 pages
Book Rating : 4./5 ( download)

DOWNLOAD NOW!

Book Synopsis BUILDING TWO DESKTOP APPLICATIONS USING PYTHON GUI AND POSTGRESQL by : Vivian Siahaan

Download or read book BUILDING TWO DESKTOP APPLICATIONS USING PYTHON GUI AND POSTGRESQL written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2019-11-07 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 Guide to Python GUI Programming with MySQL

Author : Vivian Siahaan
Publisher : SPARTA PUBLISHING
ISBN 13 :
Total Pages : 541 pages
Book Rating : 4./5 ( download)

DOWNLOAD NOW!

Book Synopsis A Guide to Python GUI Programming with MySQL by : Vivian Siahaan

Download or read book A Guide to Python GUI Programming with MySQL written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2020-01-14 with total page 541 pages. Available in PDF, EPUB and Kindle. Book excerpt: In this book, you will create two desktop applications using Python GUI and MySQL. 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 tool. Gradually and step by step, you will be taught how to use MySQL in Python. In the first three chapters, 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. Aside from learning basic SQL statements, you will also learn step by step how to develop stored procedures in MySQL. First, we introduce you to the stored procedure concept and discuss when you should use it. Then, we show you how to use the basic elements of the procedure code such as create procedure statement, if-else, case, loop, stored procedure’s parameters. In the fourth chapter, you will learn: How PyQt and Qt Designer are used to create Python GUIs; How to create a basic Python GUI that utilizes a Line Edit and a Push Button. In the fifth 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 six, 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 seven, you will create new database dan configure it. 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 eight, 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 nine, 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 ten, 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.

A PROGRESSIVE TUTORIAL TO DATABASE PROGRAMMING WITH PYTHON GUI AND POSTGRESQL

Author : Vivian Siahaan
Publisher : SPARTA PUBLISHING
ISBN 13 :
Total Pages : 537 pages
Book Rating : 4./5 ( download)

DOWNLOAD NOW!

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.

Step By Step Database Programming using Python GUI & MySQL

Author : Hamzan Wadi
Publisher : TURIDA Publisher
ISBN 13 :
Total Pages : 384 pages
Book Rating : 4./5 ( download)

DOWNLOAD NOW!

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 Java GUI With JDBC & MySQL : Practical approach to build database desktop application with project based examples

Author : Hamzan Wadi
Publisher : TR Publisher
ISBN 13 :
Total Pages : 340 pages
Book Rating : 4./5 ( download)

DOWNLOAD NOW!

Book Synopsis Step By Step Java GUI With JDBC & MySQL : Practical approach to build database desktop application with project based examples by : Hamzan Wadi

Download or read book Step By Step Java GUI With JDBC & MySQL : Practical approach to build database desktop application with project based examples written by Hamzan Wadi and published by TR Publisher. This book was released on with total page 340 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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 for beginner learners who want to learn Java GUI programming from the basic to the database level. This book is also present for JAVA learners who want to increase their level of making GUI-based database applications for small, medium, or corporate businesses level. The discussion in this book is not wordy and not theoretical. Each discussion in this book is presented in a concise and clear brief, and directly to the example that implements the discussion. Beginner learners who want to learn through this book should not be afraid of losing understanding of the programming concepts, because this book in detail discusses the concepts of Java programming from the basic to the advanced level. By applying the concept of learning by doing, this book will guide you step by step to start Java GUI programming from the basics until you are able to create database applications using JDBC and MySQL. Here are the material that you will learn in this book. CHAPTER 1 : This chapter will give you brief and clear introduction about how to create desktop application using Java GUI starting from how to setup your environments, create your first project, understand various control for your form, and understand how to interact with your form using event handling. CHAPTER 2 : This chapter will discuss clearly about the concept and the implementatiton of data types and variables in Java GUI. CHAPTER 3 : This chapter will discuss in detail about how to make decisions or deal with a condition in the program. This chapter is the first step to deeper understanding of logics in programming. This chapter specifically discusses relational operators and logical operators, if statements, if-else statements, and switch-case statements, and how to implement all of these conditional statements using Java GUI. CHAPTER 4 : This chapter will discuss in detail the looping statements in Java including for statement, while statement, do-while statement, break statement, and continue statement. All of these looping statements will be implemented using Java GUI. CHAPTER 5 : This chapter will discuss how to use methods to group codes based on their funcitonality. This discussion will also be the first step for programmers to learn how to create efficient program code. This chapter will discuss in detail the basics of methods, methods with return values, how to pass parameters to methods, how to overload your methods, and how to make recursive methods. CHAPTER 6 : This chapter will discuss in detail how to create and use arrays, read and write file operations, and how to display data stored in arrays or files in graphical form. CHAPTER 7 : This chapter will discuss in detail the basics of MySQL, how to access databases using JDBC and MySQL, and how to perform CRUD operations using JDBC and MySQL. CHAPTER 8 : In this chapter we will discuss more about Java GUI programming. This chapter will discuss in detail about how to make a program that consists of multi forms, how to create MDI application, and how to create report using iReport with data stored in a database.

Python GUI with SQL Server for Absolute Beginners

Author : Vivian Siahaan
Publisher : SPARTA PUBLISHING
ISBN 13 :
Total Pages : 373 pages
Book Rating : 4./5 ( download)

DOWNLOAD NOW!

Book Synopsis Python GUI with SQL Server for Absolute Beginners by : Vivian Siahaan

Download or read book Python GUI with SQL Server for Absolute Beginners written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2019-09-20 with total page 373 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book is SQL Server-based python programming. Microsoft SQL Server is robust relational database management system used by so many organizations of various sizes including top fortune 100 companies. SQL Server is a relational database management system (RDBMS) developed and marketed by Microsoft. As a database server, the primary function of the SQL Server is to store and retrieve data used by other applications. 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 third chapter, 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 fourth chapter, 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 the last chapter, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables.

A Practical Guide to Decision Support System With Analytic Hierarchy Process Method Using Python GUI & MySQL, Case Study: Determining Scholarship Recipients

Download A Practical Guide to Decision Support System With Analytic Hierarchy Process Method Using Python GUI & MySQL, Case Study: Determining Scholarship Recipients PDF Online Free

Author : Hamzan Wadi
Publisher : Turida Publisher
ISBN 13 :
Total Pages : 246 pages
Book Rating : 4./5 ( download)

DOWNLOAD NOW!

Book Synopsis A Practical Guide to Decision Support System With Analytic Hierarchy Process Method Using Python GUI & MySQL, Case Study: Determining Scholarship Recipients by : Hamzan Wadi

Download or read book A Practical Guide to Decision Support System With Analytic Hierarchy Process Method Using Python GUI & MySQL, Case Study: Determining Scholarship Recipients written by Hamzan Wadi and published by Turida Publisher. This book was released on 2023-04-26 with total page 246 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book provides a practical explanation of the Analytic Hierarchy Process (AHP) method and its implementation in a decision support system to determine the scholarship recipients in a university. The discussion in this book is presented step-by-step, gradually, so that it will help readers understand every concept and stage of the AHP method and its implementation in decision support systems. This book is suitable for students, scholars, and researchers who want to implement the AHP method to build decision support systems using Python GUI and MySQL. The discussion in this book will provide readers with an understanding of the AHP method and how it works. Readers will be guided through each step of determining priority order using the AHP method through a case study accompanied by mathematical calculations. In addition, readers will also be guided step-by-step in implementing the AHP method in a decision support system to determine the scholarship recipients using Python GUI and MySQL. Readers will be guided step-by-step in designing a decision support system and realizing each design made using Python GUI and MySQL. The ultimate goal of this book is to enable readers to build a decision support system application independently by applying the AHP method to determine the scholarship recipients in a college using Python GUI and MySQL.

Artificial Intelligence of Things

Author : Rama Krishna Challa
Publisher : Springer Nature
ISBN 13 : 3031487745
Total Pages : 402 pages
Book Rating : 4.0/5 (314 download)

DOWNLOAD NOW!

Book Synopsis Artificial Intelligence of Things by : Rama Krishna Challa

Download or read book Artificial Intelligence of Things written by Rama Krishna Challa and published by Springer Nature. This book was released on 2023-12-02 with total page 402 pages. Available in PDF, EPUB and Kindle. Book excerpt: These two volumes constitute the revised selected papers of First International Conference, ICAIoT 2023, held in Chandigarh, India, during March 30–31, 2023. The 47 full papers and the 10 short papers included in this volume were carefully reviewed and selected from 401 submissions. The two books focus on research issues, opportunities and challenges of AI and IoT applications. They present the most recent innovations, trends, and concerns as well as practical challenges encountered and solutions adopted in the fields of AI algorithms implementation in IoT Systems

VISUAL C# .NET WITH MYSQL

Author : Vivian Siahaan
Publisher : BALIGE PUBLISHING
ISBN 13 :
Total Pages : 348 pages
Book Rating : 4./5 ( download)

DOWNLOAD NOW!

Book Synopsis VISUAL C# .NET WITH MYSQL by : Vivian Siahaan

Download or read book VISUAL C# .NET WITH MYSQL written by Vivian Siahaan and published by BALIGE PUBLISHING. This book was released on 2020-09-13 with total page 348 pages. Available in PDF, EPUB and Kindle. Book excerpt: In chapter one, you will learn to know the properties and events of each control in a Windows Visual C# application. You need to learn and know in order to be more familiar when applying them to some applications in this book. In chapter two, you will go through step by step to build a SALES database using MySQL. You will build each table and add associated data fields (along with the necessary keys and indexes). The first field in the Client table is ClientID. Enter the clien ID in the Name Field and select AutoNumber in the Data Type. You define primary key and other indexes which are useful for quick searching. ClientID is a primary field. You will define FamilyName as an index. You then will create Ordering table with three fields: OrderID, ClientID, and OrderDate. You then will create Purchase table with three fields: OrderID, ProductID, and Quantity. And you will create Product table with four fields: ProductID, Description, Price, and QtySold. Before designing Visual C# interface, you will build the relationships between four tables. The interface will be used to enter new orders into the database. The order form will be used to enter the following information into the database: order ID, order date, client ID, client’s first name and family name, client’s address, product information ordered. The form will have the ability to add new orders, find clients, add new clients. The completed order invoice will be provided in a printed report. In chapter three, you will build a database management system where you can store information about valuables in your warehouse. The table will have seven fields: Item (description of the item), Location (where the item was placed), Shop (where the item was purchased), DatePurchased (when the item was purchased), Cost (how much the item cost), SerialNumber (serial number of the item), PhotoFile (path of the photo file of the item), and Fragile (indicates whether a particular item is fragile or not). The development of this Warehouse Inventory Project will be performed, as usual, in a step-by-step manner. You will first create the database. Furthermore, the interface will be built so that the user can view, edit, add, or add data records from the database. Finally, you add code to create a printable list of information from the database. In chapter four, you will build an application that can be used to track daily high and low pollutant PM2.5 and air quality level. The steps that need to be taken in building Siantar Air Quality Index (SAQI) database project are: Build and test a Visual C# interface; Create an empty database using code; and Report database. The designed interface will allow the user to enter max pollutant, min pollutant, and air quality for any date that the user chooses in a particular year. This information will be stored in a database. Graphical result of the data will be provided, along with summary information relating to the maximum value, minimum value, and mean value. You will use a tab control as the main component of the interface. The control has three tabs: one for viewing and editing data, one for viewing graph of pollutant data, and another for viewing graph of air quality data. Each tab on this control operates like a Visual C# control panel. In chapter five, you will perform the steps necessary to build a MySQL book inventory database that contains 4 tables. You will build each table and add the associated fields as needed. You will have four tables in the database and define the relationship between the primary key and foreign key. You will associate AuthorID (foreign key) field in the Title_Author table with AuthorID (primary key) in the Author table. Then, you want to associate the ISBN (foreign key) field in Title_Author table with ISBN (primary key) in the Title table.

Python Made Simple

Author : Beri Rydhm
Publisher : BPB Publications
ISBN 13 : 938932808X
Total Pages : 459 pages
Book Rating : 4.3/5 (893 download)

DOWNLOAD NOW!

Book Synopsis Python Made Simple by : Beri Rydhm

Download or read book Python Made Simple written by Beri Rydhm and published by BPB Publications. This book was released on 2019-09-20 with total page 459 pages. Available in PDF, EPUB and Kindle. Book excerpt: Take tiny steps to enter the big world of data science through this interesting guideKey features Acquire basic concepts related to python programming Understand the core functionalities of Python Programming Provide the information regarding idle IDE Computational Problem solving in Python Object oriented concepts in Python Database connectivity with Python Description In the last few years, python gained popularity and became the first choice of the students, teachers as well as professionals. It is being used in different fields such as education, software development, website development and also in various advanced research. In the field of education it allows students to learn the programming language in an easier and efficient manner. In the information technology field it can be used as a language for creating softwares as well as for web developments. It can be integrated with different platforms like Django. In research, Python programming can be used in simulation or it can be used for machine learning techniques.The primary goal of this text is to create a pedagogically sound and accessible textbook that emphasises on core concepts of Python programming. The book contains lots of practical examples to show the working of a particular code construct. The book can be very helpful in order to learn the basic and advance concepts of python programming.In the beginning of the book the focus is on the basic concepts related to core python programming starting from the installation phase of python interpreter to building the concepts for the reader towards python programming. Then the book moves towards the concept of different statements and programming conditions that python programming can handle in an easier manner. It then moves to the concepts related to object oriented programming and at last the reader will get to know about the database connectivity with the python program.What will you learn You can learn the core concept related to python programming You will get to learn how to program in python You can learn how Python programming helps to solve computational problems By reading this book you can learn how to work with python You will get familiarity with the python programming concepts. You will learn how to operate idle IDE and how it can be used to write python program in easier way. Who this book is forThe book is intended for anyone who wish to learn python programming language. This book also covers the syllabus of various universities and readers can use this book as a help in their academic education. This book can be used by readers to start with python programming from basics to advanced level even without having any prior knowledge of python programming. Table of contents1. Introduction to Python2. Python Fundamentals3. Expression and Operators4. Control Statements5. Functions6. List Processing7. Tuple Processing8. Dictionary Processing9. String Processing10. File Processing11. Exception Handling12. Object Oriented Programming13. Inheritance & Polymorphism14. Database Design in Python About the authorRydhm Beri teaches in BBK DAV College for Women, Amritsar, as an Assistant Professor, since last three years and has 5 years of experience in the field of education and 3 years of experience in research. Her research interests include MANETs, Cloud computing, IOT, Fog Computing. She has done M.Sc. Computer Science from BBK DAV College for Women, Amritsar and MCA from Lovely Professional University and is currently pursuing Ph.D. in the field of IOT and embedded systems. She has a deep knowledge of programming and has worked for different projects in languages like, .Net, Java, PHP and Python. Currently she is working on Python programming and relate it to IOT and Machine learning field.She has published 19 research papers out of which 17 are international and 2 are national research papers. She has also been working as a reviewer in conferences and journals. In her leisure time, she likes to attend workshops and conferences and likes to program applications.Her Blog links: https://rydhmberi.weebly.com/Her LinkedIn Profile: https://www.linkedin.com/in/rydhm-beri-47a721101/

Using SQLite

Author : Jay Kreibich
Publisher : "O'Reilly Media, Inc."
ISBN 13 : 0596521189
Total Pages : 526 pages
Book Rating : 4.5/5 (965 download)

DOWNLOAD NOW!

Book Synopsis Using SQLite by : Jay Kreibich

Download or read book Using SQLite written by Jay Kreibich and published by "O'Reilly Media, Inc.". This book was released on 2010-08-17 with total page 526 pages. Available in PDF, EPUB and Kindle. Book excerpt: Explains how to build database-backed applications for the Web, desktop, embedded systems, and operating systems using SQLite.

Learn PyQt By Example: A Quick Start Guide to MySQL and SQLite Driven Programming

Author : Vivian Siahaan
Publisher : SPARTA PUBLISHING
ISBN 13 :
Total Pages : 551 pages
Book Rating : 4./5 ( download)

DOWNLOAD NOW!

Book Synopsis Learn PyQt By Example: A Quick Start Guide to MySQL and SQLite Driven Programming by : Vivian Siahaan

Download or read book Learn PyQt By Example: A Quick Start Guide to MySQL and SQLite Driven Programming written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2019-11-24 with total page 551 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book explains relational theory in practice, and demonstrates through two projects how you can apply it to your use of MySQL 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 MySQL 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 (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.

Python Projects

Author : Laura Cassell
Publisher : John Wiley & Sons
ISBN 13 : 1118908899
Total Pages : 384 pages
Book Rating : 4.1/5 (189 download)

DOWNLOAD NOW!

Book Synopsis Python Projects by : Laura Cassell

Download or read book Python Projects written by Laura Cassell and published by John Wiley & Sons. This book was released on 2014-11-24 with total page 384 pages. Available in PDF, EPUB and Kindle. Book excerpt: A guide to completing Python projects for those ready to take their skills to the next level Python Projects is the ultimate resource for the Python programmer with basic skills who is ready to move beyond tutorials and start building projects. The preeminent guide to bridge the gap between learning and doing, this book walks readers through the "where" and "how" of real-world Python programming with practical, actionable instruction. With a focus on real-world functionality, Python Projects details the ways that Python can be used to complete daily tasks and bring efficiency to businesses and individuals alike. Python Projects is written specifically for those who know the Python syntax and lay of the land, but may still be intimidated by larger, more complex projects. The book provides a walk-through of the basic set-up for an application and the building and packaging for a library, and explains in detail the functionalities related to the projects. Topics include: *How to maximize the power of the standard library modules *Where to get third party libraries, and the best practices for utilization *Creating, packaging, and reusing libraries within and across projects *Building multi-layered functionality including networks, data, and user interfaces *Setting up development environments and using virtualenv, pip, and more Written by veteran Python trainers, the book is structured for easy navigation and logical progression that makes it ideal for individual, classroom, or corporate training. For Python developers looking to apply their skills to real-world challenges, Python Projects is a goldmine of information and expert insight.

Handbook of Computer Programming with Python

Author : Dimitrios Xanthidis
Publisher : CRC Press
ISBN 13 : 1000619559
Total Pages : 631 pages
Book Rating : 4.0/5 (6 download)

DOWNLOAD NOW!

Book Synopsis Handbook of Computer Programming with Python by : Dimitrios Xanthidis

Download or read book Handbook of Computer Programming with Python written by Dimitrios Xanthidis and published by CRC Press. This book was released on 2022-12-12 with total page 631 pages. Available in PDF, EPUB and Kindle. Book excerpt: This handbook provides a hands-on experience based on the underlying topics, and assists students and faculty members in developing their algorithmic thought process and programs for given computational problems. It can also be used by professionals who possess the necessary theoretical and computational thinking background but are presently making their transition to Python. Key Features: Discusses concepts such as basic programming principles, OOP principles, database programming, GUI programming, application development, data analytics and visualization, statistical analysis, virtual reality, data structures and algorithms, machine learning, and deep learning Provides the code and the output for all the concepts discussed Includes a case study at the end of each chapter This handbook will benefit students of computer science, information systems, and information technology, or anyone who is involved in computer programming (entry-to-intermediate level), data analytics, HCI-GUI, and related disciplines.

LEARNING PyQt5

Author : Vivian Siahaan
Publisher : SPARTA PUBLISHING
ISBN 13 :
Total Pages : 524 pages
Book Rating : 4./5 ( download)

DOWNLOAD NOW!

Book Synopsis LEARNING PyQt5 by : Vivian Siahaan

Download or read book LEARNING PyQt5 written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2019-09-06 with total page 524 pages. Available in PDF, EPUB and Kindle. Book excerpt: In this book, you will learn PyQt5 with accompanied by a step-by-step tutorial to develop mysql-base applications. 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 the next three chapters, 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. Aside from learning basic SQL statements, you will also learn step by step how to develop stored procedures in MySQL. First, we introduce you to the stored procedure concept and discuss when you should use it. Then, we show you how to use the basic elements of the procedure code such as create procedure statement, if-else, case, loop, stored procedure’s parameters. In the sixth 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 last chapter, 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. Finally, this book is hopefully useful for you.

How to Do Everything with PHP and MySQL

Author : Vikram Vaswani
Publisher : McGraw Hill Professional
ISBN 13 : 0071466541
Total Pages : 402 pages
Book Rating : 4.0/5 (714 download)

DOWNLOAD NOW!

Book Synopsis How to Do Everything with PHP and MySQL by : Vikram Vaswani

Download or read book How to Do Everything with PHP and MySQL written by Vikram Vaswani and published by McGraw Hill Professional. This book was released on 2005-03-21 with total page 402 pages. Available in PDF, EPUB and Kindle. Book excerpt: This new release in the popular How to Do Everything series explains how to build open source web applications with MySQL and PHP 5. Using these two tools, you’ll be able to create highly functional, interactive web sites easily. Follow along with a step-by-step sample application and, as a bonus, download three full-length case studies complete with code trees.