Join us on a literary world trip!
Add this book to bookshelf
Grey
Write a new comment Default profile 50px
Grey
Subscribe to read the full book or read the first pages for free!
All characters reduced
Python GUI with MySQL: A Step By Step Guide to Database Programming - cover

We are sorry! The publisher (or author) gave us the instruction to take down this book from our catalog. But please don't worry, you still have more than 500,000 other books you can enjoy!

Python GUI with MySQL: A Step By Step Guide to Database Programming

Vivian Siahaan, Rismon Hasiholan Sianipar

Publisher: SPARTA PUBLISHING

  • 0
  • 0
  • 0

Summary

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 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.
Available since: 09/17/2019.

Other books that might interest you

  • Priced Out - The Economic and Ethical Costs of American Health Care - cover

    Priced Out - The Economic and...

    Uwe E. Reinhardt

    • 0
    • 0
    • 0
    From a giant of health care policy, an engaging and enlightening account of why American health care is so expensive—and why it doesn't have to be. 
     
     
     
    Uwe Reinhardt was a towering figure and moral conscience of health care policy in the United States and beyond. Famously bipartisan, he advised presidents and Congress on health reform and originated central features of the Affordable Care Act. In Priced Out, Reinhardt offers an engaging and enlightening account of today's U.S. health care system, explaining why it costs so much more and delivers so much less than the systems of every other advanced country, why this situation is morally indefensible, and how we might improve it. 
     
     
     
    The problem, Reinhardt says, is not one of economics but of social ethics. There is no American political consensus on a fundamental question other countries settled long ago: to what extent should we be our brothers' and sisters' keepers when it comes to health care? 
     
     
     
    An incisive look at the American health care system, Priced Out dispels the confusion, ignorance, myths, and misinformation that hinder effective reform.
    Show book
  • Visions of the Multiverse - cover

    Visions of the Multiverse

    Steven Manly

    • 0
    • 0
    • 0
    The idea of a multiple universe reality is no longer considered speculative or implausible by many physicists; rather, it is deemed inescapable. Distinct concepts of the multiverse spring from quantum mechanics, cosmology, string theory-based cosmology, and ideas about a mathematics based reality that borders on the religious.In this accessible and entertaining book, Dr. Manly guides you on a tour of the many multiverse concepts and provides the non-technical background to understand them.Visions of the Multiverse explores questions such as:•Just what is a multiverse?•What are the different concepts of the multiverse and how are they related?•Is it possible to determine if we live in a multiverse…or even in multiple types of multiverses?•How do religious concepts of the afterlife and popular ideas based on the Law of Attraction relate to the scientific visions of the multiverse?Dr. Manly discusses a wide variety of fascinating concepts from relativity and the fundamental particles and forces of nature to dark matter, dark energy, and quantum mechanics in an unintimidating and conversational tone.Is humanity is in the midst of a new Copernican revolution? You decide.
    Show book
  • Lean Project Management - cover

    Lean Project Management

    Daniel Green

    • 0
    • 0
    • 0
    In the ever-evolving landscape of project management, where adaptability is key and success is measured in efficiency, “Lean Project Management” emerges as the indispensable guide for navigating the complexities of modern projects. 
    This comprehensive book delves into the core principles of Lean Thinking and explores how they can revolutionize project management practices. From understanding the philosophy behind Lean to mastering key concepts like waste elimination, value stream mapping, and continuous improvement, this book provides a roadmap for project managers, leaders, and teams seeking streamlined success. 
    Discover how Lean principles can be seamlessly integrated into project initiation, planning, execution, and closure, revolutionizing each phase for maximum impact. Explore Lean tools and techniques, from A3 Problem Solving to Kanban, and witness their transformative influence on project efficiency. Through engaging case studies spanning industries such as manufacturing, information technology, healthcare, and construction, learn how real-world projects have harnessed Lean methodologies to overcome challenges and achieve unprecedented success. 
    This book isn't just about theory—it's a hands-on guide. Uncover practical insights into Lean in team collaboration, execution, and monitoring, ensuring that every project becomes a dynamic journey of continuous improvement. Overcome challenges, foster team collaboration, and celebrate success with proven Lean practices that stand the test of time. 
    As the future of project management unfolds, “Lean Project Management” also explores emerging trends, including the intersection of Lean with Industry 4.0, the integration of artificial intelligence, and the role of Lean in sustainable development. 
     
    Show book
  • A Philosophical Essay on Probabilities - cover

    A Philosophical Essay on...

    Pierre-Simon Laplace

    • 0
    • 0
    • 0
    Pierre-Simon, Marquis de Laplace (1749-1827) is often described as the ‘French Newton’, though he lived a century later. His working life took him through the French Revolution, the Napoleonic era – during which he enjoyed various political positions – and afterwards, to the Bourbon Restoration. But his overriding importance was his contribution to science, with a remarkable range of interest and expertise including engineering, mathematics, statistics, physics, astronomy and philosophy. One of his most enduring works is recorded here – A Philosophical Essay on Probabilities (1825). As he explains in his opening introduction: 'This philosophical essay is the development of a lecture on probabilities which I delivered in 1795 to the normal schools whither I had been called, by a decree of the national convention, as professor of mathematics with Lagrange. I have recently published upon the same subject a work entitled The Analytical Theory of Probabilities. I present here without the aid of analysis the principles and general results of this theory, applying them to the most important questions of life, which are indeed for the most part only problems of probability'.  
     
    The Essay comprises 18 chapters, including ‘General Principles of the Calculus of Probabilities’, ‘Application of the Calculus of Probabilities to the Moral Sciences’ and ‘Concerning Tables of Mortality and the Mean Durations of Life, Marriage and Some Associations’. He considers the ratio of the birth of boys to girls, he looks at probabilities behind risk when applied to the (increasingly widespread acceptance of) smallpox inoculation discovered by Edward Jenner, he discusses probabilities in games of chance, the reliability of witnesses in jury trials and the fluctuations of tides. He even applies it to the range of feeling in animals analogous to humans.  
     
    The Essay is clear and generally accessible, but also surprising in that the personality of Laplace himself shines through – a brilliant polymath and mathematician who nevertheless lived fully engaged in the everyday world. Translated by Frederick Wilson Truscott and Frederick Lincoln Emory.
    Show book
  • Analytical Chemistry - A Modern Approach to Chemical Analysis - cover

    Analytical Chemistry - A Modern...

    Doris Grants

    • 0
    • 0
    • 0
    Analytical chemistry serves as the cornerstone of modern chemical science, providing the tools and methods necessary to identify the composition and quantity of substances in a wide range of materials. It plays a vital role across numerous scientific disciplines, from environmental monitoring and medical diagnostics to industrial quality control and forensic investigations. The foundation of analytical chemistry lies in its ability to produce reliable, accurate, and reproducible data that informs scientific decisions and supports technological innovation. 
    The scope of analytical chemistry is broad and continues to evolve. It encompasses both qualitative analysis, which seeks to determine what substances are present in a sample, and quantitative analysis, which focuses on how much of each component exists. The discipline is further divided into classical methods and instrumental techniques. Classical methods, such as gravimetric and titrimetric analysis, rely on chemical reactions and physical measurements like mass and volume. Instrumental methods, on the other hand, use complex devices to measure properties such as absorbance, conductivity, or electrical potential, offering faster, more sensitive, and more selective analyses. 
    A critical aspect of analytical chemistry is the systematic approach known as the analytical process. This begins with the formulation of a clear analytical question and proceeds through sample collection, preparation, analysis, and data interpretation. Every step must be carefully controlled and validated to ensure meaningful results. Method validation is essential, involving the assessment of parameters such as precision, accuracy, specificity, and detection limits. These criteria help determine whether a particular method is suitable for its intended purpose.
    Show book
  • Synchronicity - cover

    Synchronicity

    Vic Mansfield

    • 0
    • 0
    • 0
    Even though synchronicity, the term coined by Carl Jung for meaningful coincidences, has attained some renown, according to Mansfield it is badly misconstrued. Here he discusses what synchronicity is, its parallels with quantum mechanics and perhaps why it shows up in our lives. He draws on his studies in physics and Buddhism, as well as his own personal experiences.
    Show book