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

by Vivian Siahaan, Rismon Hasiholan Sianipar

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 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 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 How to create the initial three tables project in the School 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 Create a main form to connect all forms; Create a project will add three more tables to the school 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.

372 pages, Paperback

Published September 20, 2019

Reviews

[Syed Sirajuddin]

When it comes to database connectivity sections it had lot of error, from page 61, it doesnot work well , tried so many times to comiple the program with schoo.db and teacher table , on the push button the table widgets doesnot fetch the data , it is wasting lot of time loosing interest to read the book, there is no archive to download the software to compare. And there is no help from the author there is no mail or contact address. i have wasted money and time