Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 55 Minute(s)
Language
English
Taught by
Bluelime Learning Solutions
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Learn how to Interact and manipulate SQL Databases from Python GUI
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.
Course Content
- 4 section(s)
- 23 lecture(s)
- Section 1 Python Setup
- Section 2 Building the application graphical interface - GUI
- Section 3 MySQL Database Server Setup
- Section 4 Python | SQL Interaction
What You’ll 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
Skills covered in this course
Reviews
-
AAbdelrahman Moustafa
so far so good
-
KKhaled Amrouni
Great Course
-
MManjit singh
I purchased it already but this course is not for Mac only for windows.
-
IIbsa Rauf Hassen
Amazing
