Learn how to Interact and manipulate SQL Databases from Python GUI
What you will learn
How to set up your Python environment and MySQL Server
Create application GUI with Python
Connecting to MySQL Server in Python
Creating a new Database
Creating a new Table
Create a class with methods in Python
Add new records into Table with Python GUI
Reading Data stored in database from Python GUI
Updating Records from Python GUI
Deleting Records from Python GUI
Interacting with SQL databases using from Python GUI
Description
Python is a popular programming language. It was created by Guido van Rossum, and released in 1991.
What can Python do?
- Python can be used on a server to create web applications.
- Python can be used alongside software to create workflows.
- Python can connect to database systems. It can also read and modify files.
- Python can be used to handle big data and perform complex mathematics.
- Python can be used for rapid prototyping, or for production-ready software development.
- Python works on different platforms (Windows, Mac, Linux, Raspberry Pi, etc).
- Python has a simple syntax similar to the English language.
- Python has syntax that allows developers to write programs with fewer lines than some other programming languages.
- Python runs on an interpreter system, meaning that code can be executed as soon as it is written. This means that prototyping can be very quick.
- Python can be treated in a procedural way, an object-oriented way or a functional way.
What is SQL?
- SQL stands for Structured Query Language
- SQL lets you access and manipulate databases
- SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987
- What Can SQL do?
- SQL can execute queries against a database
- SQL can retrieve data from a database
- SQL can insert records in a database
- SQL can update records in a database
- SQL can delete records from a database
- SQL can create new databases
- SQL can create new tables in a database
- SQL can create stored procedures in a database
- SQL can create views in a database
- SQL can set permissions on tables, procedures, and views
You’ll learn how to pull data from relational databases straight into your Python application.
English
language
Content
Python Setup
Introduction
Install Python
Install Text Editor
What we will create
Building the application graphical interface – GUI
Application design sketch
Creating a project directory
Creating the application GUI : Part 1
Creating the application GUI : Part 2
Creating the application GUI : Part 3
Creating the application GUI : Part 4
Creating the application GUI : Part 5
MySQL Database Server Setup
Install MySQL Server
Create database and table
Create and activate a virtual environment
Install MySQL Connector
Create configuration connection file
Python | SQL Interaction
Creating a class with methods
Creating functions
Activate widgets
Connecting to SQL database from Python
Interacting with database with Python : Part 1
Interacting with database with Python : Part 2
Project Files